Forum Discussion

A137932's avatar
A137932
Copper Contributor
Sep 03, 2024

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

No RepliesBe the first to reply

Resources