cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
collicn
Level: Powered On

Send Email to Nominee Once

I have a Form that users can submit to nominate a staff member to a committee.  Multiple staff members might nominate the same person for the committee, but I want my Flow to only send an email to the nominee ONCE, not every time they are nominated.

 

How do I make my Flow check to see if that person has already been nominated, and if not, send them an email, but if they have already been nominated, don't send an email?  I tried making an array, but it seems like the array gets initialized every time the form gets submitted, wiping out the previous responses.  I'm so confused. Smiley Sad

 

Thanks in advance for any suggestions or help.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Send Email to Nominee Once

Hi @collicn 

Sorry I couldn't get back to you sooner, all you are really missing is "Filter Array". Please see below.

Here is my list, I added a SentEmail Column and set to yes, but no need for that although it could be useful later Smiley Wink, hence the addition.Capture-155.png

Here is the full FlowCapture-154.png

Here is the key aspectCapture-156.png

Hope this helps!

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


7 REPLIES 7
Super User
Super User

Re: Send Email to Nominee Once

Hi @collicn 

Do you have access to SharePoint perhaps?

I am thinking you could save your form submissions to a SharePoint List and then run a query on the list to send the email if the "Nominee" field represents a unique item?

 

If you have found my post helpful, please mark thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


collicn
Level: Powered On

Re: Send Email to Nominee Once

Ok I figured out how to send the email address to a Sharepoint list every time the nomination form gets submitted, but I don't understand how to query the list to see if the email address just submitted to the form is unique or not.

Super User
Super User

Re: Send Email to Nominee Once

Hi @collicn 

Have a look at the SharePoint connector. One is "Get Items".

Once you have the items from the list back in the Flow you will be able to match your for submissions to the data in the list currently, if it is a duplicate of a previos entry, use a condition to say if unique, send email, if not unique, do nothin.

Make sense?

 

If you have found my post helpful, please mark thumbs up.

If this post has solved your problem, please click "Accept as Solution".

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Super User
Super User

Re: Send Email to Nominee Once

Hi @collicn ... Thank you for posting this one!

I have decided to work through it for you and I am just building a solution just now. I will post back sooon when I have created this and fully tested it.

Best Wishes,

Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


collicn
Level: Powered On

Re: Send Email to Nominee Once

I've tried a couple of different things, but now I'm hung up on trying to compare the email address submitted to the form, to the email addresses written to Sharepoint. 

 

It seems that "contains" in the flow condition doesn't mean what I thought it meant.  The flow compares the submitted email address against every email address contained in Sharepoint, and each time the condition is false, it sends an additional email, which I definitely don't want.  

 

It seems like such a simple thing, I must be doing something incredibly dumb.

 

Super User
Super User

Re: Send Email to Nominee Once

Hi @collicn 

Sorry I couldn't get back to you sooner, all you are really missing is "Filter Array". Please see below.

Here is my list, I added a SentEmail Column and set to yes, but no need for that although it could be useful later Smiley Wink, hence the addition.Capture-155.png

Here is the full FlowCapture-154.png

Here is the key aspectCapture-156.png

Hope this helps!

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


collicn
Level: Powered On

Re: Send Email to Nominee Once

Thank you so much!!

Helpful resources

Announcements
firstImage

Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 43 members 4,187 guests
Please welcome our newest community members: