Showing results for 
Search instead for 
Did you mean: 
Advocate III
Advocate III

OFFLINE MODE from SharePoint List

Hi all , 

I have a SahrePoint Lists witch i build my powerapps application for our compagny. I read all this post about offline mode : 


OFFLine Mode :




But , i don't really catch how to get it. My goal it's very simple. i"m looking to use the apps on offline mode without patch , load or something else. My users will just reading the information on my apps No edited items ll'd adding , no update , Juste running apps while being offline. 


Someone have a very clear steps with a concrete example ? 


All helps will be appreciate , tnx Communuty.

Community Support
Community Support

Hi @charafRef,


The current logic for offline App requires the App has been connected Online (with the data source ) at least once.

Which means that if you would like the App to be able to work offline, there should be a local copy of the data saved in the mobile device (when online earlier).


If this is acceptable, then you may consider take use of the offline defined in the blog you mentioned.






Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

How to make a local copy data ? and  do you have another example cause this one isn't clear for me ? 


      ClearCollect(LocalTweets, Twitter.SearchTweet("PowerApps", {maxResults: 100}));
      UpdateContext({statusText: "Online data"})
      LoadData(LocalTweets, "Tweets", true);
      UpdateContext({statusText: "Local data"})
  LoadData(LocalTweetsToPost, "LocalTweetsToPost", true);
  SaveData(LocalTweets, "Tweets")

best Regards , tnx


Hi again to all ,


Someone have a simple example how to build offline mode , cause the Twitter example of Carlos Figuiera

doesn't help me , the article is not clear as well. We need some helps how to build an offline apps from SharePoint List ? 

@v-micsh-msft , @Meneghino , @CarlosFigueira ? 


thanks for your help in advance ! 



Impactful Individual
Impactful Individual

What sort of data are we talking? Tables? Website?


1st step: Collect(Name,data_source,criteria)

Name: a name you want to store the data under

datasource: the table name for instance that you have added under datasources

criteria: ie: if you wanted to filter table by ID then it would be Filter(table,ID = some number)


If you want to clear out any previous data the use ClearCollect instead of collect


2nd step: Savedata(Name,"Name")

Name: the collection name above

"Name": i would keep this the same but you can save the data under any name you want


Now when you load the app set your onstart property to


Set your datatable or form or gallery items property to: Name


How this is set up is: it will load the app, import any data, save the data, reload the data, so that your form/gallery etc will show it


If you change to ClearCollect then any previous data would be wiped before it inports anything further.


Thats the simple explanation, but there is so much you can alter and add such as conditional statements.






Great , it's more clear for me now.

But still doesn't work for me  i unerstood why ! i'm using a web studio  , i can't import Colelction , save and load Data. i don't have access on Windows 10 on this moment. 


Tnx for your reply and your time.

Not applicable

Hi ,I need bit of help regarding offline mode using sharepoint , I have tried everything but the local cached data is not getting updated in sharepoint when the app is getting reconnected to internet , though it doesn't shows any errors. Offline data not getting updated in sharepoint. Below is my code, Pointer : When user is offline and trying to make a new entry his record is being saved in Collection "LocalUpdatedRecords" and when he regains the internet connectivity the records should be updated in sharepoint list "Offline test" .I have tried Using Patch ,Update ,Collect etc but nothing seems to update the records in sharepoint, any suggestions will be highly appreciated. Thanks in advance. If(Connection.Connected && CountRows(LocalUpdatedRecords)>0, ForAll(LocalUpdatedRecords,Patch(OfflineTest,Defaults(OfflineTest),{FirstName :lbl_FirstName,LastName:lbl_LastName,Age:lbl_Age,Mobile:lbl_Mobile})); Clear(LocalUpdatedRecords); SaveData(LocalUpdatedRecords,"LocalUpdatedRecordsToBeAdded"); Refresh(OfflineTest); ClearCollect(OfflineData2,OfflineTest); SaveData(OfflineData2,"LocalCachedData")); Navigate(BrowseScreen1,ScreenTransition.Cover)

Impactful Individual
Impactful Individual

Try using UpdateIf, ive found patch doesnt work reliably. 


I see SaveData entries, however no LoadData entries..

SaveData and LoadData ONLY save data into the local devices cache.  If you want to use that data you HAVE to load it back into a collection first.


So i could:

Collect sharepoint list to collection A

SaveData A to "A" (this now allows me to exit/close the app)

I now reopen the app

LoadData "A" to A (this puts that saved data back into collection A (which should already be empty as we closed the app)

now i can update it back to sharepoint.


have you tried these formulas individually..

Collect the sharepoint list, make a change, patch it back, check it works..

Collect the sharepoint list, savedata, exit the app, loaddata, see the collection is populated again..


You can check these by just putting 2 datatables on your opening screen linked to the collection and the sharepoint list so you can see it populate with the new values, and have the two formulas on a couple of buttons.  I usually have a seperate screen for testing which i can delete once ive finished the app, helps you to see whats going on. 


so for me, to save overcomplication, i do the following:

1: App on start property: loaddata into collection "A", check if there are records in collection "A" (rowcount), if true then dont collect  sharepoint list, if false then collect sharepoint list and then savedata

2: work purely on the collection and forget the sharepoint list altogether now.

3: on your form, everytime you update the collection make sure you savedata stright after it.

4: you can quit the app as much as you want and all your data will always be there now.

5: have an upload data/merge changes button which will update the sharepoint list with your collection data, then clear the collection, savedata

6: now when you reopen the app, the collection wont have any rows so it will load the sharepoint list.


i found connection.connected to be too unreliable, what happens if its dropping in and out constantly, half updated records etc, button much better.

you can also add a formula in before you clear the data to check all changes were updated before you clear it out (incase of flaky internet)


Advocate V
Advocate V

In addition, please keep in mind that offline data doesn't work when used in browsers (either in player mode or in powerapps studio). It only works in the PowerApp app on mobile phone and in the PowerApp desktop app.

Not applicable

Hi, Thanks for your reply.

I tried all the above methods , still my sharepoint list is not getting updated with the offline data after re connecting to internet, as you said offline feature won't work for web, I tried in mobile app, still facing the same issue.

Please if you have worked on offline feature can you share me the code, it wll be very helpfull.


Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

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