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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Ethan_009 4,838 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MIA27 ,

Is this what you are trying to filter the collection?

Filter( colServiceDates, ServiceDate <> Blank() )

Hope this helps

Was this reply helpful? Yes No
MIA27 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Ethan_009 4,838 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No