Guest User

Untitled

a guest
Jan 16th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. $hashTable = @()
  2. $items = Get-PnpListItem -List "MySchedule"
  3. foreach($item in $items)
  4. {
  5. $HashTable += New-Object psobject -Property @{
  6. 'Datum'=$item.FieldValues.Datum.ToLocalTime().ToString("dd.MM.yyyy");
  7. '00:00 - 07:59'=$item.FieldValues._x0030_0_x003a_00_x0020__x002d__;
  8. '08:00 - 16:59'=$item.FieldValues._x0030_8_x003a_00_x0020__x002d__;
  9. '17:00 - 23:59'=$item.FieldValues._x0031_7_x003a_00_x0020__x002d__;
  10. 'Opmerkingen'=$item.FieldValues.Opmerkingen;
  11. }
  12. }
  13. $hashTable | Select Datum,'00:00 - 07:59','08:00 - 16:59','17:00 - 23:59',Opmerkingen |
  14. epcsv "c:tempmyschedule.csv" -NoT
Add Comment
Please, Sign In to add comment