cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MiConroy
Level: Powered On

Loading Excel Table Data

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

4 REPLIES 4
Community Support Team
Community Support Team

Re: Loading Excel Table Data

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
Level: Powered On

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.

Administrator
Administrator

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. 

 

@TopShelf-MSFT 

MiConroy
Level: Powered On

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

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 219 members 5,640 guests
Please welcome our newest community members: