Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $hashTable = @()
- $items = Get-PnpListItem -List "MySchedule"
- foreach($item in $items)
- {
- $HashTable += New-Object psobject -Property @{
- 'Datum'=$item.FieldValues.Datum.ToLocalTime().ToString("dd.MM.yyyy");
- '00:00 - 07:59'=$item.FieldValues._x0030_0_x003a_00_x0020__x002d__;
- '08:00 - 16:59'=$item.FieldValues._x0030_8_x003a_00_x0020__x002d__;
- '17:00 - 23:59'=$item.FieldValues._x0031_7_x003a_00_x0020__x002d__;
- 'Opmerkingen'=$item.FieldValues.Opmerkingen;
- }
- }
- $hashTable | Select Datum,'00:00 - 07:59','08:00 - 16:59','17:00 - 23:59',Opmerkingen |
- epcsv "c:tempmyschedule.csv" -NoT
Add Comment
Please, Sign In to add comment