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
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