web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Does anyone know how t...
Power Apps
Unanswered

Does anyone know how to export the data from PowerApps to Excel?

(0) ShareShare
ReportReport
Posted on by 284

Does anyone know how to export the data from PowerApps to Excel? Or a click of a button from Powerapps allow user to export data from Sharepoint ? I am using Sharepoint as my datasource.

Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    153,034 Most Valuable Professional on at

    Hi @sbgoh ,

    You cannot easily "export" to Excel from Power Apps, however I simply create report Views in SharePoint and export directly from them.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • v-yutliu-msft Profile Picture
    on at

    Hi @sbgoh ,

    Do you want to export data from powerapps to excel or sharepoint ?

    I'm afraid it's not supported to export data from powerapps.

    Please notice that:

    powerapps app is just an app. It is not a data source. It could not store any data. So there's no data that you could export.

    You could only export app from powerapps app.

     

    If you want to export data, you need to export from a data source.

     

    If you want to export data from sharepoint to excel, you do not need to use powerapps.

    In sharepoint, there's already a feather about this:
    7141.PNG

     If you want to trigger this feather by clicking a button in powerapps,  you could consider using collect function.

    Firstly collect all the data from sharepoint list to collection. Then use collect function to save all these data to excel.

    Just like this:

    Collect(collection1,listname);
    Collect(exceltable,collection1)

     

     

     

    Best regards,

  • WarrenBelz Profile Picture
    153,034 Most Valuable Professional on at

    Thank you @v-yutliu-msft for expanding on my post.

    @sbgoh - happy to assist further if required.

  • sbgoh Profile Picture
    284 on at

    My users don't have access to sharepoint. Any way to use flow to do it and email to the user?

  • WarrenBelz Profile Picture
    153,034 Most Valuable Professional on at

    @sbgoh ,

    You can create a HTML table and using a Flow email it to the user - here is a video from Shane Young and another from Chino Does Stuff that may assist.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

     

  • sbgoh Profile Picture
    284 on at

    My user want excel either download to his local PC or email him. I am trying using Flow. But there are some redundant text in the field when I generate a csv file. My field is a Sharepoint LookUp field. Is it possible to get rid of it?

     

    sbgoh_0-1594726108153.png

     

  • Verified answer
    v-yutliu-msft Profile Picture
    on at

    Hi @sbgoh ,

    I'm afraid it's not supported to get rid of these redundant text for lookup field.

    They are all generated by system, which is because of the lookup data type.

     

     

    Best regards,

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard