Forum Discussion
Advice on what method of List to implement
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 individuallyLink to the formForm
Now, if this is the right place do ask: is there a way set a default value to the "Macromedidor" field?
Thank you again!
No, Forms cannot pre-populate a question or give a default value. Given the scale of what you are doing it might be better to build an app in Power Apps. With that you can set default values and do other validation which Forms can not. And your users will possibly find it a better experience. It will also protect the list from unwanted changes.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)