Sort dropwdown that concatenates to columns

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

All responses (1)

Answers (1)

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Solved my own question with a bit of work..

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