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.

TopShelf-MSFT
Level 10

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 (Last 30 Days)
Users online (6,216)