web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Power Automate - sendi...
Copilot Studio
Unanswered

Power Automate - sending duplicated emails

(0) ShareShare
ReportReport
Posted on by 8

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"

powerautomate.PNG

Categories:
I have the same question (0)
  • remidyon Profile Picture
    Microsoft Employee on at

    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.

  • Yolanda922 Profile Picture
    8 on at

    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?

    list.PNG

  • remidyon Profile Picture
    Microsoft Employee on at

    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.

  • fernandosilva Profile Picture
    Super User 2024 Season 1 on at

    Hi @Yolanda922 ,

     

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

  • MattJimison Profile Picture
    579 Most Valuable Professional on at

    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/

     

    Screenshot 2023-08-14 at 11.59.10 PM.png


    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 594

#2
chiaraalina Profile Picture

chiaraalina 170 Super User 2026 Season 1

#3
deepakmehta13a Profile Picture

deepakmehta13a 118

Last 30 days Overall leaderboard