@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
