PowerApps Offline Mode 

Shane you are such a legend, the way you put these videos together, the way you explain things step by step showing what's best for user experience... all I can say is thank you for sharing your knowledge, so others can grow theirs.

Great video Shane. I've watched many of your video's (being relatively new to PowerApps) which have helped me get across the line with a proof of concept app based on SharePoint for our sales team. I have now started a production version of the app, using SQL as the data source, and watching this video made me re-consider using forms based on the fact that the app will be used on iPad's and will require offline capability. I'm now capturing everything in collections so I can use the save and load features. Love your presentation style too!

This is great Shane! I was struggling with this and almost quit Powerapps because of continuously problems of connections. Thanks a lot for this!

Hola Shane, soy de Colombia y admiro su trabajo. Estoy iniciando en el mundo de PowerApps y con sus videos he aprendido demasiado, un fraternal saludo y espero que mantenga ese espíritu de enseñanza.

This is exactly what I wanted to know. I have to build an app to work along a highway and the cellphone signal is really poor. This is the solution I needed. Now I have to find this second video of you ;)

Shane! Thank you for making these videos for all your followers. Can't wait for part 2!

This is what I have been waiting for. Thank you Shane! Looking forward to your next video!

Great video as always Shane! I’ve got a couple of different situations that require offline solutions so I’m looking forward to part 2!

Great content as usual, Shane! Thank you for your dedication and the time you spend creating this awesomeeee content! (PS. still eager to watch pt.2 :), say hi to Chewy)

Hi Shane, great videos for learning, would love to see something on Power Apps portals and in particular using forms in the portal.

This is fantastic, didnt even know you could do this, already have an idea I can use this for, thanks as always Shane !

Thanks Shane! I have been waiting for this video, I mean, about work with images in offline mode. I will wait for the 2nd part!!

Looking forward for Part 2, Great Post. Thanks.

Super cool Shane! Would love to see how you did the image Update into the document library together with the data! Using a Flow and a For All I guess but would be nice to see it built in action and saved from the collection to SharePoint.

Shane, great video with wonderful information about building apps to work offline. Thank you, as always, for producing and sharing.

Great video. For part 2 could you show how to preload data from your source? For example if you have a list in sharepoint, but you need to edit some of the records offline, and load the change once online. Thanks

Hey amigo gracias por los videos me han ayudado mucho en el trabajo más profes menos RU-vidrs saludos desde Colombia un abrazo

I was thinking about implementing this in a new app for our regional field service people who are often out of data serviced areas. A few hours later, here you are! I must admit, I'm a little worried about how delegation with sharepoint lists might be impacted by offline use because I've already been fighting a lot with delegation in this app.

Hi Shane, Great video on power apps offline and as other have mentioned Iam also waiting for part 2 of this video & hopefully you will upload it soon.

Another great video from the master, thank you Shane 😍

HI shane. excellent Video . A very practical example of what we can really actually do with the App. Kind Regards. Martin ( south Africa)

Hey Shane, was there ever a part 2 for this video? This is my favourite video of yours as I deal with remote site inspections that often have no reception. Thanks for the great work.

Great content as usual, Shane! Thank you for your dedication and the time you spend creating this awesomeeee content, a quick question please , can i do this method with attachments ?

Great Video Shane, when to expect part 2? Hopefully with containers and saving camera and media for inspection-category-questions in collections + when = connection.connected save them to SP365 library with reference&tags or to list as attachments?

Great video, thank you! I'm using it as a model to track locations with limited cellular data.

Good stuff man. I'm assuming part 2 will cover syncing this to SharePoint or some other data source? Looking forward to it!

Great vid as ever Shane, love this series. Could you cover PowerApps deployment tools at some point? There's not much coverage on this, Cheers! 😁

Thanks for this. I learned a lot from this video, but I'm still *really* needing to know how to incorporate the picture component in offline/online capable apps. I can't seem to figure it out. I hope you cover this topic in part 2 . . . and soon!

Great new ideas how to deal with disconnected devices, ❤thank you

I have to say "Thank you". Everything is on the Point, and very helpfull ! br jonny

Great video! Looking forward to part 2. One question, though. How would this work with forms? I would presume you'd need to do the same sort of thing - check to see if you were online or not then either submit the form or add to the collection.

As always, a very helpful video. Thanks Shane! I did have one question though, I could not get saved data to load on my phone until I reversed the connection check. I had to use the !Connection.connected function to make it work. I couldn't get past the network connection error when it couldn't reach the SP list. Your building block approach helped me figure that out! Have you seen this behavior before?

Great Video Shane ! Thanks a lot :)

Loved it. exactly what i wanted to know.

Hey Shane! Nice video as usual. Question: how do you manage single ID on the source table when you get back on line ? Thanks.

Hi Shane! Great videos! Thanks for the clear and easy to follow tutorials. Quick question - I've produced an app which takes advantage of working offline and I'm storing base64 images in a collection, then pushing to SQL when the user clicks submit. The only problem I'm having is transfer speed times. For about 10-15 images this takes about 3-4 minutes, and with Azure SQL , I have had issues where the transfer needed" retried" as the collect couldn't finish. What's typical in terms of speed for getting base64 images off a device and is SQL the best option for speed? Thanks!

Great work! One question , is it possible to save (list) forms into collections and then submit them into the same list in sharepoint? Basically allowing offline forms to be saved in order to be submited later.(when connection is back on) Keep up the good work! Regards, Emanuel Leston

Hey Shane, You are awesome and the baby steps technique you use is awesome... Can u plz let me know the link of the part 2 video of the Offline app development?

Really outstanding! what a great and needed capability I do have a query though - is there a limit to how many collections can you save in one app? say I have 5 collections - can I save them all? If the answer is - yes - so then how? what would be the syntax?

Great Video Shane, thanks.

Great video and app.. Exactly what i wanted. Question does it compress the pictures?

Thanks Shane, I've been struggling with this for months. actually gave up. In Part 2, Would you please cover adding Photos taken by the Camera control, adding it to collection with Save/Load Data. then passing it to Flow in order to upload a .Jpeg to SharePoint? Is it even possible?

Awesome Shane, you're a crack!!!! Please I want to know where I can find part 2?? I'm very interesting to connect my collection to a Data Source like Sharepoint. Thanks again.

Hi Shane, thanks for the video. How do you upload the data back into the sharepoint list?

Beautiful ❤ thank you!

I love you Shane!... New follower.

Hi Shane, has the part 2 video been posted? I am looking for a way to save data with pictures on the device if offline and then load when online and then publish it to a sharepoint list(attachment included.)

Hi Shane, when is pt 2 online? Can't wait to learn more! ;-)

Hi Shane.. I am eagerly waiting for this video and thanks for uploading. I have a question on this sample demo, How to check whether data is saved or not in home screen when app is suddenly closed/crash(Video:3.38 duration)?

Again, GREAT Video. I build a complete off-line solution. My only concern is I am unable to peoples pick with a ComboBox with an offline Peoples Collection.

Thanks Shane! It is helping me a lot at work here. But how would i submit Date and Time? When i use Collect, i pick DATE_DataCardValue.SelectedDate separately from HOUR and MINUTE DataCardValue.SelectedText... So, it becomes 3 separate data, but i gotta submit it in only 1 text line. Hope i made my question clear

Hello Shane, very good video, do you know if can I take photo or save an attachment in the app in offline mode, and after upload the itens in a sharepoint list using something like ForAll(Patch(...?

HI Shane! great vid, can you share the link to part 2?

Thanks for the video I really need it, It's possible to do a loaddata and then add items to that collection. Example LoadData(CacheItems,"CacheItems",true); Collect(CacheItems,{Value=1});

Thanks for this video Shane. I am guessing if I use a editform control, I would not be able to use submitform() in offline mode. Instead, I would have to collect the form record in a collection and then patch it to the datasource when the device is connected. Is that correct?

Hi Shane, I know you didn't release the part two. Just wondering how you did the image save because I have a similar scenario where I'm saving the json of the image from an attachment control into a collection then SaveData on that but I keep hitting some kind of cache limit? I hope you're doing well snd you're able to answer my question - all the best!

Hello, Shane. Can you help me with power apps? I almost given up :D the case is that I need to make non editable fields after choosing the one parameter in dropdown list. Do you know how to do it?

Hi Shane. Just a heads up that Microsoft advised me just before Christmas that the Desktop app for PowerApps is being depreciated and is no longer supported by them. I was advised by them to use the web version of PowerApps moving forward.

Hey Shane, great video! I have also done quite a bit of work with offline apps, but there were some helpful tidbits here. Your patch collection video was great, but can you do a video on how to patch datasources with a focus on preventing duplicates? There is very little "helpful" information online about this and it is a big problem! (Especially with offline apps)

You are incredible. Is there already the possibility of offline first in powerapps, to query a database in sharepoint offline via the app? (my application is for the traceability of a pre-registered product in the warehouse, and the same product installed in the customers. But if the professional in the field has no internet, he cannot edit the values ​​in the same pre-registered item in Sharepoint via powerapps)

Hi Shane, another great video, this topic came up at work the other day and now we have a solution, thanks. One question, how do you create the online/offline icon in the bottom right corner please?

Hey Shane!... quick question.. is it possible to save more than one collection in the same file?? o do i have to create a savedata per collection???.... you have saved me so many times with your videos!! like.. seriously! :D

Great video, is there a way to do cascading dropdowns while offline? I’m thinking of some sort of collection with preset data?

Hey Shane, does Location.Latitude and Location.Longitude work in offline mode on Android device? I'm working on a geolocation app for remote workers so grateful for any help/tips.

Hi Shane, nice video very comprehensive as always. May I know do you have the link to part 2 of this video as it i very important to me? Thank you

Thank You Shane, I did the same example, the button works offline mode and sometimes it doesn't work offline mode. I have tried several times, but the button does not work and does not save the form in the collection. Greeting from Chile !!!

Great video Shane! I have a question regarding Site Collections. Take an example: Is it possible to create a sub site named google.com under facebook.com site collection, like in an organization there are many different departments so if I create a single site collection and wanted different names for departments like corporate.com, sales.com, creditLoan.com, Is it possible? and how to do that? Please let me know.

Hi Shane, thanks for your valued videos, it's really beneficial. I do have an issue with offline mode, I did an app before and followed all Microsoft institutions and tried your way as well, my issue is when I close the app and open it again and when sync data with SharePoint page I got a blank item. please advise. many thanks in advance

Dear Shane, it is possible to guide me on how to proceed with a DataCardValue with a Combobox control, when changing the Item Property to a collection, created through a ClearCollect, with data from an Excel Table that is in Ondrive, the collection is loaded in OnStart. The DefaultSelectedItems Property does not recognize the Parent.Default of the Parent DataCard. It looks like the value of the Parent.Default, but the item is not selected in the combobox, it is as if the Combobox.selected.value = "".

Where does it save the data on your phone? Your videos are mind blowing.

Hey Shane, this is good. Can we apply this to a form to make the collection?

great videos, I am looking for offline capabilities of powerapps to search for a record among 100000 records or download 100000 approx records?

I have an app we are trying to add offline capabilities into. One thing I've been wishing I could do is check monitor for my app that is running on my phone. Do you know of any way to view monitor from the phone? Maybe how to display performance data in the app itself? I would love things like responsesize and just general savadata action info. How do I know how much phone space I am taking up with the files I am saving?

Hello Shane Young! When I click submit my data from collection to data base, there is message error: is not null. There are any Ideas, what's happend?

Is there any way when you can view the data you've collected while still offline? Is there any way you could download or extract that data in a csv or excel file while offline?

I realize you have a course that would show how you saved the attachment offline. I’m curious, is it possible to do multiple attachments in offline collections? I have a field inspection app where it would be nice to save some inspections locally in poor service areas.

Reading through the comments it looks like you never posted a follow up on youtube, but did create something on your site. which on demand training course do I need to purchase to watch a follow up? I'm trying to create a form that updates a collection as the user moved through the pages, and then patch and save the forms back out through the SharePoint list.

Hi Shane, how do I submit the gallery/collection to my Sharepoint data source(that button on the first screen)? thanks and by the way your videos are great 👍

HI Shane, another powerful video. You might be able to give me some ideas on this. I have been given a task to create an app for auditing assets. Currently 27000 line items. Much of the location makes the audit off line. The asset list is very poor in that I cannot drill down the items (no category's, poor location management etc) to get into manageable off line collections. I have found a way to create a collection based on the 27000 items by importing an excel spreadsheet, so I can get it partially offline but now really struggling with taking that data and updating the duplicates that will be in an SP list. I know I can add, but not sure if functions like updateif() will do that given the enormity. Do you have any special ideas you would look at to manage this? I am also not sure how the imported excel file is actially managed. I think it only stores the data once and is not really updateable

Thanks for the video Shane. I have an issue, my phone camera not open when i choose get a picture from camera, i just can choose from gallery, even i have the app permits for camera. do you know what this is happen? Thanks a lot!

Thanks for this

Thanks for the video! Where can I find part 2 that you mention?

Hi Shane, is there any reason why when clearing the collection, the items in the collection reappear when the app is reloaded?

Shane. cool app.. but I have a problem which i tried to see. After saving the data to the device. I exit as shown by you, I get back and I see my Gallery has the 1 row or card showing blank. Then when I click the Load data, rest of my data loads just below the blank galley row. So in total I would have 4 rows in which the 1 row is blank and the rest of the rows below has data from the device. I your tutorial video i see that when exit and come back the gallery does not the 1 blank row. Do help in resolving the same. Also when is the part 2 of this video coming Shane.

@shane: What about the data stored on the phone. How would that be deleted? Is there a possibility to do that from the power app or happens that in another way?

Load Offline Data to Edit Form Scenario: I have SharePoint Form split into multiscreen. I have requirement for Offline mode. I am saving the data to a collection. How would I load that data to edit form. Do I need to do away with forms and build screens with input controls or do we have some other way to load the data from collection in edit form to save back to SharePoint list. 2 Galleries: 1: Load SharePoint List Data for View and Edit 2: Offline records. I need to edit these records in Edit form before I submit to SharePoint list

Hey Shane why the same function in my power app ios application not giving the same data when I cleared that app in background and restart it

Is this still something that is available in the current iteration of PowerApps? Specifically the image / doc upload.

Hi Shane, I built the app to work off line but I am getting a road block on App start. I keep getting the Allow Connection Screen for SharePOINT. If my device is offline, it will not go past this point to open teh app. I know I used to get this first time use, but am getting it every time now so I cannot properly test. Do you have any ideas why this is happening. I am App Owner and owner of the SP list

I'm actually working with sharepoint List forms and Savedata, then LoadData seems to respond to what i need for an offline solution but I'm in front of a wall, and a big one: how about savedata with attachments from a sharepoint list? I've seen a lots of your video. Each one approach a global solution, and that's frustrating ;). I've a start of solution: when online, we submit the sharepoint list, and when offline, we savedata (there I block on attachements maybe a solution with a concat and a multiple var of each file in a base64only), then Loaddata and on Start of application patch it if online and start a flow which send photos?? with a for all? That all i miss , you respond to peninput signatures, offline system, delegating sharepoint lists,...thanks a lot for that. Any idea for this last enigma? ^^

Shane - Where can I download your demo app to borrow some of your solutions?

Do you have an timeframe yet for when you will have part 2 out?

Is there already a part 2 Shane?

Hi Shane, i have builded offline app. Problem for me is once network gone i dont see any apps in my app list. I get the message "you dont have any apps" i am not sure why this is coming ? Please advise,

Hi Shane, You mentioned as an aside in the video that you can download an app to run the app on a PC. I tried to download today and it says not found. I then read elsewhere that the app has been discontinued. Do you know whether this is the case? If so, is there another way to use it on a PC. Thanks

Hi, could you share how to make inserted image media available offline?

Hi Shane, when are you releasing part 2?

Hello Shane, hope you will answer my question. I tried the Save() and Load() function in my app. Problem occurs when i Re-start the app the Offline collection displays nothing in the gallery. As such the session is maintain offline mode runs perfectly. When i close and re-open the app, collection displays nothing. Please help me out. I even give the storage access to Power Apps but still no success. Wil wait for your response. Thanks in Advance!

I'm creating an offline application to register products in a spreadsheet. However, when I go offline, the application tries to connect to the spreadsheet and shows a red error message "failed to load". Is it possible to disable this message?

Great video shane, can someone help me by directing me to a video that submits the gallery/collection to sql please