Answered

Export sharepoint data to csv with button in PowerApp

(0) Share

Report

Posted on by batmanMon

202

Hi could someone please help me with some guidance, steps by step how to export all records from sharepoint, but with a click in the button in powerapp. I watched a couple fo youtube videos, but they are old, the functions dont exist anymore.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Pstork1 69,129 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The easiest way to do that is to use the Power App button to Invoke a Power Automate flow. The flow would then do the following

1) Use Get Items to retrieve all the records

2) Use Data Select to trim the output down to the specific columns you want in the CSV

3) Use the Create CSV table to turn the output of #2 into a CSV

4) Use Create file to create the CSV file in either SharePoint or OneDrive

5) Or use the CSV table as the body of an attachment to an email.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
batmanMon 202 on at

Like (0)

Report
Copy link

Link copied!

thank you Pstork1 so much for your reply! I created a flow. just have one more question how do you trigger the flow from within the power app

Was this reply helpful? Yes No
Verified answer

batmanMon 202 on at

Like (1)

Report
Copy link

Link copied!

found perfect video. The only solution that actually works. Easy to follow. Clear explanation of each step.

https://www.youtube.com/watch?v=-QvoYm0_jhM

Was this reply helpful? Yes No