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

Community site session details

Session Id : TRQ6zkCv0v7WBQzrmlcX9W
Power Automate - Building Flows
Unanswered

Add Step to Change Sharepoint Column Names

Like (0) ShareShare
ReportReport
Posted on 29 Oct 2023 07:40:15 by 40

Hi, 

 

I am building a flow that captures changes in a Sharepoint List and sends an email alert accordingly. However, as many SP list users would know, the column headers have been renamed and have spaces - hence they all look something like 'columnx200xname' or 'field_7' when the final alert email is sent.

 

My proposed solution is to add a step that converts the troubled column names to their actual ones, using strings. I have captured all troubled column names through the response of one of the runs, and compiled them in an Excel list, and wrote the correct ones in a column next to it - creating something like a mapping table. However, I am not sure how to best approach this - should I add this list to another SP list for the mapping and have the flow reference it? Or is there a better way to do this conversion in a step that I can add to my flow? Thank you

 

Regards, May.

  • mayalghamdi Profile Picture
    40 on 29 Oct 2023 at 12:56:17
    Re: Add Step to Change Sharepoint Column Names

    hi - thanks for your response, however, i am not interested in changing the column name on the SP list itself - i just want it to be changed on the final email alert. 

     

    the flow currently does this: if column 'first name' is modified, it sends an email alert of the modification with both old and new values, however, it looks something like this 'field_7 is now changed to 001 - previous value is 002'. the reason why the email looks like this is because the SP list column is either recently added or because it was recently renamed - my proposed solution is to do a conversion step e.g. before the flow sends an email, evaluate the column name and convert it accordingly (e.g. field_7 should be changed to 'first name' on the final email alert). I hope this helps explain my issue better. 

     

  • JonDoesFlow Profile Picture
    1,304 on 29 Oct 2023 at 11:09:25
    Re: Add Step to Change Sharepoint Column Names

    hey @mayalghamdi, I think this post/solution will help you:

     

    https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Power-Automate-rename-columns-sharepoint-list/td-p/2019862

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


    If I have helped you with an answer, please accept this post as a solution and thumbs up my reply. Thanks !

    Blog - JonDoesFlow
    Twitter - JonDoesFlow
    YouTube - JonDoesFlow

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete