Hello Everyone!
Can someone explain how to export SQL database into Excel using flow in Powerapps?
Thank you.
Hi @Anonymous, unfortunately there is currently no easy way of doing that in PowerApps.
If you want to report your data in Excel from SQL Server, the best way to do it is using Excel's Get&Transform, which works very well.
Once we get the following capability, then it will be easy also in PowerApps:
I would not recommend doing it with flow, it is possible but gets very messy very quickly. You can also do it just with PowerApps using Collect() into an Excel file (After having Remove() all records), but it is also not very elegant.
PS I now notice you have seen this, so not sure my reply helps you in any way, sorry.
WarrenBelz
223
Most Valuable Professional
MS.Ragavendar
108
stampcoin
80