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: 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.