Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Email Large Number of Users

(0) ShareShare
ReportReport
Posted on by 81

I have a Flow setup that will email people that are part of a SharePoint list. This was a carryover from a SharePoint 2010 Designer workflow that we replaced when we migrated the site. The list currently has 593 items in it. Flow handles things a bit differently than SPD workflows so before I kicked off a test I wanted to see if there would be any issue with emailing this large number of people?

  • manuelstgomes Profile Picture
    manuelstgomes 6,625 on at
    Re: Email Large Number of Users

    Hi @BigE 

     

    You can try to use something like SendGrid. It's scalable and has a generous free tier.

    http://azure.microsoft.com/en-us/documentation/articles/sendgrid-dotnet-how-to-send-email/

     

    Hope it helps you.

     

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

    Cheers
    Manuel

  • BigE Profile Picture
    BigE 81 on at
    Re: Email Large Number of Users

    Thanks for the input. Yeah, this was really too large for the old SharePoint Designer 2010 workflow to do before. I didn't know about this one until we started to migrate their site to 365. I'm currently looking for other options outside of SharePoint to do this, just wanted to get some input from others in the community first.

  • manuelstgomes Profile Picture
    manuelstgomes 6,625 on at
    Re: Email Large Number of Users

    Hi @BigE 

     

    That's a lot of people. 🙂

     

    I recommend sending these emails into batches. I know it's more work, but you won't get into issues with the email server starts to think these are SPAM. Also, ensure that your Admin knows that these emails are being sent to take adequate measures. 

     

    From Microsoft's documentation:

    You may not get emails from this connector:

    • If you are in the unsubscribe list. You can use this form to manage your subscription preferences.
    • If the corporate side of things has a SPAM filter that is catching the email and saying it is spam. It never gets into your spam folder because it is intercepted at the server level.

     

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

    Cheers
    Manuel

     

  • v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Email Large Number of Users

     

    Hi @BigE ,

     

    Whether the emails contained in these items have duplicate parts, if any, it is recommended to use the functions contained in Flow to remove the duplicates first.

     

    Do you have a similar Flow to implement your needs now? If so, and you are experiencing some difficulties, you could provide more details about the issue so that we can provide the appropriate workaround.

     

    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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard