
Announcements
I have two lists- List A and List B. List A is a population of projects with contact information (e.g. project code, project title, email, name). List B is a population of survey results from Microsoft Forms with the persons email and name as well.
When a survey is completed, the results are populated in List B. If the email in List B matches the email in List A, I want the project code from List B pulled into List A.
So far my flow is this:
When an item is created in List B
Get items from List B
Get items from List A
The flow continues below. It fails in the "Update Item" portion and says list item cannot be found.
Power automate doesn't have a Lookup function. But you can do a Get items on list A using an OData query on the email from List B. Then use First() on the array that is returned and append ?['fieldname'] to the first to get the value from the first record.