cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
__1
Regular Visitor

How to update multiple list items in a list when a related item is updated on a different list?

I have an approvals process set up using 2 lists. List A is for approval intake: requestors can assign multiple reviewers and add approval information into this list. I then have a flow that takes that information and creates an item for each of the reviewers on List B and assigns a status of "Pending" to each approval. When items are added to B, a workflow starts the approvals and updates the status based on the approval response. I did this process specifically so requestors can track the status of approvals all in one screen rather than looking through all the tabs in the approvals center.

My issue is that sometimes approval request information may change. I want the requestor to be able to update the intake List A and have the associated activities in list B update as well. I tried to build a flow where When an item or file is modified (on list A) ---> Update Item (on List B) but cannot figure what to put for ID under update item, because there are multiple IDs on list B for the one ID on list A. I have a column that inputs List A ID to each item associated to it on list B (called workflow ID). I basically want the flow to say: If List A is updated, update all items in list B where "Workflow ID"= List A ID. 


Thank you in advance!

5 REPLIES 5
DamoBird365
Super User
Super User

Hi @__1 

 

You want to use the HTTP request to Sharepoint, specifically returning all list items where the workflow id = ListA ID and then do an apply to each.  Something like:

 

DamoBird365_0-1614283236916.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

Hi! Thank you so much! I was able to get the HTTP request to work , but I am having issues with Apply to each. My test returned this error:

 

__1_0-1614287585010.png

 

Is there any way around this?

DamoBird365
Super User
Super User

Hi @__1 

 

Try setting up a compose as follows:

Capture.PNG

and use the compose in the apply to each.

 

The expression is as follows:

outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['results'

The workflow succeeds now, but no updates are made in list B when I update list A.

__1_0-1614290420511.png

This is my workflow, am I doing something wrong?

Sorry for all the questions, I am new to PowerAutomate and we are rushing to replace old workflows. Thank you!! 

DamoBird365
Super User
Super User

You’ll need to check that the call to sharepoint has returned some items. Check the history for the HTTP request. It may be that the filter query is returning 0 records, in which case your apply to each will not actually be doing anything. 

Therefore check the column title for the query and make sure you are comparing the workflow id column with the variable of your flow 1 id and not just a string ‘flowid’.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (2,135)