How to use IF after creating table

(1) Share

Report

Posted on by ricardolopes

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!

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

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (0)

abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No