Compare ID's columns from two list and update field

[ispimentelz]

I have two list:

list A 

Title     UserName   RequestId   Status

Test1    Radhe        1                  Deactivated

Test1    Radhe        4                  Activated

Test1    Radhe        456              N/D

list B    

Title     RequestBy   ID

Test1   Something   2

Test1   Something   456

Test1   Something   4

I want to compare RequestId column (List A) with the ID column (List B), If match, i want to update the Status column in (List A) via Flow. 

Thought??

[RezaDorrani · Accepted solution]

Hi @ispimentelz 

First get all items from List A

Then for each item in list A (for loop)

Use Get Items within for loop and fire odataquery to fetch items from list B where ID = requestD

Check the count (length) of items returned

If count > 1 means item exists - run update item action and update status of List A item

Regards,

Reza Dorrani

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