You will need to loop through each of the emails and check each one in your Excel file. I've created a quick example.
I'm using the following Excel Table.
The full flow is below. I'll go into each of the actions.
When a new email arrives is the same as what you have:
I then use a Select to get each of the email addresses and add them to an array that we can loop over. The expressions I use for this are:
split(triggerOutputs()?['body/toRecipients'], ';')
item()
This will give us an array of email address similar to below:
[
"grantjenkins@happywolf.onmicrosoft.com",
"AdeleV@happywolf.onmicrosoft.com"
]
Next, we have an Apply to each that loops over each email address in our array.
It will "try" to Get a row in the Excel Table that matches the current email address. If it doesn't find a match, then this action will cause an error. This is why we have the Terminate action after the loop which I'll explain later. If it does find a match, then we Send an email with the content returned from Get a row.
After the loop we have a Terminate action set to Status of Succeeded.
An important step here is to Configure run after on it so that it runs when the previous action either succeeds or fails. To do this we go into the Configure run after of the Terminate action.
Then we check both is successful AND has failed, then click on Done.
This should get what you are after.
