You’re offline. This is a read only version of the page.
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?
Hi @CCmuffin ,
I do not know your business needs, but I have developed a fairly large (150 plus SharePoint Lists and Libraries), all with either an integrated app or connected to a Canvas App over the last 4 years and have managed to do everything necessary. You just need to be mindful of issues such as Delegation and limiting the use of complex fields types where not necessary. I have put a site link at the bottom of this message that may interest you.
Visit my blog Practical Power Apps
Hi @CCmuffin ,
Very superficial issue as long as you understand the (small) limitations.
Firstly, Power Apps will address up to 30 million SharePoint items, however once the list size gets over 5,000, any fields that are subject to filters need to be indexed in SharePoint (you are allowed 20 indexes per list).
The 5,000 limit also apples to SharePoint views, but it is easy to filter the results to arrive at a number less than this for the dataset. The indexing requirement also applies here. I have several lists and Libraries between 50 and 100k.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
Share
Report
All responses (
Answers (
