Hi 

We run an access database connected to SharePoint online lists. One of the lists has 16000 items and I need to add an additional field (type lookup) but when trying to add this get an error saying “the attempted operation is prohibited because it exceeds the list view threshold”

I can’t seem to find a way to increase the 5000 threshold limit to get around this. Is the only option to removed items to get the limit under 5000 to then be able to add a field? 
(we can’t create a new list and copy the data in as the autonumber ID from the existing list is used in the database)

Any suggestions would be appreciated!

​Hi We run an access database connected to SharePoint online lists. One of the lists has 16000 items and I need to add an additional field (type lookup) but when trying to add this get an error saying “the attempted operation is prohibited because it exceeds the list view threshold”I can’t seem to find a way to increase the 5000 threshold limit to get around this. Is the only option to removed items to get the limit under 5000 to then be able to add a field? (we can’t create a new list and copy the data in as the autonumber ID from the existing list is used in the database)Any suggestions would be appreciated!  Read More

​