Unanswered

Export Excel to CSV Not Sorted as in the Source Table

(0) Share

Report

Posted on by robsims99

I've got a Power Automate Flow embedded in a Power BI Report (using the Power Automate Object), it utilises the data in Power BI to create an Excel table (additional calculations are carried out) and then the table is exported to a .csv file, one of the steps in the flow is to sort the table into a specified order, however, when the table is exported to the .csv, the order is all over the shop. Is there a way of retaining the sort order from the table in the .csv export?

This is the business end of my flow...

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-jefferni on at

Like (1)

Report

Hi @robsims99 ,

Do you want to export an Excel table to a CSV file, and the rows of result are in a specific order?

Based on your description, I have made a simple test for your reference.

Here is my table:

In my test, I want that rows are in a descending order, sort by “num” column.

Result:

Best regards,

Was this reply helpful? Yes No
robsims99 11 on at

Like (0)

Report

Hi,
Perfect, thank you, works great!!

Cheers,

Rob.

Was this reply helpful? Yes No