Answered

Export Sharepoint list to CSV

(1) Share

Report

Posted on by jms345

117

I am struggling to create a Flow which simply exports a Sharepoint List to CSV. I can use a manual trigger with an INPUT, GET ITEMS and use the INPUT to Filter records, it then Saves a CSV in the Doc ilbrary with the Filter as a name, but the column headings have to be the Internal Fieldnames. I have 153 columns and would like the export to show the Display names (as the export is intended as a backup in case we reach 5000 records in the List)

I have created a txt file with the Display Names in Row 1 and the Internal names in Row 2. Can I use this to replace the CSV file headings?

When the CSV is correctly exported and verified I want to delete the exported records from the LIST

Any help with steps greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (1)

Report
Hi @jms345

After your Get items action add a Select and Create CSV table action:

Note the From value in the Select action below. Give each of your columns a suitable name and then select the equivalent SharePoint column:

Note the From value in the Create CSV table action:

Here is my sample CSV file output
ID Number,Invoice Title,Status,Requested By 1,Dell Invoice,Rejected,Ellis Karim 2,PC world invoice,Approved,Ellis Karim 4,happy,Approved,Ellis Karim 5,ok1,Approved,Ellis Karim 6,Apple,Rejected,Ellis Karim 7,1234,Rejected,Ellis Karim 9,343242,Cancelled,Ellis Karim 10,45453,Approved,Ellis Karim 11,234242,Approved,Ellis Karim 14,122324234,Cancelled,Ellis Karim 15,99999,Cancelled,Ellis Karim 16,Demo,Approved,Ellis Karim

Finally, add a save file action.

The Top Count in the Get Items action can return up to 5000 items:

If you want to get back more than 5,000 items enable pagination in the Get Items action:

See: 🔍How to Find the Internal Name of a SharePoint Column – Ellis Karim's Blog

Ellis Karim

Blog: https://elliskarim.com

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

You can use a Data Select action to specify which columns you want to export. Using the Data Select you can also change the column name to whatever you want it to be. It will require some work setting up since you have so many columns, but that's the only way to get the display names.

----------------------------------------------------------------------------------
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
Verified answer

Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (0)

Report

jms345 has found a solution:

Thanks - somehow my profile has got mixed up and I can't login with my original email.

I would like to thank you for your assistance so far; I actually found a solution on Youtube through Reza Dorrani, who has provided this excellent guide: Export Data to Excel from Power Automate | Bulk Add Rows in One Action

jms345

Was this reply helpful? Yes No