Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : CJvrPdPeqNJp52aIryC9Fa
Power Platform Community / Forums / Power Apps - Building Power Apps / Can someone explain ho...
Power Apps - Building Power Apps
Unanswered

Can someone explain how to export SQL database into Excel using flow in Powerapps?

Like (0) ShareShare
ReportReport
Posted on 17 Jul 2017 17:59:43 by Community Power Pla...

Hello Everyone!

Can someone explain how to export SQL database into Excel using flow in Powerapps?

 

Thank you.

  • Meneghino Profile Picture
    Meneghino 6,949 on 17 Jul 2017 at 18:53:24
    Re: Can someone explain how to export SQL database into Excel using flow in Powerapps?

    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:

    https://powerusers.microsoft.com/t5/PowerApps-Ideas/Save-collection-to-the-local-device-as-an-Excel-file/idi-p/15185

     

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,668 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans