cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
matthewnolan
Frequent Visitor

Send only one email per user

I have a Flow that goes to the SharePoint list below and sends an email to anyone that has not made a change in the Validation column. The only problem is that there are users (Assigned To) that have multiple rows with blanks so they get multiple emails. How can I make it so they only get one email? 

 

Thanks,

Matt

 

sharepoint.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @matthewnolan,

 

You could add the Condition inside the Apply to each to check if the Validation is null, and if the Validation is null, append the assigned to email ro the variable in the If yes branch of the condition.

 

Capture.PNG

 

The expression in the Condition as below:

@empty(items('Apply_to_each')?['Validation'])

 

Best regards,

Alice

View solution in original post

4 REPLIES 4
v-yuazh-msft
Community Support
Community Support

Hi @matthewnolan,

 

Do you want to send an email to each person in the "Assigned To" to field? And If you there are multiple rows with a same person in the "Assigned To" field, send only one email to the person?

 

I have made a test on my side to create a sharepoint list as below:

Capture.PNG

If I understand you correctly,please refer to screenshot below to create the flow:

 

Capture.PNG

Capture.PNG

 

The flow would run successfully as below to send the email:

 

Capture.PNG

 

Best regards,

Alice

 

 

 

 

 

I need to add a condition to test whether the column "Validation" is null. Where would I put that condition?

 

Thanks,

Matt

Hi @matthewnolan,

 

You could add the Condition inside the Apply to each to check if the Validation is null, and if the Validation is null, append the assigned to email ro the variable in the If yes branch of the condition.

 

Capture.PNG

 

The expression in the Condition as below:

@empty(items('Apply_to_each')?['Validation'])

 

Best regards,

Alice

View solution in original post

 

Got it to work! Awesome!

Thank you,

Matt

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.

Users online (2,104)