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!
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:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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:
Is there any way around this?
Try setting up a compose as follows:
and use the compose in the apply to each.
The expression is as follows:
The workflow succeeds now, but no updates are made in list B when I update list A.
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!!
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’.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!