Hello. I have a question with making a daily work log app with large number of rows.
There are about 200 employees in our company.
The current daily log is using excel format. The record consists of 22 columns such as department, name, work history, time, and KPI, etc.
200 people write an average of 10,000 records per month, but it is expected to increase further in the future.
All employees have adopted and used Microsoft 365 Business Premium, are actively promoting Teams-oriented work, and have individual Teams groups for all teams.
I was recommended to use a sharepoint list base for this project. And I was planning to store the log of all employees in a single list and split the views according to UPN.
However, when I moved the existing logs to sharepoint and created an app for testing, a 'list exceeds the list view threshold' problem occurred with only 20,000 rows.
I've searched and found that there are some ways to fix it, but I'm worried that this is just a superficial solution.
Essentially, is it better to stick with this model and solve it technically with Power Fx, or use a better model?
