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.
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.
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
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2