Site has so many access requests that the list no longer loads in pendingreq.aspx

Copper Contributor

We have a SharePoint site that archives communications from our HR department to various groups of people, but over the past 2 years they've been manually managing access requests instead of using permission groups. Now they have over 7000 access requests and when anyone goes to the pending request page, they only see the following error:

 

SPAccess.jpg

 

The button that appears in their emails is also throwing an error, so that isn't an option.

 

EmailRequest.jpg

 

Is there a way to access the full list without using the pendingreq.aspx page? I tried navigating to /Access%20Requests/Forms/AllItems.aspx but only received a 404. If I can access the full list, what would happen if we deleted the old approved requests? Would that remove the access for those users?

2 Replies

Hi @russellkoons, as I can see this list has 3 unique views but none of them are the standard AllItems.aspx view

 

/sites/SITE_NAME/Access Requests/pendinginv.aspx

/sites/SITE_NAME/Access Requests/oldreq.aspx

/sites/SITE_NAME/Access Requests/pendingreq.aspx

 

You can retrieve all access request items using this GET endpoint.

/sites/SITE_NAME/_api/Web/AccessRequestsList/Items

 

I am not 100% sure but I think the old access requests are kept for historical purposes, to track who made a request and when it was approved.

Thanks, @michalkornet. Unfortunately, those other pages don't seem to help. I was able to pull the data into Excel, so maybe the team can use that to manually send invites.