Unanswered

Is there an easy way to change column header names in a table in Power Automate Desktop

(0) Share

Report

Posted on by asbkr

I have a table in Power Automate Desktop which contains some data, and I want to change the names of the column headers in the table without losing the rest of the data in the table.

I know I could just make a new table with correct coloumn header names and copy/write the data to the new table, but is there a easier way to do it?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like (1)

Report

No. Table columns are not editable. You need to create a new table to do this.

However, where exactly do you get those columns from? If it's a web table that you read via Extract data from web page or a database table that you get via Execute SQL statement, you can set the column names yourself.

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

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
asbkr 20 on at

Like (1)

Report

Thanks for your responds, then I will stop looking for the "easy way" 🙂

And yes, in this particular case I get the column names via Execute SQL statement, so I will change them during the "import".

Was this reply helpful? Yes No
AnkitK 2 on at

Like (0)

Report

Hello @asbkr ,
Following is a work-around desktop
What I did was run.net script with InOut argument and passed the ExcelData as both Input and output value.
In Script we Write
DT1.Columns[0].ColumnName = "Column1";
DT1.AcceptChanges();
This workder for me.

Regards
AK

Was this reply helpful? Yes No