Items Combobox ForAll function dont show the empty values

(0) Share

Report

Posted on by NidjoJohnny22

288

Hello all,

I'm not sure about how to implement this logic into the ComboBox Items property:

basically I'm catching all the items from a column in list, but this list also contains other data and that data(records), has some info that leave the ResponsibleBuyer column empty, and I'm only looking for ResponsibleBuyer column for whole LIST.

I'm wondering if there is a way to implement an "if" conditional inside the ForAll() function and if thisrecord.ResponsibleBuyer isBlank(), then "continue" or "skip" or don't show that as an "items" option.

does anybody have experience with this case or similar?

thank you in advance! I will google in the meantime to try and find solution. (I'm in a rush to implement this feature)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @NidjoJohnny22,

If the list is not large (< 500 records or <2000 records depending on settings) you could use this non-delegable option:

Filter( L_PurchasingRequest_Reference, ResponsibleBuyer <> Blank() ).ResponsibleBuyer

I hope this helps!

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @NidjoJohnny22 ,

It sounds like you want to filter out empty items for which you can use the Filter function:

Filter( L_PurchasingRequest_Reference, !IsBlank(ResponsibleBuyer) ).ResponsibleBuyer

Was this reply helpful? Yes No
NidjoJohnny22 288 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi guys, I've got a formula that suits me, but I still wonder how to "skip" or "continue" to next item when "if" is false.

My solution:
Filter(ForAll(L_ListName.ResponsibleBuyer, ThisRecord.ResponsibleBuyer), IsBlank(ThisRecord.DisplayName)=false)

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @NidjoJohnny22 ,

You don't need to use a loop to filter out blank values, so you can lose the ForAll and just use a Filter function as in the above posts.

Was this reply helpful? Yes No
NidjoJohnny22 288 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you kind people!! this has helped a lot 🙂

Was this reply helpful? Yes No