web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Is there an easy way t...
Power Automate
Answered

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

(0) ShareShare
ReportReport
Posted on by 22

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?

 

 

I have the same question (0)
  • Verified answer
    Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    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.

     

  • asbkr Profile Picture
    22 on at

    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".  

  • AnkitK Profile Picture
    2 on at

    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

     

  • JU-16021540-0 Profile Picture
    2 on at
    Absolutely there is. 

    Convert the table to text (convert to csv text action).
    Replace column names with desired text via Replace action
    and then use the action called: Read csv text - that will again create the table. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 223

#2
David_MA Profile Picture

David_MA 195 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 167

Last 30 days Overall leaderboard