Answered

Excel from onedrive (Excel Online Business connector) as datasource - gallery shows old data after form submission

Like (0) Share

Report

Posted on 10 Mar 2022 13:05:49 by Community Power Pla...

Hi,

I have an online excel on onedrive ("Excel Online (Business)" connector)with data table used as a powerapps datasource. I have a gallery listing records and edit form. After I submit data (patchRow) gallery still shows old data. Why is that? I do not use view form between gallery screen and edit form but go directly. Any ideas? Data is patched successfully - I have checked using monitor - patched record is being returned from patchRow call but then it seems that gallery is refreshing it's datasource and having old data being returned. Any ideas? I am actually not sure why gallery needs refreshing - why datasource isn't just patched and reused as a gallery's items?

Categories:

Connecting to Data

All responses (8)

Answers (1)

Community Power Pla... on 11 Mar 2022 at 08:07:52

Like (0)

Report

Re: Excel from onedrive (Excel Online Business connector) as datasource - gallery shows old data after form submission

Yes - that is the case, thank you - when I remove fiter/sort from the source then updates are reflected immediately; I guess it makes Excel as datasource unusable as I won't be able to filter user-specific rows 😞
Verified answer

BCBuizer 22,262 Super User 2025 Season 2 on 11 Mar 2022 at 07:46:20

Like (0)

Report

Re: Excel from onedrive (Excel Online Business connector) as datasource - gallery shows old data after form submission

Hi @Anonymous,

So the issue is about a delay in updates, rather than updates not working at all?

Because if the first is the case, this is listed under known issues and limitation in the connector documentation:

https://docs.microsoft.com/en-us/connectors/excelonlinebusiness/#known-issues-and-limitations-with-actions
Community Power Pla... on 11 Mar 2022 at 07:10:34

Like (0)

Report

Re: Excel from onedrive (Excel Online Business connector) as datasource - gallery shows old data after form submission

It is excel online (business), directly attached to the gallery and it does support delegation:
Updates to the Azure File Storage and Excel Online (Business) connectors | Microsoft Power Apps
(after Working with Excel file in Power Apps - MoreBeerMorePower (hatenablog.com))

Excel file is updated immediately but refresh brings new data only after two minutes.
ansrikanth 329 on 10 Mar 2022 at 21:56:41

Like (0)

Report

Re: Excel from onedrive as datasource - gallery shows old data after form submission

hi @Anonymous

If you bind the data source directly to the gallery then it should automatically refresh, however if it is bound via a collection (ie. Collect the items in to a collection first and then bound the collection), then you may not see the updates coming through. I'm not sure about explicitly but this is what in general my observation about gallery refresh.

Thank you
-Srikanth
BCBuizer 22,262 Super User 2025 Season 2 on 10 Mar 2022 at 21:13:07

Like (0)

Report

Re: Excel from onedrive as datasource - gallery shows old data after form submission

Another issue may have to do with the limitation that Excel queries are not delegable:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Power-Apps-Start-from-Data-Excel-Online-Not-Updating-App/td-p/853968
BCBuizer 22,262 Super User 2025 Season 2 on 10 Mar 2022 at 21:11:26

Like (0)

Report

Re: Excel from onedrive as datasource - gallery shows old data after form submission

Hi @Anonymous ,

Where is your Excel file stored?

According to the below older post, the Refresh() will not work for Excel files that are not stored in OneDrive:

https://powerusers.microsoft.com/t5/Building-Power-Apps/An-Excel-Table-is-not-refreshing-each-time-the-app-is-reloaded/td-p/491246
Community Power Pla... on 10 Mar 2022 at 13:21:21

Like (0)

Report

Re: Excel from onedrive as datasource - gallery shows old data after form submission

Refresh triggers getRows() API call which is already taking place when using basic gallery/editform combo.
I do have refresh button within gallery and doing another refresh/getRows gives old data as well (while online excel shows new data)! Frustrating...
BCBuizer 22,262 Super User 2025 Season 2 on 10 Mar 2022 at 13:10:17

Like (0)

Report

Re: Excel from onedrive as datasource - gallery shows old data after form submission

Hi @Anonymous,

You need to refresh your data source:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-refresh

You can include the function to run right after the patchRow: Refresh( DataSource )