Download Record (submitted form) to Excel from the power app itself

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi,

Is it possible to have a button to download the current or all records to excel from the power app?

I am not looking to download from the SP List. I want to do it from the APP.

Thankss

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @wonka1234 ,

I would suggest to check this YouTube video from @Reza https://www.youtube.com/watch?v=tQCBWMR7T64
And https://www.youtube.com/watch?v=imhxy3REgXc from Shane Young.

I hope this helps.
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.
Thanks,
ANB

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@ANB i am getting stuck at the collection part... Do I have to use a collection to export ? It seems like both these youtube videos require me to create a collection.. why cant i export content of SP list?

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @wonka1234 , If you want to export content to excel, SharePoint already has that feature.

From App, you need to have content first available locally in collection and then export to excel. You can try with little different action in flow. Rather then sending the collection content from app, you just need to send the SharePoint List name from app to Flow and use Get Items action in flow. Rest other things will remain same.

NOTE: Get Items action from SharePoint has default limit that it will give 100 items and if you want more then you need to change the limit from 100 items to 5000 items. Click on setting and change as per below. Also, you might have to use odata query filter for the performance of your flow.

I hope this helps.
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.
Thanks,
ANB

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@ANB yes i want to export it from the app. In the videos they do something like this on the OnSelect property of a button - - ExporttoExcel.Run(JSON('Collection'))... but im trying to do ExporttoExcel.Run(JSON('SP List Data Source')) . But not sure how to do this? It does nto work for me

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

@wonka1234 : Have you checked my previous response? As mentioned you can create Flow and instead of sending the collection you just need to send the name of list and in Flow you need to use Get Items action and rest all flow will remain same.

------------------------------------------------------------------------------------------------------------------------------
I hope this helps.
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.
Thanks,
ANB

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@ANB but how do i use a button to trigger that ? espeically for the current record im on..

Was this reply helpful? Yes No