Send Email to Nominee Once

[collicn]

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. 😞

Thanks in advance for any suggestions or help.

[AlanPs1]

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

[collicn]

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.

[AlanPs1]

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

[AlanPs1]

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

[collicn]

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.

[AlanPs1 · Accepted solution]

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 ;), hence the addition.

Here is the full Flow

Here is the key aspect

Hope this helps!

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

Any other questions, just ask.

Thanks, Alan

[collicn]

Thank you so much!!