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...
gjayne84 As of now Flows for external list are not available. Use Flows with sql for notifications. We can create external list with BCS
- Thanks for the reply. As mentioned in my original post I've looked into BCS but this is no good as I can't then work with these external lists or external fields using PowerApps and Flow so this is a no-go.
I've looked into this a bit more and I think one way may be to connect PowerApps directly to our Azure SQL databases. We did want to display data on pages in SharePoint so I suppose we could then embed PowerApps into pages to display data as well as edit, rather than displaying data in lists and list view web parts in SharePoint.