Forum Discussion
Extend existing Power Automate flow to undertake column check & write value
Hoping for your expertise in helping me to build out further my SharePoint list flow.
I have an existing flow that works perfectly but now I would like to build further on.
Currently the flow undertakes the following:
When an Item is Created > Get Item > Format Number > Update Item (concat('NEM_R',outputs('Get_item')?['body/Class'],'_',outputs('Format_number')?['body'])
)
What I now would like to add to the flow is the following:
I have 5 calculated columns, 4 of those columns will always return a value of No but one will always be populated with a value such as High SPGI 10. The one populated can be anyone of the 5
Undertake comparison of the values in all 5 columns, identify the one not equal to No & write that value into a new field.
My columns for comparison are:
Risk_x0020_Rating_x0020_Level_x0
SPGI_x0020__x002d__x0020_Unlikle
Risk_x0020_Rating_x0020_Levels_x
SPGI_x0020__x002d__x0020_Likely_
Inherent_x0020_SPGI_x0020_Risk_x
The field I want to write the unique value into is a single line of text field with label of: Inherent_x0020_SPGI_x0020_Score
Thank you in advance for your help