Send emails using power automate

(0) Share

Report

Posted on by Hemasai1999

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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

Note: Need to use Expression like below

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Hemasai1999

I have made small changes for the above condition.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No