cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Readonly offline datasource, with possibility to update?

Case:

I want to create a Powerapp that relies on a locally stored database (because the app needs to work without internet connection), but at the same time the database will have centrally stored master data. And "database" here probably refers to an Excel document or a Sharepoint list.

 

Once the data is on the client device everything works just fine, I guess. But what's a good Powerapps approach towards pushing new versions of the database to client? For my scenario, anything from pushed updates to manual polling from the client  to scheduled updates is okay, as long as there is a way to send new data / retrieve new data for the clients.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Readonly offline datasource, with possibility to update?

Hi Estomagordo,

 

Are you using this connection as your data source?
1.png


As currently, Excel Static connection is read only. We are not able to write new data to it.
Please see this thread for a reference:
https://powerusers.microsoft.com/t5/PowerApps-Forum/Patch-against-Excel-workbook-returns-error/m-p/2...


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Readonly offline datasource, with possibility to update?

My first instinct was to do just that and use a static data source.

 

Does a data servuce support my scenario? That is, can I access a locally cached version of a centralized data service, when I have no collection?

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 (5,098)