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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,507)