cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Automating Flow for Sending Email

Hi,

 

I have a scenario where i maintain a list of subscribers (external users) in sharepoint online list. The idea is to then send an email to whoever is in this list whenever there's an update in an event.

 

Looks like there is a limit of 500 recipients that can be sent in a single e-mail from office exchange image.png

https://technet.microsoft.com/en-us/library/exchange-online-limits.aspx#RecipientLimits

 

As the subscriber list grows, it can potentially go over 500 records of users.

I had a look at the other connector, called 'Mail', but there's no documentation around what is the maximum number of recipient i can have in a single e-mail. 

 

Are there other connectors or workaround in Flow which can facilitate the scenario in the event that the e-mail has to go out to more than 500 subsribed users?

 

Advice much appreciated! Thanks

 

 

3 REPLIES 3
Highlighted
Dual Super User
Dual Super User

Re: Automating Flow for Sending Email

@warren

I haven't tested it myself, but... assuming the 500 recipents limits applies to a single Flow execution, also that your distribution list is less than 10,000 recipents; and finally there are few updates per day, a potential workaround is to apply nested flows (https://flow.microsoft.com/en-us/blog/build-nested-flows/

The main flow would be the trigger itself, then it would get items from the sharepoint list; and calculate the distribution list size. If bigger than 500, this main flow would trim the whole collection into 500 recipents slots, and iterate the slot collection. Each iteration would:

1.-invoke a second flow in charge of sending the notification email to the current 500 recipents slot, and

2.-point to the next 500 recipents slot

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Community Support
Community Support

Re: Automating Flow for Sending Email

Hi @warren,

 

There is no email connector could accept more than 500 external recipients that can be sent in a single email in Microsoft Flow currently, if you would like this feature to be improved in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Automating Flow for Sending Email

Hi @efialttes

 

Thanks for the idea. The nested flow is quite a good read (something i've not come across before), and although it might not entirely work for our case here, it is something interesting which i can bear in mind for future implementation. 

 

Cheer!

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (6,871)