You’re offline. This is a read only version of the page.
2
Hi,
I have flow for synchronize between Sharepoint List and MS SQL database. I need some way for synchronize existing list items into SQL.
Hi @mladek2,
We could take use of SharePoint Get-Items, then use the filter query to remove the items already added into SQL table, better based on the create time of the item.
Things to note:
1. Filter Query uses ODATA filter format, please check the Reference for more details,
2. If Maximum Get Count value is not specified, the default is 512, which means only 512 items would be queried in Get items action,
3. Apply to Each item has a 5000 limitation, which means currently only 5000 items could be added.
4. Trigger here is Flow Button, if all the available data has been updated, please consider turn this flow off.
Hope this helps,
Regards,
Michael
Share
Report
All responses (
Answers (
