Sharepoint List

[OJasvi13]

Hi,

I have built a Microsoft flow to send the work anniversary emails to the contacts present in the Sharepoint List. I have around 200 contacts on that list. I have tested the flow with a list of fewer than 10 contacts and it worked which means the flow does not have any problem. But, when I am trying to run the flow using the list which has 200 contacts. It is not sending the email after the 100th contact. I would like to know if I can only create a list of 100 contacts or what exactly is this problem! Why can't I see the outcome for more than 100 contacts? What should I do in order to solve this problem?

[#2 · Accepted solution]

Hi @OJasvi13 

By default, the SharePoint Get Items action (I assume that's what you're using?) will retrieve only 100 items. See https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-g...

You can increase this up to the 5000-item SharePoint list view threshold by entering a value in Top Count. And you can increase it further by using the Pagination settings in the Settings of the Get Items action.

I hope this helps!

[#3]

Thank You @Sandy Ussia. This helped me resolve the issue.