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??
Solved! Go to 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
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
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
42 | |
37 | |
36 | |
23 |
User | Count |
---|---|
41 | |
39 | |
30 | |
29 | |
29 |