how to send one notfication mail if condiction is met

(1) Share

Report

Posted on 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

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,329 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
KRAYA 19 on at

Like (0)

Report

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.

Was this reply helpful? Yes No