Exported CSV data is changing the table order

(0) Share

Report

Posted on by Community Power Pla...

I have a flow that is setup as follows. Get items obtains data from a Sharepoint list. Create a CSV table from that value. Update a CSV file on One Drive, and it re-occurs regularly. Originally every hour, now every 10 minutes.
That CSV is then loaded into Excel, and has formulas that sort the data.
The spreadsheet is quite large with the columns pushing out to ES.
The issue is that twice in the last week the output re-organizes the tables. It changes them around slightly which throws off the Excel formulas.
More data is being added to Sharepoint, but there is nothing there that has changed, and no additional data fields have been added.
Is there a way to make the output more consistent?

I have the same question (0)

All responses (2)

Answers (0)

Mira Ghaly 11,409 Moderator on at

Like (0)

Report

Re: Exported CSV data is changing the table order

@Anonymous
Please try using the order by on your getitems so you can sort your data before inserting in your CSV file.

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it

Was this reply helpful? Yes No
dbp 10 on at

Like (0)

Report

Re: Exported CSV data is changing the table order

This likely happens because of empty cells in the first row of the CSV.
I've answered it here.

Was this reply helpful? Yes No