Announcements
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?
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 )
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...
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
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
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
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.
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
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 😞
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 493 Most Valuable Professional
11manish 479
Haque 328
