Showing results for 
Search instead for 
Did you mean: 
MiConroy Advocate I
Advocate I

Loading Excel Table Data


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

Community Support
Community Support

Re: Loading Excel Table Data

Hi @MiConroy ,


Do you want to make one offline app?

Please reference:


Best Regards.



MiConroy Advocate I
Advocate I

Re: Loading Excel Table Data

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 Community Champion
Community Champion

Re: Loading Excel Table Data

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. 



MiConroy Advocate I
Advocate I

Re: Loading Excel Table Data

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.

Helpful resources


Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!


New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,338)