cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Applicable88
Advocate II
Advocate II

Caching a sharepoint list as a lookup table in the app

Hello,

 

I want to improve the perfomace of my app starting on an android phone.

Is it possible to cache it with a function?

 

Thank you very much in advance. 

 

Best. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Drrickryp
Super User
Super User

@Applicable88 

Collect(colList,SPlist) will work as long as the list is not more than 2k items.   colList can be used throughout the app in place of your list.  If you have a very large list that doesn't change, like zipcodes or a stock inventory, you can use a static Excel file as I described in my post https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Automatically-Prefill-City-and-State-u... .  The performance is blindingly fast. 

View solution in original post

1 REPLY 1
Drrickryp
Super User
Super User

@Applicable88 

Collect(colList,SPlist) will work as long as the list is not more than 2k items.   colList can be used throughout the app in place of your list.  If you have a very large list that doesn't change, like zipcodes or a stock inventory, you can use a static Excel file as I described in my post https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Automatically-Prefill-City-and-State-u... .  The performance is blindingly fast. 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,451)