web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Remove Blank from Drop...

Power Apps

Unanswered

Remove Blank from Dropdown

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

My piece of code:

Sort(
Distinct(
Members,
Region
),
Value
)

I want to remove the first blank value from the dropdown option. What to do?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
You can filter the result of the Distinct call to remove any empty results:

Sort( Filter( Distinct(Members, Region), Not IsEmpty(Value) ) Value )

Hope this helps!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

No change, same response

Was this reply helpful? Yes No
CarlosFigueira Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Apologies, used a wrong function in the example above. It should be IsBlank(Value), not IsEmpty(Value):

Sort( Filter( Distinct(Members, Region), Not IsBlank(Value) ) Value )

Hope this one helps now 🙂

Was this reply helpful? Yes No

Join the conversation