You’re offline. This is a read only version of the page.
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
@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
@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
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
@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?
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
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
