• April 14, 2023

Launch multiple M365 tenant PowerShell PNP console

Demo how to quickly launch multiple M365 tenant PowerShell PNP console. When supporting PROD, TEST, DEV lifecycle or have multiple M365 tenants we can leverage Devolutions Remote Desktop Manager (RDM) to have many PowerShell “profiles” and quickly authenticate with Client ID and Client Secret.

Great for M365, SharePoint Online SPO, and PowerPlatform tasks including:

• View SharePoint sites
• Increase SharePoint site quota
• Grant SharePoint site administrator
• Create SharePoint Site App Catalog
• Generate CSV reports of sites and usage
• Provision OneDrive users
• Review M365 tenant security settings

Download RDM

https://devolutions.net/remote-desktop-manager/home/downloadfree

POWERSHELL

# Configuration
$SiteURL        = "https://TENANT-admin.sharepoint.com/"
$ClientID       = "GUID-HERE"
$ClientSecret   = "SECRET-HERE"
# Connect to the Site
Connect-PnPOnline -URL $SiteURL -ClientID $ClientID -ClientSecret $ClientSecret -WarningAction "Ignore"
Get-PnPTenantSite | Format-Table -AutoSize

VIDEO

SCREENSHOT

REFERENCES

https://medium.com/ng-sp/sharepoint-add-in-permission-xml-cheat-sheet-64b87d8d7600

https://pnp.github.io/powershell/

https://pnp.github.io/powershell/cmdlets/Connect-PnPOnline.html

• April 14, 2023
• No Comments
• Uncategorized

• April 11, 2023

PowerAutomate bypass Microsoft disable inactive MS Flow and always Turn ON

Microsoft 365 has feature with Power Automate to disable infrequently used MS Flow.

Demo will show how to force Turn ON all MS Flow in your tenant. Automatically re-enable flows that were suspended give stability for business process with quarterly, annual, or longer normal times between run.

Cheers.

VIDEO

SCREENSHOTS

REFERENCES

• https://sharepoint.stackexchange.com/questions/286199/power-automate-disabling-infrequently-used-flow
• https://ideas.powerautomate.com/d365community/idea/e8658509-d973-4403-b7c2-0e876e36b442
• https://powerusers.microsoft.com/t5/General-Power-Automate/Prevent-unused-Flows-from-being-turned-off/td-p/741450

• April 11, 2023
• No Comments
• Uncategorized

• April 5, 2023

SharePoint Online Communication Site – Apply “Site Template” with 11 choices

Demo of how to apply “Site Template” to Communicate sites, and reverse changes to Microsoft default Communicate site.

As of today (4/5/2023) there are 11 “Site Template” choices available each with different deployment artifacts.

Cheers.

VIDEO

REFERENCE

• Use the SharePoint Topic, Showcase, and Blank communication site templates
• Apply and customize SharePoint site templates
• Create a communication site in SharePoint

• April 5, 2023
• No Comments
• Uncategorized

• February 11, 2023

Turbo SQL to SharePoint List Sync (PowerShell PS1)

PowerShell script to read source SQL table and synchronize into SharePoint Online (SPO) List destination. Great for PowerPlatform, PowerApps, and PowerBI integration scenarios. Optimized with usage of primary key, index columns, [Compare-Object] cmdlet [System.Data.DataRow] type, hashtable, and PNP batch HTTP POST network traffic. Cheers.

VIDEO

SCREENSHOTS

SOURCE CODE

• https://github.com/spjeff/Turbo-SQL-to-SharePoint-List-Sync

REFERENCES

• https://jeffbrown.tech/powershell-hash-table-pscustomobject/
• https://learn.microsoft.com/en-us/dotnet/api/system.data.datarow?view=net-7.0
• https://michalsacewicz.com/add-items-to-a-sharepoint-list-with-powershell-pnp-vs-batch-requests-to-graph/
• https://www.sharepointdiary.com/2021/07/sharepoint-online-bulk-add-update-delete-in-batches-with-new-pnpbatch-powershell.html

• February 11, 2023
• No Comments
• Uncategorized