Power Platform Community Forum Thread Details

Hey, I am working on a automatization of sending mail notifications about unfinalized orders to store managers. I get a an email every day with all the unfinalized orders in an excel sheet (it has the order number and store code and than some other columns I dont really need) and have to manually search through another excel that I have saved in OneDrive for the specific store I am supposed to send a mail to (based on the store code I match it to an email address). There are usually less than 10 but on a rare occasion (system outage) there can be up to a 1000.

Can anyone help me with this? (picture bellow for current reference)

Categories:

Building flows

Hi,

Your logic should be like below

For each row in the Excel file received via email, inside the Apply to each loop, you should add a Filter array action. This action will filter the Contacts table from the other sheet based on the criteria from the current row.
Within the same Apply to each loop, add a Condition action to check if the length of the filtered results is greater than 0. If true, it indicates that a matching record was found in the Contacts table. You can then extract the email ID from the filtered data and pass it to the Send an email action. If no match is found, either leave the action blank or send a notification indicating that no email was found.