Import user profile pictures to SharePoint using PowerShell

Best solution to create Automatic UserProfile Import to SharePoint Create folder “ImportProfileImages” Create subfolder “ProfileImages” Create “c:\SPSolutions\ImportProfileImages\UpdateUserProfiles.ps1” with the code from SharePoint Use Cases Create “c:\SPSolutions\ImportProfileImages\RunUpdateUserProfiles.ps1” with this code: Save …

Read more

DateDif in SharePoint

The function for calculating the difference between two dates in a calculated column in SharePoint, without counting the weekends: =(DATEDIF([Start Date];[End Date];”D”))-INT(DATEDIF([Start Date];[End Date];”D”)/7)*2-IF((WEEKDAY([End Date])-WEEKDAY([Start Date]))<0;2;0)+1