Forum Discussion
Synchronising SharePoint Online lists with SQL
Hi everyone I'm after a bit of advice on the best ways of getting external data into SharePoint Online. Currently we have users that use mobile devices to write into an on-premise SQL database b...
You might be able to use flow. I remember doing this once using the Data Gateway. Since I didn't have many records I just deleted all the items in the SharePoint list and then added new ones based on a SQL query from an on-premise SQLServer database.
I think I thought of a couple of ways to get only new or changed records but, for what I was doing, deleting and recopying the records was fine and much quicker.