Linking items through multiple lists

[Morghan]

Hello,

I have two lists where items are either approved or rejected from, and if the request is approved on List 1, but then Rejected from List 2, I want to be able to link back to the History list in the middle and change it's Status from Approved to Rejected.

Scenario: I have List 1, a History List and List 2.
Step 1: Typically, a user creates the initial request in List 1.
Step 2: It's then Approved or Rejected by an Assistant Manager.
Step 3: It's details and Approval/Rejected Status are added to the History List.
Step 4: The item is moved on to List 2 for the Senior Manager's review.

**If the Senior Manager wants to reject the item from the List 2, I want a way to look back at the request in the History list and change it's Status column from Approved to Rejected. To try and keep the relationship between the lists, I am currently using an "ID_1" column in the History List and List 2, and it's value is the "ID" from the original request from List 1.

I've attached my current build on how I see it could possibly work. I've added the formulas on each step in my screenshot. Am I close?? My thought is to create an array with all the ID_1's from the History list then a Get Items on the History list and if the ID_1 from List 2 matches an ID_1 from the History list, update that item in the History. 

The "Append to array variable" action is showing error: BadRequest. The value cannot be null. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'.

Thank you in advance for any advice!
M

[v-alzhan-msft · Accepted solution]

Hi @Morghan ,

Please refer to screenshot below to create the flow:

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Morghan]

Hi @v-alzhan-msft - this is absolutely perfect, thank you!!