I have a SharePoint site the is used by internal and extarnal users. We use the default visitor group to manage the access. The group has more than 5k users. I cannot add new user in the group and they cannot enter as visitor.

My power automate process fails for every new user added. If I try to add the user from the SharePoint interface I have the same error message. The error detail is:

"The attempted operation is prohibited because it exceeds the list view threshold"

I understand the threshold limitation, and I think that the best solution is to migrate the users in an Azure Security Group and then add the Azure Security Group to the SharePoint group. However I would like this as a last resource, because I will have other impacts elsewhere.

I tried to follow the office support, so I added index columns and edited the list view. The error is still there.

My doubt is about the counter of the group: enter image description here I start receiving error, after 7500 users more or less. Why I did not receive these errors before? Is it possible that the group became unstable after 7500 elements? Moreover, when my powerautomate process run the counter will increment by one (it seems added correctly), but the user cannot enter. Any help or opinion is appreciated.

  • I also try with powershell and I receive the same error "The attempted operation is prohibited because it exceeds the list view threshold" Nov 15, 2023 at 17:20

1 Answer 1


There is currently no way to modify the threshold for SharePoint online. As you said, our recommendation is to use Azure Security Group.

It is unclear why the error message is only appearing after 7,500 users. It is possible that the group became unstable after this number of elements, but without more information it is difficult to determine the cause.

As for the power automate process, it seems to be adding the user correctly but the user cannot enter. This may be due to other permissions or access issues.

  • I use the Azure Security Group approach: I migrate the user in the ad group. I put the ad group in the spo group. The power automate flows run good. The counter in sharepoint is still at 7500 but it is an aesthetic leasure. Thanks Nov 16, 2023 at 17:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.