Power Platform Community Forum Thread Details

have a list called Late that has LocationDescription and Name but its missing the manager email and director email. have another list called POC that has Facility and Account manager email and director email need a powerautomate that will comapre the Late List to the POC list to update the late list with the manager email and director email. if Late[LocationDescription] eq POC[Facility] and Late[Name]=POC[Account] then update record with manager email and director email.. please show step by step power automate flow

Categories:

Power Automate Desktop

Building flows

Hi @RN-22051120-0,

This is something comparing and filtering items form one list(Late) against other list(POC). Let's follow the below steps to achive this:

1. For test purpose - let's take a Manually trigger a flow (or scheduled flow). You can switch to “When an item is created or modified” later in the Late list (if you want dp real‑time automate).

2 Retrieve rows of Late list using Get items action, this will load all rows.

3. Retrieve rows of POC list using Get items action, this will load all rows of POC table.

4. Use lool (Apply to each) on Late list's Items. The target is compare each item of Late record agains POCT list inside the loop.

5. Inside the loop, match POC record with the Late record. Bring upa Filter array action. In the Filter array, set the From with POC Get items value and apply the following condion:

item()?['Facility'] equals items('Apply_to_each')?['LocationDescription']

AND

item()?['Account'] equals items('Apply_to_each')?['Name']

Note: So far so good, till now, we have produced matching POC record.

6. Let's mathc the conditon inside the loop after Filter Array. Add a Condition and check length(body('Filter_array')) greater than 0

If the above conditin is true - proceed to update.

7. If we find "Yes" in the above condition check, Add Update item action for the Late list. We should use the ID from the current Late item (items('Apply_to_each')?['ID']) and Set the follwoing:

ManagerEmail = body('Filter_array')[0]?['ManagerEmail']
DirectorEmail = body('Filter_array')[0]?['DirectorEmail']

Note: I would advise test with a small dataset first to confirm updates. Of course, do consider enabling pagination in Get items if lists are large(for both list).

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!