Exporting SharePoint List Items to Excel From PowerApps

(0) Share

Report

Posted on by AkshayManke

Hello,

This question is of combination of SharePoint list and PowerApps.

In the SharePoint Lists there is a button to extract all the data in to Excel file. Like below.

I am building an Application in PowerApps, where i want to add a button as 'Extract Data'. On click, i want the same action to be executed similar as i click on 'Export to Excel' button as shown above.

I watched this video of Shane but it is for more complex requirements. But i just need all the list items to be extracted in to an excel file.

Can anyone please help how to do that?

Regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Joel CustomerEffective 3,224 on at

Like (1)

Report
Copy link

Link copied!

So exporting to spreadsheet can take a while depending on how many records are in the app, so my preference is to do it via a background process so the user isn't tied up while the data exports.

Use power automate and write the data to a spreadsheet in one-time, then have the flow notify the user via email, and, push notification, or sending a message back to the app that the export is done with a link to download the spreadsheet

Was this reply helpful? Yes No
Verified answer

AkshayManke 2 on at

Like (12)

Report
Copy link

Link copied!

Hello @jlindstrom,

I got a workaround for the same. Below the steps.

1. I clicked on the Export to Excel button in the Sharepointist.
2. After clicking, one query file is created.
3. I downloaded the files and uploaded in the the same site in a folder.
4. Copied the link of the file.
5. Embedded the link in the button in PowerApps using Launch() function.

That's it.!!

Now when the user is clicking on the button, all the list contents are getting downloaded in excel file without using any flow etc.!

Still, thanks for your suggestion. !!

Regards,

Was this reply helpful? Yes No
Prabhu_Rajaram on at

Like (0)

Report
Copy link

Link copied!

if i do the above, again it is referring to download the query, not the data.

Was this reply helpful? Yes No
RS-03100658-0 8 on at

Like (0)

Report
Copy link

Link copied!

Hi I did work on the suggestion that u have given but I can only get the static data if any new entry entered it will not show the refreshed data any help for this

Was this reply helpful? Yes No