Power Platform Community Forum Thread Details

I am exporting data from a SharePoint List to a CSV file in a SharePoint folder, which works for a single list.

Used Get Items--

Site Address - Link of Sharepoint List
List Name - b2364e74-12d7-4a6c-8d61-7e86f863fb79
Limited Entries to Folder - /Repository
Include Nested Items - Yes

Question 1:
I have multiple SharePoint List links, and I need to select multiple folders (each containing a repository) to export all data into a CSV file. How can I achieve this?

Question 2:
How can I ensure that the saved CSV file replaces the existing one? I get an error when the file already exists.

Any other tip if I can add multiple links at once and get data from all of them where folder contains 'Repository' will be fantastic.

Attaching screenshot which is working for one link,

Categories:

Building flows

To export data from multiple SharePoint Lists to a CSV file, you can loop through each list and append the data to a single CSV file.

Here’s a step-by-step guide:

Create a List of SharePoint List Links:
- You can store all the SharePoint List URLs in an Excel file.
Read the Excel File:
- Add an action to read the Excel file containing the SharePoint List URLs.
Loop Through Each SharePoint List:
- Use an "Apply to each" action to loop through the SharePoint List URLs.
Get Items from Each SharePoint List:
- Inside the loop, use the "Get items" action to retrieve the items from the current SharePoint List.
Append Data to CSV:
- Append the data retrieved from each SharePoint List to a CSV file.
Save the CSV File to SharePoint:
- Save the CSV file to a designated folder in SharePoint.