SOLVED

Sharepoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-2315012%22%20slang%3D%22en-US%22%3ESharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2315012%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20built%20a%20Microsoft%20flow%20to%20send%20the%20work%20anniversary%20emails%20to%20the%20contacts%20present%20in%20the%20Sharepoint%20List.%20I%20have%20around%20200%20contacts%20on%20that%20list.%20I%20have%20tested%20the%20flow%20with%20a%20list%20of%20fewer%20than%2010%20contacts%20and%20it%20worked%20which%20means%20the%20flow%20does%20not%20have%20any%20problem.%20But%2C%20when%20I%20am%20trying%20to%20run%20the%20flow%20using%20the%20list%20which%20has%20200%20contacts.%20It%20is%20not%20sending%20the%20email%20after%20the%20100th%20contact.%20I%20would%20like%20to%20know%20if%20I%20can%20only%20create%20a%20list%20of%20100%20contacts%20or%20what%20exactly%20is%20this%20problem!%20Why%20can't%20I%20see%20the%20outcome%20for%20more%20than%20100%20contacts%3F%20What%20should%20I%20do%20in%20order%20to%20solve%20this%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2315012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2315197%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2315197%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1042995%22%20target%3D%22_blank%22%3E%40OJasvi13%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBy%20default%2C%20the%20SharePoint%20Get%20Items%20action%20(I%20assume%20that's%20what%20you're%20using%3F)%20will%20retrieve%20only%20100%20items.%20See%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fbusiness-apps%2Fpower-automate%2Fguidance%2Fworking-with-get-items-and-get-files%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fbusiness-apps%2Fpower-automate%2Fguidance%2Fworking-with-get-items-and-get-files%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20increase%20this%20up%20to%20the%205000-item%20SharePoint%20list%20view%20threshold%20by%20entering%20a%20value%20in%20Top%20Count.%20And%20you%20can%20increase%20it%20further%20by%20using%20the%20Pagination%20settings%20in%20the%20Settings%20of%20the%20Get%20Items%20action.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2315395%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2315395%22%20slang%3D%22en-US%22%3EThank%20You%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F16657%22%20target%3D%22_blank%22%3E%40Sandy%20Ussia%3C%2FA%3E.%20This%20helped%20me%20resolve%20the%20issue.%3C%2FLINGO-BODY%3E
New Contributor

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 Replies
best response confirmed by OJasvi13 (New Contributor)
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!

 

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