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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

load data and sync

(0) ShareShare
ReportReport
Posted on by 2,129

Content migrated from TechNet.  Post attribution to:  Marcelo111

 

Based on the tutorials and reference, I assume we will be able to sync changes from collections into the database in the near future. That will allow occasionally connected scenarios and open many possibilities. My question is: can I do it now? if not, when it will be ready? 

Also, I could not manage to load data previously saved when using the app. It works when I preview it from edit mode, but not when I launch the app. Am I missing something or this is still not available?

Thanks


Marcelo

Categories:
  • Migrated_User Profile Picture
    2,129 on at

    Savedata and Loaddata are temporary. If you are looking for a permanent solution, you will want to look into the Update, UpdateIf, and Patch functions. They will record information straight into your Excel tables. 

     

    Once information is saved to your tables, you can use Refresh to reload any changes. Changes are automatically reloaded upon closing and opening the app, so you won't need to use Savedata and Loaddata.

     

    https://powerapps.microsoft.com/en-us/tutorials/formula-reference/

     

    If you are interested in saving your entire Collection back into the Excel table, I have been working on some different solutions while the PG team considers multi-row-patch.

  • Migrated_User Profile Picture
    2,129 on at

    This is the way I understand:

    Collections are temporary and clear when you close the app.

    SaveData saves data in encrypted private powerapps storage that can be acessed later by the same app with the LoadData function.

    Export function saves encrypted data to a zip file (in the local file system) that can be opened with the Import function by the same app or another powerapp, but not anyway else. In PCs the zip file is available in the local file sytem. I dont know where the file would be in na Iphone.

    Export and Import already work fine, but SaveData and LoadData don't.

    Excel can be used as the cloud datasource but requires an internet connection to be updated. Offline scenarios require local data that can be updated locally, stored and used to sync to the datasource when a connection is available.

    For that to work we need local storage within the app (save and load being easier to manage and less prone to erros than export import to local file system) and a sync function, that would compare local storage to online storage and do the inserts, updates and deletes required.

    Question: Is save and load data already available? Will we be able the to sync the local storage to the online storage in the near future?

     

     


    Marcelo

  • LUNA24 Profile Picture
    98 on at
  • LUNA24 Profile Picture
    98 on at
  • LUNA24 Profile Picture
    98 on at
  • LUNA24 Profile Picture
    98 on at
  • LUNA24 Profile Picture
    98 on at
  • LUNA24 Profile Picture
    98 on at
  • LUNA24 Profile Picture
    98 on at

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 396 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 323

#3
WarrenBelz Profile Picture

WarrenBelz 193 Most Valuable Professional

Last 30 days Overall leaderboard