cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Chrisautomateno
New Member

Trigger - When new response is submitted - prevent duplicate emails

Hello,

 

I managed to muddle through a flow where a form response is submitted it will send an email to a specific email address captured as a question in the form.

 

However, because it is triggered each time a new response is submitted it performs the same action for all of the previous responses too.

 

I am assuming that there is a way to add an id to a column when the flow reads the data from excel after it performs the action of emailing.  Then there must be a condition where my email flow only works if the cell where the ID will go is blank.  Therefore, it will only ever send one email to a person.

 

Is this possible? Or is there a better way to avoid the duplication of an email each time a response is submitted?

 

Thank you very much in advance.

4 REPLIES 4
ScottShearer
Super User
Super User

@Chrisautomateno 

Please post a screen shot of your Flow and I'll try to assist.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Chrisautomateno
New Member

Hello,

 

Thanks for the help.  It's just very basic. The email is collected from the answer to a forms question, but it works.

 

Chrisautomateno_0-1653379651632.png

I just need to make it so that once the flow has actioned the email once, it doesn't repeat.

 

Thanks again for any help

 

 

Hello,

 

I'm just wondering if you'd had a chance to look at a possible solution please?

 

Kind regards

 

ScottShearer
Super User
Super User

@Chrisautomateno 

Sorry for the late response - on vacation (at the beach) this week.

You need to filter the data that you are retrieving from Excel.  Here is a link to a Blog post that explains how.

Post here please if you have additional questions.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,991)