Answered

Un-expected results using Sort function

(0) Share

Report

Posted on by Elke

Hi All,

When working on my current PowerApp I've encountered some issue's with the Sort and SortByColumns function and I was hoping to find some feedback to fix this.

I have a SharePoint list as a source for my Gallery, when sorting by any autogenerated column (ID,modified,created) I get results from the Sort function, however, when trying the same with my "added_by" column (single line of text), I get 0 results.

The formula's in question:

Sort(expenses2,Modified,SortOrder.Ascending) - Works as expected

Sort(expenses2,added_by,SortOrder.Ascending) - 0 results

Does anyone know how to fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Chris-D 1,246 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Elke, this is confusing because no matter what the result of the sort, you should still get a complete list of 'expenses2'.

Can you add some screenshots please to demonstrate?

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Elke

I just recreated your scenario and everything works fine:

The Sort doesn't effect the data.
The Sort function sorts a table based on a formula. The formula is evaluated for each record of the table, and the results are used to sort the table. The formula must result in a number, a string, or a Boolean value; it can't result in a table or a record.

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
tareqrosul 164 on at

Like
a
(0)

Report
Copy link

Link copied!
This is working as it should be
added_by column has the values Piet and Jan
if it is sorted as Ascending order the J should come first the P
add another label on the gallery and
ThisItem.added_by
you should be able to see what's happening
If my response was beneficial to you, feel free to leave a 👍 symbol. If it effectively resolved your query, please signify with a 👍 and mark it as the Solution, assisting other community members in locating this helpful information more readily.

Was this reply helpful? Yes No
Elke 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Thats weird when putting 2 galleries side by side with just these formulas, no errors either. The column is of a string type too.
The only reason I could think of is delegation since the datasource is over 10k items, however I think Sort should be delegatable.

Was this reply helpful? Yes No
Elke 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey I;ve just done this, however the second gallery returns no results:

Was this reply helpful? Yes No
Elke 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Slight update, I've just tried using the sort on a collection of the same data and it works as expected.
Could this be an issue with how my sharepoint list is configured?

Was this reply helpful? Yes No
Verified answer

timl 37,212 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Elke

What I'd suggest is to create a SharePoint index on your added_by column. Hopefully, you'll receive more accurate results after you do that.

https://support.microsoft.com/en-gb/office/add-an-index-to-a-list-or-library-column-f3f00554-b7dc-44d1-a2ed-d477eac463b0

Was this reply helpful? Yes No