I have two SharePoint lists 1) Work Queue: 2)Membership File
I need a flow that anytime an item is created in the "Work Queue", It will check all the records of the "Membership File" on CustomerNumber2 column with Customer Number column of "Work Queue". If record found in Membership File, the newly created record's Work Order -Full Review column with the value of Review Needed column.
Work Queue:
Customer Number (Single Line of Text)
Work Order -Full Review (Single Line of Text)
Membership File:
CustomerNumber2 (Single Line of Text)
Review Needed? (Single Line of Text)
This is what I have so far and I can't get it to work

Report
All responses (
Answers (