Forum Discussion
PowerApps. Need help with using Collect for a very large Sharepoint List
Hello, I created an App to help workers in accessing and adding to a very large Sharepoint List. I organized the data by creating a new field in the list (Logbook ID). Everytime a worker creates ...
What I do is get everything into local collection, then you can do whatever you want without worrying about delegation. This way you get the filtered result then you can count that result from the collection.
Mine is static, so I have one for each count, but if you have dynamic, you might look at utilizing a ForAll(assuming you have less than 2000 logbook rows) and do a collect for each one into the same collection. Then you'll have that collection local to get your counts for your groupby or what not. I think this might work out.
Mine is static, so I have one for each count, but if you have dynamic, you might look at utilizing a ForAll(assuming you have less than 2000 logbook rows) and do a collect for each one into the same collection. Then you'll have that collection local to get your counts for your groupby or what not. I think this might work out.