Cannot process more than 200 items

[UniMatrix]

I am building a Flow that adds members  (263) from a group to a Sharepoint list. It checks if the email address is in the list and if it isn't, it adds the user to the list.

The problem is that it gets and iterates through all 263 members of the group, but after exactly 200 iterations, it doesn't perform actions anymore so I cannot get more than 200 users from the group in the list. There are no errors, the actions are just greyed out and cannot be opened in the Run History.

Number 200 is skipped because it is already in the list.Number 201 is processed (and the others to 263) but the actions are not performed and cannot be opened. (The excel was for testing so i disabled the Sharepoint action by configuring run after, which is why you see an exclamation mark)

We have been Googling for a couple of days now, been messing with pagination and treshholds, but it never adds more than 200 users.

• It gets all 263 group members
• The apply to each (member) runs 263 times
• The 'check' get member in contacts runs 263 times
• The condition is evaluated 263 times
• The list can have more than 200 items
• After 200 iterations no actions are performed

[Delia_Laudoni]

Hi, 

I am guessing that after 200 items "Get item" returns nothing and that's way apply to each is not working.

Try this configuration:

Hope this will help you 🙂

Delia

[v-litu-msft]

Hi @UniMatrix,

The items limitation of Apply to each is 5000 if your license is free:

https://docs.microsoft.com/en-us/flow/limits-and-config#looping-and-debatching-limits

You can have a test that initializes a variable to store members then put the variable into the Apply to each loop.

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