Power Automate - AI Builder

how to send one notfication mail if condiction is met

Like (1) Share

Report

Posted on 9 Sep 2024 07:47:41 by KRAYA

Hello All,

I have 2 tables

Table 1 from SQL server which has employee handling task information

Name	Product	Job status	Due Day	Region	Division
ABC	1	Pending	1	America	123
XYZ	2	Pending	30	India	123
ASD	3	Pending	25	Denmark	123
ZYA	4	Pending	30	India	345
YLA	5	Pending	25	Denmark	234
AST	6	Pending	23	America	123
BWA	7	Pending	12	Nepal	123
ACE	8	Pending	14	Austria	123

Table 2 from Dataverse has Area Lead information

Name	Region
Manager1	America
Manager2	Nepal
Manager3	Denmark
Manager1	India
Manager5	Denmark
Manager3	America
Manager2	America
Manager1	America

This has almost 90 thousand entries

I need send the mail to manager from table 2 if Region from both table is "America" and from table 1 division is "123"
For example if i say Region America in both table is match and Division is 123 then send one mail to manager with product number in subject line and one excel sheet which has details of table 1 .

so far i have done this. In this case it keeps on send email to manager until the apply to each is satisfied.
I only need to send 1 email to manager with csv file.
Apply to each should only iterate into csv file. Once the csv is ready it should send only 1 mail to each manager from respective regions with all pending details. Instead of several emails.

Categories:

AI Builder

All responses (2)

Answers (0)

KRAYA 19 on 11 Sep 2024 at 01:53:14

Like (0)

Report

how to send one notfication mail if condiction is met

Hi @FLMike,
So far I have done this. In this case it keeps on send email to manager until the apply to each is satisfied.
I only need to send 1 email to manager with csv file.
Apply to each should only iterate into csv file . Once the csv is ready it should send only 1 mail to each manager from respective regions with all pending details. Instead of several emails.
Suggested answer

Michael E. Gernaey 38,788 Super User 2025 Season 1 on 09 Sep 2024 at 12:18:17

Like (0)

Report

how to send one notfication mail if condiction is met

Hi,

Can you please share what you have already. Are you asking us to write it? Since you didn't provide anything yet, I am not sure what level of detail you need.

There are lots of examples of pulling data from multiple sources in the same flow and comparing data.

You also mention at the end an excel sheet. i do not understand, are you asking to use it as an Attachment and what does "which has details of table 1".

I don't see an excel in your post.

Can you please clarify exactly what you need help with.

Community site session details

how to send one notfication mail if condiction is met

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

how to send one notfication mail if condiction is met

Helpful resources

News and Announcements

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates