How to update column value to same value refer another column in Sharepoint list

[AT_AlanTse123]

Hi all,

I have a SharePoint list called "DCE" that has two columns, one is "PO number"(Number column),

another one is "Completed"(Choice column), that has two choices for choose (Yes or No).

I want to build the flow that if "Completed" choose "Yes", another record which is same PO number also set completed as "Yes".

For example, i have set one of PO number 4500123456 record and its "Completed" change to "Yes", I want to another record which PO number is 4500123456 also change the "Completed" to "Yes"

 

May i know how to do?

Thank you very much.

[FLMike]

Hi @AT_AlanTse123 

Use UpdateIf, It is similar to patch, except instead of updating 1 row, it can point to many rows, based on the Filter Criter, in my case I added 'PO Number' = InsertValueHere

UpdateIf(MySiteList, 'PO Number' = InsertValueHere, 

          {

               // Add your columns etc and set values here

          }

  )

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[AT_AlanTse123]

@FLMike 

Thank you very much for your reply.

May I know where input the code? Is it input in the powerapps?

[FLMike · Accepted solution]

@AT_AlanTse123 

Woops me I am a moron, you said a flow and I am IN the flow section but I, sorry, got confused with answering all over and answered for a Canvas App

You would need to do this my friend

1. Create an Automated Flow, and use the When an item is created or modified Trigger(SharePoint)

-we may want to set a Condition on the trigger so that it ONLY triggers when someone sets the Condition to true or in your Case "Completed" choose "Yes"

-if we put in the condition, it will make sure to only fire when someone marks one as completed, which is what you want.

2. We would add a Get Items (SharePoint Action)

-and we would add a filter where the [PO Number] eq (The Dynamic PO Number from the Trigger).

--This will return us ALL the records that have that PO Number

3. Add an Apply to each (Loop) 

-For the Input/From add the Dynamic Content Property called value from Step 2

--Now we are looping through all the Records that have the PO Number, from the Triggered Row, where someone set it to Completed

4. Inside the Loop, we are going to do an Update Item (SharePoint action)

--The Item (row) to update comes from the Loop Iteration of the Apply to each

--You must set the Title, as its a requirement, so you would want to use the Title from the Loop Iteration as well, so that it doesn't change

--Set the value of the Complete to Yes

And thats it, those are the steps.

Now, anytime someone sets one to Yes(Completed), it will query all the other PO Numbers rows that Match, and update them all to Yes (Completed)

Does the walk through make sense?

Its super late so I didn't create it, but I will help you tomorrow more, if you can just add these things to it I will help more to complete it in full

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[AT_AlanTse123]

Thanks @FLMike ,

It works perfectly!!!

Your walkthrough are very clear and make sense

Thank you very much for your help

😁