Sort specific order of dropdown

(0) Share

Report

Posted on by JimmyW

2,567

I have a dropdown that uses.

Distinct(CategoryData, 'Main category')

Now i want to put in a default value that is not in the list and that works fines, but i want the default value to always be on top even if i sort in descending or ascending.

I have tried creating a collection adding the value in a collection but i don't know how to get my default value to stay always on top.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

cds 1,001 on at

Like
a
(1)

Report
Copy link

Link copied!

dropdown property: AllowEmptySelection

Was this reply helpful? Yes No
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!

@cds Thank you but i dont want it to be empty i want the first selection to always say for example All, but currently all falls on place 3

Was this reply helpful? Yes No
Verified answer

cds 1,001 on at

Like
a
(1)

Report
Copy link

Link copied!

Collect(TheseOptions, Distinct(Filter(CategoryData, 'Main category' = "All")).'Main category')
Collect(TheseOptions, Distinct(Filter(CategoryData, 'Main category' <> "All")).'Main category'

Was this reply helpful? Yes No