web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Cache Large Sharepoint...
Power Apps
Unanswered

Cache Large Sharepoint Lists to Powerapps for Offline Use

(0) ShareShare
ReportReport
Posted on by 7

I am creating an app for data collection that refers to a few sharepoint lists. While online, the app works just fine presenting all results from the Sharepoint Lists that I am referring to. When I go offline, it seems to only pull maybe the first couple hundred rows from the list (understanding that I need to first be online to cache the data prior to it going offline).

 

Is there a way to bring in more rows of data when creating and saving the collection? Code for App OnStart is below. The source that I am specifically having problems with is AssetTaxonomy (Collection=Type). This table has about 1,200 rows that I really need to be available while offline as well as online. I have dependent dropdowns in my app that use this data to present recommended maintenance schedules.

 

I have searched this site and couldn't find anything that gets me to where I need to be. Thanks for the help, this site has been very informative!

 

//creates collection

Concurrent(
ClearCollect(AssetRegistry,'Asset Registry'),
ClearCollect(CIBSE,'CIBSE Rating'),
ClearCollect(Type,AssetTaxonomy),
ClearCollect(Geo,'Site Geography Data'));


//loads collection locally
Concurrent(
LoadData( ColEventData,"Offline Asset Data",true),
LoadData(AssetRegistry,"RegisterLocal",true),
LoadData(CIBSE,"CIBSELocal",true),
LoadData(Type,"Type local",true),
LoadData(Geo,"GeoLocal",true));

//saves location locally
Concurrent(
SaveData( ColEventData, "Offline Asset Data"),
SaveData(AssetRegistry,"RegisterLocal"),
SaveData(CIBSE,"CIBSELocal"),
SaveData(Type,"Type local"),
SaveData(Geo,"GeoLocal"));

Notify("Data sources cached")

Categories:
I have the same question (0)
  • Verified answer
    BCLS776 Profile Picture
    8,994 Moderator on at

    There are two limitations you may be running into:

    • Each Power App has a row limit that can be returned in a single query. It defaults at 500, but can be increased to 2000 and can be found in the app settings
    • Connectors often have size limits for the response that is returned by the query and your queries are requesting the entire table. Try using the ShowColumns() function to have only the desired columns return into your collection, which will hopefully help overcome any data volume limits.

    Hope that helps,

    Bryan

  • ISStester Profile Picture
    7 on at

    This appears to have worked. Slowed the app down quite a bit on start but I can work through that to improve. Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard