Sort dropwdown that concatenates to columns

(0) Share

Report

Posted on by Community Power Pla...

Hi,

Struggling to figure out how to sort a dropdown I have in my app.
The dropdown is simply a
concatenate that combines to columns from a collection. This by itself work fine!
However, trying to sort this by the first column, but can't wrap my head around this.

Probably an easy solution (I hope), but just can't see how..

My Items looks like this:

Concatenate(yt_project_coll.project," ", yt_prosjekter_coll.name_project)

What I imagine it looking like would be something like this:

Sort(
 yt_project_coll,
 Concatenate(yt_prosjekter_coll.project," ", yt_prosjekter_coll.name_project),
 project
)

Thanks a lot!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Community Power Pla... on at

Like (0)

Report
Solved my own question with a bit of work..

Sort( Distinct( yt_project_coll, Concatenate(project," ", name_project) ), Result, Ascending )

Was this reply helpful? Yes No