Power Platform Community Forum Thread Details

Hello,

Below is one of the formula I received for my last post. Which is working as expected.

Now I'm looking to achieve my second requirement. Below is the formula that I've applied to one of my button called "Receipt Date":

CountIf('SPListName', IsBlank('Receipt Date'))

It counts Blanks from the Receipt Date column. I also have more 3 buttons with different column name.

So my requirement is: when I click "Receipt Date" button, the Gallery should filter all the Blank ones referring "Receipt Date column"

Similarly when I click "Invoice No." or "Invoice Date" or "License No." button it should filter all the Blank ones

Appreciate if someone could assist.

Thanks,
Prem

Categories:

Building Power Apps

Hi,

You can add this code on the OnSelect property of the button to make it have a toggle-like function:

If(
    locFilterBlankReceiptDate,
    UpdateContext({locFilterBlankReceiptDate: false}),
    UpdateContext({locFilterBlankReceiptDate: true})
);

On the gallery, apply this to filter blank values for the corresponding column:

Filter(
    DataSource,
    Or(
        !locFilterBlankReceiptDate,
        ReceiptDate = Blank()
    )
)

With this code, it looks if the local variable locFilterBlankReceiptDate is true then filter those with blank values, if false then it shows all the items.

You can do the same to other columns with their own buttons like:

Filter(
    DataSource,
    Or(
        !locFilterBlankReceiptDate,
        ReceiptDate = Blank()
    ),
    Or(
        !locFilterBlankInvoiceNo,
        InvoiceNo = Blank()
    )
)