Answered

Download sharepoint list to csv using powerapp without using power automate.

(0) Share

Report

Posted on by devesh

I there a way to download sharepoint list to csv or excel without using power automate.
may be Download function can be used with some concatenate columns.

Thanks in advance !

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report
Hi @devesh

You could just export the sharepoint list to csv:

Export to a CSV file
When exporting to CSV, you can export a maximum of 30,000 rows of data.
Open the list whose data you want to export.
From the command bar above the list, select Export > Export to CSV as the type of data output.
(On macOS, from the command bar above the list, simply select Export to CSV.)
Note: The Export option is available only when list items are not selected.
Select Open to open the file in Excel. Then you can save the file as an Excel workbook, which allows you to add format the data as you like.
Alternatively, select Save as to save the file in .csv format on your computer.
Source: https://support.microsoft.com/en-us/office/export-to-excel-from-sharepoint-or-lists-bfb2ea48-6118-4fa9-abb6-cced9424e5d9#:~:text=Open%20the%20list%20whose%20data,list%20items%20are%20not%20selected.
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
devesh 13 on at

Like (0)

Report

have to user powerapp button only

Was this reply helpful? Yes No
Verified answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report
@devesh

Try to collect the Sharepoint List in a Collection.

//Create a collection ClearCollect(SPList, {OrderID: 1001, Item: "Notebook", UnitsOrdered: 25, CostPerUnit: 2.5}, {OrderID: 1002, Item: "Crayons", UnitsOrdered: 15, CostPerUnit: 8.62}, {OrderID: 1003, Item: "Binders", UnitsOrdered: 10, CostPerUnit: 13.34}, {OrderID: 1004, Item: "Pencils", UnitsOrdered: 21, CostPerUnit: 1.5}, {OrderID: 1005, Item: "Erasers", UnitsOrdered: 30, CostPerUnit: 0.89} ); //Collection to CSV code ClearCollect(myCSV,{csvString:"OrderID,Item,UnitsOrdered,CostPerUnit"&Char(10)}); ForAll( myOrders37, Patch( myCSV, First(myCSV), {csvString: First(myCSV).csvString&OrderID&","&Item&","&UnitsOrdered&","&CostPerUnit&Char(10)}) ); Set(mySolution37,First(myCSV).csvString)

Then use the button.Onselect

Copy(mySolution37)

Paste that in Excel.

Source: https://www.matthewdevaney.com/powerapps-collections-cookbook/export-a-collection-to-a-csv/

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No