So I am trying to dig deeper into collections and how I could use that to store some information locally and then use it to load to a different screen. I am trying to make my performance better because right now it is loading every screen I have when an item is selected and the loading dots appear for a while. The database I have is over 10,000 records so it is pretty large and I want to cut down on load time as much as possible.
First Screen: For starters the first screen is a gallery combined with three listbox filters. The first and second filter are used to filter the list to return less records and the third listbox selection directs them to a specific page based on their selection on the third screen.
My formula for the gallery looks like this:
Second Screen: It then leads them to another screen/gallery (the second screen) that adds the filter to the gallery based on what item they selected on the first screen.
Then when they select the item on the third screen it uses the third listbox that I discussed on the first screen to direct them to the screen for that product.
Note: instead of just loading the screen they navigate to it loads all of the information for each screen even the ones they didn't navigate to. Is there a way using collections to store the data locally and only load it on the screen they navigate to? Or any other way to cut down on load time and only load the screens they navigate to?
Let me know if you have any further questions or suggestions!
Solved! Go to Solution.
Would you please share the formulas you used in your screens?
And if would be better if you could share some screenshots here.
For collection usage, please check:
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!