cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hemasai1999
Helper III
Helper III

Send emails using power automate

Hi, 

I have one sharepoint list, where info in as below

RedID    TrainingProgram     Status            ArtifactID  LCEmail                             LPEmail

1            Java                         confirmed     12345        hfh@gmail.com                   abc@gmail.com

2            C                             confirmed                                                                   abc@gmail.com

3            html                        confirmed     12334                                                    xyz@gmail.com

In this data I need to check condition that is ArtifactID is empty or not, then send email to particular person mentioning reqID and TrainingProgram for the blank ArtifactID,

MicrosoftTeams-image (6).png

I have tried with this flow.

Here I am facing two issues -

1 - It need to check whether lcname, ArtifactID and status is confirmed or not

2 - send email to LPEmail with particular details, If I have two same emails on same name  (abc@gmail.com), then only one email should trigger to person with two ReqID details.

 

Any suggestion would be helpful

 

3 REPLIES 3
StalinPonnusamy
Community Champion
Community Champion

Hi @Hemasai1999 

 

Conditions for lcname, ArtifactID

 

equals(items('apply_to_each')?['ColumnName'],null)

 

like

equals(items('apply_to_each')?['ArtifactID'],null)

Conditions for Status. I assume Status is a Choice field

 

equals(items('apply_to_each')?['Status/Value'],'Confirmed')

 

All field/Columns checks "is equal to" true

 

Sample with 3 conditions

StalinPonnusamy_1-1631759044101.png

 

 

 Note: Need to use Expression like below

 

StalinPonnusamy_0-1631758989656.png

 

 

 

 

StalinPonnusamy
Community Champion
Community Champion

Hi @Hemasai1999

 

I have made small changes for the above condition.

StalinPonnusamy
Community Champion
Community Champion

Hi @Hemasai1999

 

Please let us know if anything needs on your post. We can help with this.

 

Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,855)