Unanswered

Changing column headers

(0) Share

Report

Posted on by azizrasul

124

Using a combination of PowerApps and Power Automate, I have managed to transfer a collection to a Excel file using a flow. In order to 'force' the columns to be in a specific order, I have numbered the column header names by a preceding number so the columns are now in the correct order when the collection is created.

I now want to change the column headers in the resultant Excel file. Is there a way of doing this either using PowerApps or Power Automate? So for example I want to change

"1 - First Name" to "First Name"

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

mmollet 3,187 on at

Like (0)

Report

I know you can run office scripts from power automate. These scripts are written in what is essentially javascript if I remember correctly. I have used them in google sheets to take a csv ouput from a webpage and formate it to go into sharepoint. Very easy to code and I have some that delete columns, move them, then rename them all in the same script with around 20 lines of code.

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (0)

Report

Hi @azizrasul ,

Agree with @mmollet here about the running scripts way to achieve this.

And just by the way, maybe you can also try below way of creating the table with transferred collection from canvas app:

I mean, you can directly change any specific column name when creating the table firstly and then add rows into this table.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
azizrasul 124 on at

Like (0)

Report

I have already created a flow (see screenshot below) that exports a data collection from PowerApps to a CSV file using Power Automate.

Is their a trigger\action that I can use to update cells in the column header row and simply change the current value say in cell A1 to a different value and so on with the rest of the column header names?

Was this reply helpful? Yes No
azizrasul 124 on at

Like (0)

Report

If I have 1000's of rows of data in a collection, can I transfer the collection in one swipe to the newly created table?

Was this reply helpful? Yes No