As per the SharePoint online limitation, it is recommended to stay below 5,000 unique items per list https://learn.microsoft.com/en-us/office365/servicedescriptions/sharepoint-online-service-description/sharepoint-online-limits , but as i know we can have up to 50,000 unique items per list.
Now I want to start a new project for a company which have 800 employees, to manage the employees Leave & Vacation requests. as follow:-
Employee submit a leave or vacation request to his/her manager.
After that, the request can only be edited/Approved by the manager & read-only by the employee who submitted the request
After approving it >> both the manager and employee will have read-only permission + the HR Team.
Now we need to secure the SharePoint lists >> by defining unique permissions for the items as the process move (as per the above 3 steps). now i am afraid that the limitation of 50,000 unique items can be reached within less than 2-3 years. because we have 800 employees , so each employee can only have 60 leave & vacation requests. so how we can handle this? i read some articles which mention to use multiple SharePoint lists, but this will not be a practical appraoch because we will have to manage many lists, and we are planning to build the UI using Power apps which connect to the SharePoint lists. any advice please?