cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Davida1
New Member

is there a maximum number of items that can be used in a power automate that sends an automated email to email addresses listed in a sharepoint list?

Hi everyone, 

I am very new to Power Automate and just created my first flow that is designed to send an automated email from Outlook to a list of email addresses that are stored in a Sharepoint list.  I've gotten the flow to run a few times with test data and I am getting ready to launch it now, but I had a question about whether there is a maximum number of items that can be included in the Sharepoint list.  I may have as many as 75,000 email addresses in the list and I am wondering if I'd need to batch them to make the flow work.  

 

Also, another issue I am wondering about is whether I might be able change my Power Automate from being a recurring flow to a button flow.  I modified a template to create the flow, and that used a recurring flow, but we only need to send the email once.    I took two pictures of the flow below.  Thanks for any advice! 

Davida

 

Flow part 1Flow part 1Flow part 2Flow part 2

 
1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @Davida1 ,

 

The apply to each limit could be found in the link provided by @Jcook with different licenses.

And There is also a limit in the Get items action as @scott said in the post below:

https://powerusers.microsoft.com/t5/Building-Flows/Get-Items-from-SharePoint-List-Limit-of-items/td-...

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Jcook
Super User III
Super User III

Hello @Davida1 

 

Yes you will need to do some configuration most likely. Depending on your license. Check this doc out:

https://docs.microsoft.com/en-us/power-automate/limits-and-config


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





v-alzhan-msft
Community Support
Community Support

Hi @Davida1 ,

 

The apply to each limit could be found in the link provided by @Jcook with different licenses.

And There is also a limit in the Get items action as @scott said in the post below:

https://powerusers.microsoft.com/t5/Building-Flows/Get-Items-from-SharePoint-List-Limit-of-items/td-...

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (3,110)