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 III
Dual Super User III

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (6,706)