web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to use IF after cr...
Power Automate
Unanswered

How to use IF after creating table

(1) ShareShare
ReportReport
Posted on by 4

Hello @abm !

 

I wanted to create an automatic flow of sending emails in a table by collaborator and I followed your video (Power Automate - How to filter Excel rows using unique column names & send email) that helped me a lot!!

 

But after having this flow created I wanted, based on one of the excel data, to send emails if employee X has a medium engagement send a message and the table, if I have a low engagement a different message but still with the table and employee data.

 

I've tried using if or switch but as it assumes excel in Value, the table then exchanges data when sending emails and doesn't run as expected!

exemplo.png

 

Do you know how I can do this?
Thank you so much, your videos help a lot!!

Categories:
  • abm abm Profile Picture
    33,004 Most Valuable Professional on at

    Hi @ricardolopes 

     

    Without adding the Apply to each loop, add a filter array to query the results against the engagement. This way you can get the employee's name and used for the sending email with filtered results.

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 355

#2
11manish Profile Picture

11manish 336 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard