cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TKHeng
Frequent Visitor

Filter and validate each row

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. 

TKHeng_0-1645419727448.png

 

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

TKHeng_1-1645420064703.png

 

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!!!! 🙂

0 REPLIES 0

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,141)