Hello,
I am currently making an app that uses Excel tables that are stored on OneDrive. This application works great when the user has an internet connection. I am trying to make this app work offline as well.
The app saves the OneDrive table data locally, but I am struggling to load the data to a collection.
Any help would be appreciated.
Here is my current (and likely very inncorrect) code in the app's main menu OnVisible function:
/*Checks if connected and refreshes*/
If(Connection.Connected, Refresh(Table2_2));
If(Connection.Connected, Refresh(Table2));
If(Connection.Connected, Refresh(Table4));
If(Connection.Connected, Refresh(Table5));
If(Connection.Connected, Refresh(Table6));
/*Save Table Data*/
SaveData(Table2, "Table2_local");
SaveData(Table2_2, "Table2_2_local");
SaveData(Table4, "Table4_local");
SaveData(Table5, "Table5_local");
SaveData(Table6, "Table6_local");
/*Load Table Data*/
LoadData(Table2_collection, "Table2_local");
LoadData(Table2_2_collection, "Table2_2_local");
LoadData(Table4_collection, "Table4_local");
LoadData(Table5_collection, "Table5_local");
LoadData(Table6_collection, "Table6_local")
Hi @MiConroy ,
Do you want to make one offline app?
Please reference:
https://powerapps.microsoft.com/en-us/blog/build-offline-apps-with-new-powerapps-capabilities/
Best Regards.
Yumia
This tutorial only really goes through how to save data locally and submit it once it is online.
If anyone knows how I would love a tutorial on how to get data from a OneDrive Excel Table, Save it locally, Load it on startup and reference that data to view it without needing internet.
Thanks for posting in the community @MiConroy. I'm going to bump this to the top of the discussion forum in the hopes that fellow users can provide some guidance for you.
Are there any tutorials that explain how to download table data from OneDrive to a local device and then use that locally saved data to make a Gallery?
The ultimate goal of this is to allow users to use the app's most up to date local information if there is no internet/network connection on the device.
User | Count |
---|---|
139 | |
132 | |
79 | |
74 | |
74 |
User | Count |
---|---|
207 | |
196 | |
70 | |
62 | |
55 |