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