Answered

Create CSV file from Power Automate with column headers in different order

(0) Share

Report

Posted on by Dimo

Hello everyone. Long time i try to solve this issue, but cannot figure it out so far. Read a lot of posts here, internet, youtube... etc.

I have SP List and from that list I create collection CBCOLLECTFIN like drop some unused fields.

SPList:

After creating some variables, executing CSVEXPORTFIN.Run power automate flow:

----------------

Set(varDroppedColumn,DropColumns(CBCOLLECTFIN,"Account","Author","AutoNumber","ComplianceAssetId","DDS","EGN","Editor","Invoice","Product","Invoice_Billing","{Path}","{FilenameWithExtension}","{FullPath}","{Identifier}","{IsFolder}","{Link}","{ModerationComment}","{Name}","{Thumbnail}","{TriggerWindowEndToken}","{VersionNumber}","{ModerationStatus}","{TriggerWindowStartToken}"));
Set(varFormattedJSON,JSON(varDroppedColumn,JSONFormat.IndentFour));
CSVEXPORTFIN.Run(varFormattedJSON)

----------------

Power automate flow CSVEXPORTFIN:

Third step in the flow is Create CSV table:

This flow is working, but the headers in CSV file is in alphabetical order. I want different order. Probably, I have to use CUSTOM columns, but I don't know how to approach VALUES dynamically. I know, that collection in powerapps has build-in behavior of alphabetical order creation, regardless SPList columns order.

Can you help?

Categories:

Building Power Apps

All responses (7)

Answers (2)

Sort by

Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Dimo ,

If you want your columns in order, you need to go back to the "old school" way of sending a Text file using Concat

UpdateContext( { varCSVFile, "Header1,Header2,Header3,Header4" & Char(10) & Concat( DataSource, Field1 & "," & Field2 & "," Field3 & "," Field1 & Char(10) ) } )

then it gets much easier in the Flow as the output is already a CSV file and you do not need any of the JSON or file creation stuff.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Dimo 28 on at

Like
a
(0)

Report
Copy link

Link copied!

HI WarrenBelz,
Thanks. I will try this.
dbp 10 on at

Like
a
(0)

Report
Copy link

Link copied!

This likely happens because of empty cells in the first row of the (to be) csv.

A scalable elegant solution is possible, I've answered it here for a similar PowerBI problem.
Verified answer

rcallan 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Ideally the order of the columns should match the order of the inputted data. There is already an idea for reordering columns in the Microsoft Forum which needs a lot of votes to be considered. I have created a generic, Export to CSV function which I use across multiple apps so having the output of the csv to match the input data would make more sense.

Here is the link to the idea or search for 'Reorder Capabilities for Create CSV Table' in the Community / Submit ideas and vote for it if you think it a good idea

https://ideas.powerautomate.com/d365community/idea/286b433a-f43d-4fb9-8e64-5aacd7b01ec5
Dimo 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi rcallan,
Thanks for the answer and suggestion. I will take a look. 🙂

Regards,
Dimo
Hack-7 226 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz how would you do this if working with a gallery?

Currently, I am doing a
ForAll(
galleryName.AllItems,
Collect(
collectNameToExport,
{
ID: ThisRecord.ID, Blah: ThisRecord.someInfo
}
)
)
WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@Hack-7 ,

The same format as I posted except the Data Source would be the Gallery.