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