Answered

Big problems with simple sorting of a gallery

(0) Share

Report

Posted on by DoctorJaegerX42

Hi there

I already opened up another topic about the nearly same problem. But to be honest, I again have problems with that sorting-function of my automatically created on basis of a sharepoint list.

I want to sort the gallery by the Company Name ("Firma") on the left side. In the sharepoint-list, the name of the column is also "Firma". But I cant change it properly in the formula of the gallery. Every time I do this, there are some errors as if it doesn't recognize that column name.

Any ideas? It should be so easy yet I don't know how to solve this.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Ethan_009 4,838 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @DoctorJaegerX42 ,

Does this code help?
Sort( Filter( Lieferantenliste; StartsWith( Firma; TextSearchBox1.Text ) ); Firma; If( SortDescending1; SortOrder.Descending; SortOrder.Ascending ) )

Do check the semi-colons as I'm used to commas ','

Was this reply helpful? Yes No
DoctorJaegerX42 95 on at

Like (0)

Report
Copy link

Link copied!

Oh wow. That helped!!!! Perfect 🙂 Where was my mistake?

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @DoctorJaegerX42 ,

I used Sort instead of SortByColumns
Well it pretty much works the same, just that Sort accepts columnName without quotes and SortByColumns uses quotes.
I thought that might be the issue, so I modified the code accordingly

Documentation Link

Was this reply helpful? Yes No