Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Power Automate - Help ...
Power Automate - Building Flows
Answered

Power Automate - Help with Scheduled Flow Duplicate emails errors

(0) ShareShare
ReportReport
Posted on by cnorth15 36

Hi All,

 

I have 2 SharePoint lists, SharePoint A is a list of data with a Title, Description and Date Column and SharePoint B a list of emails of users who get the Emails from the flow I am trying to build.

I have built a flow that sends a HTML table via email to users (SharePoint B) with data from a SharePoint list (A) and updates the list (A) "date" column with date it ran when email is sent.

I have then updated it to make it conditional to send out if Date column is Blank then send out HTML table to all select users,

if NOT blank then send out a generic email.

 

My issues is that when the email is sent regardless of which condition it breakdowns and sends number of emails based on the number of rows, it no longer batches and send the HTML table with all the data, but send multiple emails each one with 1 row duplicated based on the number of email address it is pulling from in SharePoint A?

I want to update so I can keep the conditional option but if it is "Yes" then it emails once with all the data to the users?

 

Flow:

 

Flow_Example.png

 

Full Flow:

Flow_Example_1.png

Here is also an Example of the email results I get from the flow, Sorry still learning so not sure if explained it well.

 

Email_Result_Example.png

 

Thanks

  • Verified answer
    v-jefferni Profile Picture
    v-jefferni on at
    Re: Power Automate - Help with Scheduled Flow Duplicate emails errors

    Hi @cnorth15 ,

     

    It seems you will send email to all the users in list B? If so, you can use a Compose operator below the get items of emails with same expression to generate a line of recipients, and use the output in the Send email action.

     

    Best regards,

  • cnorth15 Profile Picture
    cnorth15 36 on at
    Re: Power Automate - Help with Scheduled Flow Duplicate emails errors

    Hi @v-jefferni 

    It looks like it was set up as a single line of text,

    Email_Column.png

    I can edit or create a new column using a different Type, if this is the wrong type?

  • v-jefferni Profile Picture
    v-jefferni on at
    Re: Power Automate - Help with Scheduled Flow Duplicate emails errors

    Hi @cnorth15 ,

     

    What's the type of this Email column within List B? Could you please check it in list settings and provide some screenshots?

     

    Best regards,

  • cnorth15 Profile Picture
    cnorth15 36 on at
    Re: Power Automate - Help with Scheduled Flow Duplicate emails errors

    Hi @v-jefferni ,

     

    My SharePoint B List does have a column called Email, that's why I don't know why the flow failed?

     

    Thanks

  • v-jefferni Profile Picture
    v-jefferni on at
    Re: Power Automate - Help with Scheduled Flow Duplicate emails errors

    Hi @cnorth15 ,

     

    I was assuming there is an Email column within SharePoint list B. You need to use your actual column name instead.

     

    Best regards,

  • cnorth15 Profile Picture
    cnorth15 36 on at
    Re: Power Automate - Help with Scheduled Flow Duplicate emails errors

    Hi @v-jefferni ,

     

    I have removed the Apply to each 2 and used the expression:

    join(outputs('Get_items_-_Email')?['body/value']?['Email'],';')
    in the To parameter in the Send Email action
     
    But when I run a test it errors 

    InvalidTemplate. Unable to process template language expressions in action 'Send_an_email_(V2)' inputs at line '0' and column '0': 'The template language expression 'join(outputs('Get_items_-_Email')?['body/value']?['Email'],';')' cannot be evaluated because property 'Email' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

     

    Sorry new to Power automate and not really used expressions much before.

    Thanks

  • v-jefferni Profile Picture
    v-jefferni on at
    Re: Power Automate - Help with Scheduled Flow Duplicate emails errors

    Hi @cnorth15 ,

     

    I suspect that in Apply to each 2 you are using the users list value as the input, are you? Since you would like to send to users in a single Email, you will need to use the join function in the To parameter of Send Email action:

    join(outputs('Get_items-Email')?['body/value']?['Email'],';')

    Apply to each 2 is unnecessary.

     

    Best regards,

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

News and Announcements

Welcome to the Power Platform Communities

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

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans