cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dougb1
Level: Powered On

SortByColumns Not working correctly

Hi, I am retyping this all due to an error with the site so please forgive my briefness;

 

I am having trouble getting the SortByColumns function to work correctly. My objective is to;

-take a table from an excel file in one drive

-filter the table based on a selection from a dropdown (also linked to the same excel table, supposed to be showing distinct values from a column)

-sort those filtered results based on another column in the table (numerical value). 

 

For some reason, a lot of the selections have elements appearing out of order, and i cannot figure out why. 

I have tried using both sort and sortbycolumns, and get similar results with both. It also seems that if i delete the sort part of the function and reapply it, it will work for the current dropdown selection only. 

 

Something i noticed that may be related so i will include it in case: For some reason, the table is getting cut off, and not all records are displaying in the powerapp dropdowns or tables, specifically, entries past a certain point near the end of the table seem to not exist. I will not include a screenshot of that unless requested as i dont THINK its directly related.

 

Thanks in advance for any advice or guidance! 

-Doug

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: SortByColumns Not working correctly

You are definitely running into delegation issues. Tge easiest way out is for you to change the non-delegation limit in App settings to 2000 (which is the max) if your max count is 2000 or less.

I will provide a link to the documentation in a few minutes.

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

View solution in original post

7 REPLIES 7
dougb1
Level: Powered On

Re: SortByColumns Not working correctly

Replying with a small update related to the missing values: The last record in the table i can access is the 501st excel row (so 500 records plus headings), is this some sort of maximum limit for powerapp tables? 

Super User
Super User

Re: SortByColumns Not working correctly

How many records do you have? You might be running into delegation issues.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com
Super User
Super User

Re: SortByColumns Not working correctly

You are definitely running into delegation issues. Tge easiest way out is for you to change the non-delegation limit in App settings to 2000 (which is the max) if your max count is 2000 or less.

I will provide a link to the documentation in a few minutes.

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

View solution in original post

dougb1
Level: Powered On

Re: SortByColumns Not working correctly

Great, thank you for your incredibly prompt help! I will mark the answer with documentation as the solution when it is posted. This is definitely something i will need to read into more.

 

Super User
Super User

Re: SortByColumns Not working correctly

Here is a link that talks about delegable data sources and functions:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview#delegable-data-sour...

It also talks about how the limit can be changed from 500 to 2000.

Let me know if this helps.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com
dougb1
Level: Powered On

Re: SortByColumns Not working correctly

@PowerAddict 

You actually seem to have solved my issue with missing records, which has helped me solve the issue i originally posted about. 

 

It seems (now that i can view all of the results correctly) that it is sorting the RSS values as strings and not numerical values, (For instance, ordering {1, 20, 300, 4} as {4, 300, 20, 1}), so it seems i just need to interpret them as numerical values.

 

Thank you again for the help with my issues! 

Super User
Super User

Re: SortByColumns Not working correctly

Sounds great! Please mark the appropriate reply as the solution so it will be easy for others facing a similar issue to find it.

Thanks,
Hardit Bhatia
https://thepoweraddict.com

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,584)