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 / SharePoint list data d...
Power Apps
Unanswered

SharePoint list data download through PowerApps

(0) ShareShare
ReportReport
Posted on by 264

Hi All, 

 

I want to download SharePoint list data through Canvas app. Can you please share solution on it.

 

Thank you Everyone.

 

Categories:
I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    on at

    Hi @BJ94 ,

     

    Could you tell me what type of file do you want to download?

    Assuming it's csv file and I made a sample for you.

    Create a list in SharePoint with the following contents:

    vxiaochenmsft_0-1666338178999.png

    Add a button to the canvas, and the button 'OnSelect' property is set as follows:

    vxiaochenmsft_1-1666338205222.png

     

    Set(var1,ShowColumns(Test1,"Title","first","last"));
    Set(var2,JSON(var1,JSONFormat.IndentFour));
    'PowerApp->Compose'.Run(var2)
    

     

     

    Create a flow and get the value of the variable 'var2'.

    vxiaochenmsft_2-1666338241921.png

    vxiaochenmsft_3-1666338253134.png

    After running, find the run history of the flow in PowerAutomate, copy the output.

     

    Add a Parse JSON, copy the above output to Generate from Sample.

    vxiaochenmsft_4-1666338283718.png

    Add a 'Create CSV table'.

    vxiaochenmsft_5-1666338302250.png

    Add a 'Create file' with the file name as the table name. CSV. The file content is a CSV table.

    vxiaochenmsft_6-1666338319703.png

    vxiaochenmsft_7-1666338326639.png

     

    Best Regards,

    Wearsky

  • BJ94 Profile Picture
    264 on at

    Hi @v-xiaochen-msft 

     

    Thank you for this solution.

     

    Now my new query is like in this flow if I want to add parallel branch for different lists.

     

    Then what action we can add, or for match the List and add the flow?

     

    Thanks

    Bharti

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