How to filter Is Null from the collection

(0) Share

Report

Posted on by MIA27

I am using power app Teams

I am using the below collection on Gallery Select Item Property. Its working fine.

Want to modify the code as below :

If Service Date Is Blank, then should not populate that row.

Now it populating 5 rows even if date is not there in the row.

Therefore, I want to filter based on Service Date, But confused how to do

ClearCollect(
 colServiceDates,
{ServiceDate: ThisItem.ExtraSvc1Field1, ServiceSMR: ThisItem.ExtraSvc1Field2},
{ServiceDate: ThisItem.ExtraSvc2Field1, ServiceSMR: ThisItem.ExtraSvc2Field2},
{ServiceDate: ThisItem.ExtraSvc3Field1, ServiceSMR: ThisItem.ExtraSvc3Field2},
{ServiceDate: ThisItem.ExtraSvc4Field1, ServiceSMR: ThisItem.ExtraSvc4Field2},
{ServiceDate: ThisItem.ExtraSvc5Field1, ServiceSMR: ThisItem.ExtraSvc5Field2},
);<div> <div> </div></div>

Categories:

General Questions

All responses (3)

Answers (2)

Verified answer

Ethan_009 4,838 Super User 2025 Season 1 on at

Like (1)

Report

Re: How to filter Is Null from the collection

Hi @MIA27 ,

You don't have to, If you are adding the values in the collection and later want to exclude blank values. You can try the code I gave.

But if you don't even want to introduce into your collection then you can handle using If(!IsBlank(TextBox.Text), //add in collection) kinda stuff.

Its all up to you how you manage it.
MIA27 on at

Like (0)

Report

Re: How to filter Is Null from the collection

You mean I need to add another collection under it, and now the gallery to be based on the new collection name.
Pls. confirm so that I can do the changes in the app.
Verified answer

Ethan_009 4,838 Super User 2025 Season 1 on at

Like (1)

Report
Re: How to filter Is Null from the collection

Hi @MIA27 ,

Is this what you are trying to filter the collection?

Filter( colServiceDates, ServiceDate <> Blank() )

Hope this helps