Sharepoint List - Get column changes flow issue

(0) Share

Report

Posted on by Gkouk74

Hello. I have a list for which I want to send email notifications whenever there is a change in specific columns and also include in the message what values changed to which ones. I have used some online guides to built the flow, but I cannot receive the correct info.

However when it is run I don't get the actual column name changed, but the following:

First I receive as output the actual column name (e.g. Important Change (Y), but then in the Has Column Changed box, the columns are retrieved as field_x,

So I cannot use the above outcome to the email notification I want to add.

Any idea on what I am doing wrong?

Many thanks in advance for your help.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @Gkouk74,

I have seen this before, that in the version history the underscore character gets encoded again. In another thread I proposed to replace that underscore by _x005f_

https://powerusers.microsoft.com/t5/Building-Flows/PowerAutomate-SharePoint-column-name-special-character-problems/m-p/1945234#M214269

replace('Field_5', '_', '_x005f_')

Was this reply helpful? Yes No