web
You’re offline. This is a read only version of the page.
close
Skip to main content
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:
I have the same question (0)
  • abm abm Profile Picture
    32,858 Most Valuable Professional on at
    Re: How to use IF after creating table

    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard