Data Not Updating in PowerApps

[Migrated_User]

Content migrated from TechNet.  Post attribution to: ChristianTejada

Hi Everyone,

I've been playing with PowerApps for the past few days and I've been experiencing quite some few weird issues. For some reason, my data doesn't update in PowerApps whenever I update the Excel sheet. The same is true for both sample templates and blank templates created from scratch. It'll create fine using the data I have, but once I go to modify the data in excel it will not reflect in powerapps. The same is true whether I check in editor, in the play section, or even upon app deployment. It's a rather weird issue, but I can't seem to get any data edited whether it be text, columns, or rows to update in the app.

Has anyone else experienced this? Is Dropbox or Gdrive not syncing properly? Or perhaps I'm not connecting the data properly?

Thanks,

Christian 

[Migrated_User · Accepted solution]

Hi

Please use REFRESH(TableA; TableB,..) in:

- OnVisible, or

- a button, OnSelect.

So, when you change data in excel (NOT Structure), data will be refreshed (sync) automatically.

You can see ....... moving in from left to right on top the screen.

NB: This is new features compare to Project Siena (which is static).

Data syncing between Apps and Excel is done through PATCH. Please read the help file.

[Migrated_User]

I've got the same issue.

My data is stored in an excel file which i stored in my personal onedrive.+

In my app is a save button and on the "OnSelect" method i use the update funtionality.

After that the data is only stored in may app, but nothing happens in my excel file.

I also tried the updateif - method with the same result.

[Migrated_User]

Hi

Please use PATCH (..) NOT Update or Collect.

Please read other thread and help in Powerapps website. PATCH is for read/write, which is NEW in powerapps.

Feel free to share with me the apps over link.

[Migrated_User]

One caveat I can add is that if you make edits to your Excel file, it will take a few seconds to upload to OneDrive. After those few seconds, that's when you want to push Refresh.

Also, if your Excel file is open, you will not be able to write to it using Patch, Update, or UpdateIf. I am working on a way to check if it is okay to write. I will link it here once I figure it out.

[sajarac]

Hello there, sorry to open this issue again, but I cannot figure out how to do this?

I have my power apps with an excel file, the template has the "SAVE" default button at the top which is does the submitform, but it saves the data into the form not in the excel file.

could you please explain how to achieve this?

[JV_DXB]

Hello @Migrated_User 

I am new to Power Apps. I have an excel file from One Drive which is used as the data source. I am unable to see updates which are done on the excel source file (adding a new row to excel). I already have a refresh button with Refresh(Table1). I have checked by closing the Excel on One drive and then refreshing, closing the app and reopening etc., but the changes on Excel do not reflect back on the App.

[Michael158]

Seems to be common!!... 

I tried this with literally the OOTB Dataverse app creation from an excel data source table on 1 drive. The exact thing is happening. I go to edit, hit submit, then data on view screen or gallary is not updated..

Steps to replicate are simple

- Create an excel on one drive with a Table in it. (use format as table option).

- Create a connection in power apps to your one drive and find the excel and table.

- Use Dataverse to create a default app. It gives you three forms. Gallery, View and Edit.

- Try doing an edit - it will send the updates to the excel, but nether the view or gallery update in power apps, even if you use a force refresh button e.g. Refresh(table1)

NB: When running the app (and not in preview). if you hit browser refresh it will update, but the normal power apps refresh does not work.