Skip to main content

Notifications

Power Automate - AI Builder
Suggested answer

how to send one notfication mail if condiction is met

Like (1) ShareShare
ReportReport
Posted on 9 Sep 2024 07:47:41 by 19
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:
  • KRAYA Profile Picture
    KRAYA 19 on 11 Sep 2024 at 01:53:14
    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
    FLMike Profile Picture
    FLMike 27,286 on 09 Sep 2024 at 12:18:17
    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.

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

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,696

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,456

Leaderboard
Loading complete