web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Removing Blank values ...

Power Apps

Answered

Removing Blank values in a dropdown

(0) Share

Report

Report

Posted on by mmbr1606

14,605 Super User 2025 Season 2

Hey everybody

I have a sharepoint list with a few columns:

I have a form that is connected to another list where i use this in my Items property:

Distinct(
 Filter(
 MyCollection,
 Value(currentEditRole) = 1 ||
 HeadofEntityEmail = User().Email
 ),
 LegalEntity
)

There are also some entries where the Legal Entity is empty/blank.

Can i somehow exclude the blank option from my dropdown choices?

In this screenshot you see, that the second option is the blank value i want to remove:

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report
Try adding this to the filter query:

!IsBlank(YOURVALUEHERE)

Was this reply helpful? Yes No
Verified answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (1)

Report
Hi @mmbr1606

Adjust your filter to only get records where LegalEntity is not Blank:
Distinct( Filter( MyCollection, (Value(currentEditRole) = 1 || HeadofEntityEmail = User().Email) && LegalEntity <> Blank() ), LegalEntity )
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report

thanks @SpongYe

that worked perfectly fine.

Was this reply helpful? Yes No
SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report
Hi @mmbr1606

Then you can use this:
Distinct( Filter( MyCollection, LegalEntity <> Blank() ), LegalEntity )

Was this reply helpful? Yes No

Join the conversation