Answered

Flow to update Column following change in other Column in same Sharepoint list

Like (0) Share

Report

Posted on 25 Oct 2022 13:31:24 by Community Power Pla...

Hi there, firstly thanks for your help!

I'm looking to build a flow that will automatically update another column in my SharePoint list (with a number) when the status is updated. So to make it simple, from the photos below ..... when the CSM Status is changed to "Data Entry Complete" I would like my Data Entry Complete column to be updated to "100". I need this to be a number as I am displaying icons in a Power BI dashboard.

If someone could help me by building an example flow that would be great!

Thanks 😀

All responses (2)

Answers (1)

Community Power Pla... on 26 Oct 2022 at 10:09:45

Like (0)

Report

Re: Flow to update Column following change in other Column in same Sharepoint list

Thank you so much Caspar - this works perfectly! 😊
Verified answer

Caspar_Rubin 830 on 25 Oct 2022 at 18:46:38

Like (0)

Report

Re: Flow to update Column following change in other Column in same Sharepoint list

Hey,

you could do it like this:

Full Flow:

Explanation:

In the "When an item is created or modified" trigger action at the top, click on the 3 dots at the top right and then select Settings.

In the Settings of the trigger action, click on +Add at the bottom where it says "Trigger Conditions" and enter the following Text:

@And(equals(triggerOutputs()?['body/CSMStatus/Value'],'Data Entry Complete'),not(equals(triggerOutputs()?['body/DataEntryComplete'], 100)))

this way, the flow will only trigger if the Choice Field CSMStatus changes to Data Entry Complete and the value in Data Entry Complete is not already 100.

Also: Make sure you're using the internal names of the columns in SharePoint.
For me, the column Data Entry Complete had the internal name DataEntryComplete
So without spaces... otherwise the Expression won't work... But I don't know if your internal name is the same... maybe it's Data%20Entry%20Complete or something like that...

Then in the Update item action, use the following Expression in the Data Entry Complete field:

int(100)

Leave the other fields like CSMStatusValue empty! This way the flow will not update those fields...

Test / Check:

The flow runs successfully:

And the items get updated:

let us know if this works,
cheers