Forum Discussion
Advice on what method of List to implement
Hello.
I'm trying to implement a control of water meters readings. At first, I created a list for the equipments and one list for the readings, with a lookup column linking both lists through the equipment column in the first. But then i remembered the delegation limit. I have more than five hundred equipments and the readings must be registered in a daily basis and that data would surpass the delegation limits of five thousand rows in about two weeks. Because of that, I decided to create a list to each equipment, what would result in more than five hundred lists, but would give much more time (13 years) before the delegation limit for each equipment. But to avoid human errors on selecting the equipment, I'm failing on setting a default value for the readings lists and it made me rethink if that is really a clever idea.
My question: what method should work best in this case? Or is there a better way to do it I'm not seeing?
Thank you in advance!
You're mixing up the delegation limit (Power Apps) and the list view threshold (SharePoint). A SharePoint library can have up to 31 million items in it. You should create views of your list.
Perhaps one view could be readings in the previous day, another for readings within the previous week. Both of those would keep the view below the 5000 list view threshold.Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)
2 Replies
You're mixing up the delegation limit (Power Apps) and the list view threshold (SharePoint). A SharePoint library can have up to 31 million items in it. You should create views of your list.
Perhaps one view could be readings in the previous day, another for readings within the previous week. Both of those would keep the view below the 5000 list view threshold.Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)Thank you, Rob! It makes perfect sense, and I followed as advised.
It brings me one more thing to think about: dozens of people in dozens of places will insert the readings in the list and since there are hundreds of equipments, there are thousands of chances of making a mistake while doing it. To avoid this, the first measure that came to mind was making a form to each view, which I tried and worked nicely (although it makes no difference, it works as a guide to the inserter):
Views to show data of meters individually
Link to the formFormNow, if this is the right place do ask: is there a way set a default value to the "Macromedidor" field?
Thank you again!
