I have a list that is 12488 items in size that with your kind help I have uploaded to SharePoint Online (below post).
I need SharePoint mobile app users to be able to access this to see if a certain item/customer is "yes" or "no".
Unfortunatley the "yes" (ok to proceed with work) is almost 4800 of the total items so even if I remove the "no" (do not proceed with work) and upload this to SharePoint Online, it wont be long before that exceeds the 5000 limit.
Is there a more elegant way of achieving this?
Thanks in advance,