Filter and validate each row

[TKHeng]

Hi,

Hopefully someone can help me. I'm new and just learning the power of Power Automate cloud. I have watched several youtube videos from @DamoBird365, @Reza, @abm and many others youtubers which have been useful adn greats, and I have also searched in the community but couldn't find a solution. 

So here is my problem:

I Have this excel file store in my onedrive. 

I'd like to send an APPROVAL email to my supervisor IF,

1) an email address is missing (column C) or

2) same email address (column C) but not the same language (column D) or contact first name (column E).

If no email address are missing, or clients with same email address have the same language or contact first name, then flow stop. I'm just trying to create a flow to verify that no email address are missign and the clients with the same email address have the same language or contact first name. I'm trying to identify typos in the excel file.

So, the email body should be something like this

If my supervisor approve it, then send another email to my manager (flow stop here). If it's rejected, then I'd get a notification.

Any help will be much appreciate it!...thank you!!!! 🙂