cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jonfarmer
Regular Visitor

Powerapps Excel Data Source, Interface will not update when sort applied

I have a PowerApp that is connected to Excel Online as it's data source. I have a gallery that is populated from a column in a table. If there is no sort applied to the table data then the interface updates fine when a change happens to the data. However if I apply a sort to the gallery data then no updates are made to the interface when the data changes. 

 

On the iOS app even closing the app and reopening doesn't let the data refresh. Anyone know what is going on here?

 

Kind Regards

 

Jon

2 REPLIES 2
FarrellDrafting
Advocate II
Advocate II

Why not just sort the data in the interface instead of on your backend? you could use SortbyColumns() in powerapps and get what you need. you could even setup a similar sort system with buttons if it needs to behave like excel.

Apologies, perhaps my original post didn't make it clear. I am sorting in the interface and that is where the behaviour is being exhibited.

 

Many thanks

 

Jon

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (2,034)