web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps SortbyColumns - Priori...

Power Apps

Unanswered

SortbyColumns - Prioritize Letter then Numbers and allow Empty Selection

(0) Share

Report

Report

Posted on by ComicSansrival

166

Hi,

I would like to ask if is there a way to use SortByColumns wherein it prioritizes the sorting of letters first then numbers?

For example, I have the following column data:

256

123

88

1

102

All

Then dropdown in PowerApps should put "All" on top of the list then followed by numbers in Ascending order.

Also, is there a way to enable blank selection and it should be on the top of the option?

For example, same data above but the dropdown should be showing the following in order: <Blank selection>, "All", then numbers in ascending order.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

QuentinDURIEZ 577 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

You can achieve this by making a two-step collect like in this example :

ClearCollect(_colDemo ,Blank(), "All") ; Collect(_colDemo, SortByColumns( ["256", "1" , "88"] , "Value" ))

First, ClearCollect with the Blank() and "All", then collect sorted other elements

Finally, use you collection as your DropDown Items

Regards,

Was this reply helpful? Yes No
ComicSansrival 166 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I tried replacing my old formula, but I am having an issue with the outcome.

Here is the formula:

SortByColumns(Filter('Log - Lookup DB', Code = DataCardValue33.Selected.Result),"field_2",SortOrder.Ascending)

The above formula worked but the "All" and blank option is at the bottom.

To give you an idea on the above formula, I use filter since there's a wide range of code but when the connected column has a value then the option for the code will shrink and shows only the relevant codes and option to use "All".

Is there a way that you can share here the formula for the above formula?

Was this reply helpful? Yes No

Join the conversation