Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

January 2021

VIDEO PowerShell – Convert MS Office (DOC/XLS/etc) to PDF and Merge PDF

Wanted to record live coding video for how to use PowerShell to convert any Microsoft Office source file (DOCX / XLSX / PPTX / etc.) into PDF and then merge all PDF into a single combined PDF.

Features include:

  • Convert DOCX, DOC, DOT to PDF
  • Convert XLSX, XLS, CSV to PDF
  • Convert PPTX, PPT to PDF
  • Convert PUB to PDF
  • Convert VSD, VSS to PDF
  • Merge many PDF into single multi-page PDF
  • Dependency on local MS Office “Interop” DLL for conversion
  • Dependency on “itextsharp.dll” for multi-page PDF merge

Cheers.

Source Code

Video

Screenshots

References

VIDEO – Export SPO all UPS to flat CSV with PowerShell

Video demo of [Export-SPO-All-UPS] PowerShell to export all SharePoint Online (SPO) user profile service (UPS) values to flat CSV file. Cheers

Video

Source Code

  • https://github.com/spjeff/office365/blob/master/office365-export-profiles/Export-SPO-All-UPS.ps1

References

  • https://www.microsoft.com/en-us/download/confirmation.aspx?id=42038
  • https://gist.github.com/asadrefai/ecfb32db81acaa80282d
  • https://community.idera.com/database-tools/powershell/ask_the_experts/f/learn_powershell_from_don_jones-24/2824/exporting-key-value-pair-using-export-csv-cmdlet
  • https://sharepoint.stackexchange.com/questions/108664/powershell-script-for-user-profile-properties-in-sharepoint-online-2013

VIDEO – Workflow 2010 Deprecated User Experience (UX)

Wanted to share brief demo of the user experience in web browser and SharePoint Designer after Microsoft deprecates the Workflow 2010 feature.   SharePoint Designer 2013 continues to display the workflow menu and definition.  However, during publish we see the error below.   Web browser view displays a yellow toolbar with link to learn more about the deprecated removed feature.   Tenant used for this video is set to “first release” for early preview and in that case is showing the Workflow 2010 feature removed sooner than other tenants.   Sharing this information with site owners early can help steer towards Microsoft Flow (PowerAutomate) and plan for replacement features.

Cheers 

shades_smile

Video

Error Message

Errors were found when compiling the workflow.  The workflow files were saved but cannot be run.


Unexpected error on server associating the workflow

Screenshot

image

References

How to switch to PNP.PowerShell (PS7) from SharepointPnPPowerShellOnline (PS5.1)

Wanted to record a quick demo for how to switch from the current established “SharepointPnPPowerShellOnline” module into new “PNP.PowerShell” module based on .Net Core.   Shout out to @ToddKlindt for the great blog post.   Cmdlets and references below.  Cheers

shades_smile

Video

Source Code

Uninstall-Module SharePointPnPPowerShellOnline –AllVersions
Install-Module PnP.PowerShell –AllowPrerelease
Register-PnPManagementShellAccess

References

PnP PowerShell RoadMap

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲