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!
