Loading Excel Table Data

[MiConroy]

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")

[v-yuxima-msft]

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

[MiConroy]

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.

[TopShelf-MSFT]

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. 

@TopShelf-MSFT 

[MiConroy]

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.