Unanswered

Power Automate - sending duplicated emails

(0) Share

Report

Posted on by Yolanda922

Hello all,

I am new to Power Automate. I created a flow but the duplicated emails (about 3 emails) were sent out. Should I add an action to "If no"? Any feedbacks are appreciated. My purpose is : When "Status" colum is "New" and the "Assigned to" is "Person", then the flow will send the email to "Assigned to"

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

remidyon on at

Like (1)

Report

Hello @Yolanda922
Your flow will be triggered whenever your item is modified - so if you create an item then modify it, it could send multiple emails. How do you create your item in sharepoint? You could introduce a new status for your item once the flow has been executed the first time (to change the status to something like "pending") that way once your flow has run once it will not send another email.

Was this reply helpful? Yes No
Yolanda922 8 on at

Like (0)

Report

Hello remidyon,
Thanks for looking at my issue. This is the list and my intention is that the trigger should be executed only the status is New and Assigned to has a Display name. Users click "+New" and fill out all columns; then click Save button. The default of "Status" is "New". Do you mean when a user start filling the columns, the trigger will be executed as well?

Was this reply helpful? Yes No
remidyon on at

Like (0)

Report

hello @Yolanda922 , I don't know how you fill your list, but you should set a different status once the flow has been executed to avoid sending multiple emails.

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

Like (0)

Report

Hi @Yolanda922 ,

Maybe there is a CC in place on the Advanced Options?

Was this reply helpful? Yes No
MattJimison 577 Most Valuable Professional on at

Like (1)

Report

Hi, @Yolanda922 .

This question is likely best served in the Power Automate board since it's not directly related to Power Virtual Agents.

Having said that, take a look at Trigger Conditions on your trigger by going to the "..." in top-right corner of the action and selecting "Settings." This allows you to create filters that are checked before the item triggers, to avoid triggering a flow when you don't want it to. (it's a more lightweight approach than checking conditions within the flow as in your original example, as trigger conditions will keep the flow from even running when they're not met.)

Having said that, either way you approach it, the issue with your use case is something needs to change so that those conditions aren't true after the first time. An example would be changing that status from new to another value at the same time you send the email. You ultimately need something to track what you've already done and that's just one example on how to do it.

Per your question to @remidyon , yes, every time a single column is being changed in data sheet view, edit view, etc. the item is being updated and the Modified event will fire. You can check how much this happens by looking at the version history of an item after editing it in various ways.

This is a good write-up that should help you on learning how to best leverage trigger options.

https://www.spguides.com/power-automate-trigger-conditions/

Find this post helpful? Please mark it as the solution and/or provide kudos so that it will help others in the future.

Cheers,
Matt

Was this reply helpful? Yes No