Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Multiple Emails being sent but should be only one email

(0) ShareShare
ReportReport
Posted on by

Hello! I know there is probably a simple solution but I am still learning so help would be appreciated.

I have a flow set up that is triggered by clicking on Flow in Sharepoint that when the date is today and "urgent" it will send an email out. The issue I have is that if there are more than one entry that the date is today and "urgent" it is sending multiple emails out. I am needing it to send one email with all of the items on the one email. How can I do that? Thank you!!

11-20-2019 8-11-18 AM.jpg11-20-2019 8-14-55 AM.jpg11-20-2019 8-15-12 AM.jpg11-20-2019 8-15-23 AM.jpg

  • Doosan_Dean Profile Picture
    21 on at
    Re: Multiple Emails being sent but should be only one email

    I have a sharepoint list with a 'Choices' Column with written in email addresses as the choices

     

    In Powerapps I have a combo box within my form that allows you to pick multiple email address

     

    I have a flow that says when a new item is create - send an e-mail. My 'To' section is where I put the dynamic content 'EmailRecipients' which is the name of the column.

     

    It sends out an individual e-mail to each of the addresses that were selected in the powerapps form. How do I get flow to recognize the selected e-mails as a string and send only one emails to everyone selected?

     

    Thank you

  • Verified answer
    ScottShearer Profile Picture
    25,236 Most Valuable Professional on at
    Re: Multiple Emails being sent but should be only one email
    @Tbruns Yes - if you replace the recurrence trigger with a for a selected item a single email will be sent containing all items with a date in the column that you specify of today.
  • Tbruns Profile Picture
    on at
    Re: Multiple Emails being sent but should be only one email

    @ScottShearer 

    If I use "For a selected item" it will still only send one email? 

  • ScottShearer Profile Picture
    25,236 Most Valuable Professional on at
    Re: Multiple Emails being sent but should be only one email

    @Tbruns 

    Here is an example using  library and an HTML table.  Once a day (and you can specify the time) an email will go out with a table containing all items with a date of today in the MyDate column.  Once again, the expression that I use can be seen in the comments and note the single quotes around the expression. 

    If you absolutely want to start this from an existing document, simply replace the recurrence trigger with a for a selected file trigger.  The remainder of the Flow will be identical.

     

    HTMLA.jpgHTMLB.jpgHTMLC.jpg

     

     

  • Tbruns Profile Picture
    on at
    Re: Multiple Emails being sent but should be only one email

    @ScottShearer 

    I actually need the email to be sent once I click on the Flow in the Sharepoint library. So we will add several documents that have todays date and urgent marked. Once I am doing adding them I will go to Flow and click Run to send the email.

  • ScottShearer Profile Picture
    25,236 Most Valuable Professional on at
    Re: Multiple Emails being sent but should be only one email

    @Tbruns 

    I focused on the HTML table.....

    Upon looking at your Flow again, you probably don't want to use a for a selected file action.  It is more likely that you want an email to go out once a day with all items where the date is today.  I am creating a solution that shows this and will post in a few minutes.

  • Tbruns Profile Picture
    on at
    Re: Multiple Emails being sent but should be only one email

    @ScottShearer 

    So would I still choose "For a selected file" as the first step then "get items" as you have in your screen shot?

    I am already using a filter query but even if I change it like you have it will it only send one email?

  • ScottShearer Profile Picture
    25,236 Most Valuable Professional on at
    Re: Multiple Emails being sent but should be only one email

    @Tbruns 

    Please see my screen shot below for a more compact and simple approach to your issue.  I use a filter query in my Get items action.  Only items that meet your date parameter will be returned - no need to filter any further.  The expression that I use can be seen in the comments area.  My date column is called MyDate.  Please note the single quotes around the expression in the filter query.

    HTMLTable.jpg

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1