Drop Down Order - items from one column, sort from another

(1) Share

Report

Posted on by CCW

I have a data verse table with 4 columns, I need my drop down to show a list from the first column, using the order stored in the 2nd column.

Column 2 can be ABC or 123 it doesn't really matter, but I need the items in column 1 to remain in THAT order. I cannot figure it out. hopefully its really easy and I'm just being stupid!

Column 1 Header	Column 2 Header	Column 3 Header	Column 4 Header
Zig Zags	A
Fruit	B
Apples	C

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WiZey 3,023 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hello @CCW ,

There are no stupid questions, only answers so obvious we don't notice them.

Have you tried "Sort()" ?

Sort( source, Column2, Ascending ).Column1

Was this reply helpful? Yes No
CCW 32 on at

Like (0)

Report
Copy link

Link copied!

hero! thanks

Was this reply helpful? Yes No