On Button Click Filter Blank Dates in Gallery

(0) Share

Report

Posted on by Prem4253

652

Hi,

I'm using below code in OnSelect property applied to a button

CountIf(YourSharePointList, IsBlank(ReceiptDate))

For for the Items property with the Gallery I'm using below code, but this is not filtering the Gallery

SortByColumns(Search('YourSharePointList', TextInput1.Text,Column1 , 'Column 2', 'Column 3'),"Modified", SortOrder.Descending)

I tried to add ReceiptDate in the above code, but this does not filters the Gallery. TextInput1.Text is used to search within the Gallery.

Getting below error: Wrong column type. Expects text type

Please advise. Thanks!

Prem

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
hey

can u try this:

SortByColumns( Filter( 'YourSharePointList', IsBlank(ReceiptDate) && (TextInput1.Text = "" || Search(Title, TextInput1.Text) > 0) ), "Modified", SortOrder.Descending )

if my answer helped please mark as verified

cheers

Was this reply helpful? Yes No
Prem4253 652 on at

Like (0)

Report

@mmbr1606

I'm getting below error at Search line:

Invalid number of arguments: received 2, expected 3 or more

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
hey

can u try this modification:

SortByColumns( Filter( 'YourSharePointList', IsBlank(ReceiptDate) && ( TextInput1.Text = "" || StartsWith(Column1, TextInput1.Text) || StartsWith(Column2, TextInput1.Text) || StartsWith(Column3, TextInput1.Text) ) ), "Modified", SortOrder.Descending )

Was this reply helpful? Yes No
Prem4253 652 on at

Like (0)

Report
@mmbr1606

Yes, this did the trick to only show fields within the gallery which has blank dates. I added a ReceiptDate button in which I can also see the count of blank dates.

I also have a Shipping Date column, for which I added a button and I'm also able to see the count. And below is the logic I added to OnSelect property (where Receipt date is not blank but Shipping date is blank)

CountIf(YourSharePointList, !IsBlank(ReceiptDate) && IsBlank(ShippingDate))

But when I click Shipping Date button, the gallery does not filters

Sorry I was not too clear in my initial request. Please advise

Was this reply helpful? Yes No