Adding a check box to the default browse gallery to filter empty cells.

[kitpalmer]

I have a fairly simple list (Disposition Tracker) in SharePoint that I have created a power app to use for data entry & review of non-conforming manufacturing orders in a manufacturing plant. Operators submit the orders for review by the engineering department using one screen in the app, and the engineers use another screen to review and disposition each entry for "Ok", "Rework" or "Scrap". 

The default text search box in the browse gallery works fine to filter and sort (ascending/descending "DRDate") on the field "OrderNumber" as you type in data using this formula:

SortByColumns(Filter([@'Disposition Tracker'], StartsWith(OrderNumber, TextSearchBox1.Text)), "DRDate", If(SortDescending1, Descending, Ascending))

I would like to add an additional check box to filter out orders that have already been dispositioned (i.e., only show items if the field "Disposition" is blank).  A few questions:

1. How should the formula above in the DATA Items be modified?
2. For the check box, what should be in the OnCheck, OnUnchekc and OnSelect Action fields?
3. How do I configure the checkbox to automatically reset to unchecked for each use?

[eka24 · Accepted solution]

Try the following:

If(CheckBox1.Value=true,
SortByColumns(Filter([@'Disposition Tracker'], StartsWith(OrderNumber, TextSearchBox1.Text),Disposition<>Blank()), "DRDate", If(SortDescending1, Descending, Ascending)),

SortByColumns(Filter([@'Disposition Tracker'], StartsWith(OrderNumber, TextSearchBox1.Text)), "DRDate", If(SortDescending1, Descending, Ascending)))

You can try changing the <> to =

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[kitpalmer]

I tried both variations you offered, but am getting the error below:

[eka24]

Have you inserted Checkbox1 on your screen?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[kitpalmer]

Yes.

[eka24]

If(CheckBox1.Value,
SortByColumns(Filter([@'Disposition Tracker'], StartsWith(OrderNumber, TextSearchBox1.Text),Disposition<>""), "DRDate", If(SortDescending1, Descending, Ascending)),

SortByColumns(Filter([@'Disposition Tracker'], StartsWith(OrderNumber, TextSearchBox1.Text)), "DRDate", If(SortDescending1, Descending, Ascending)))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[eka24]

Just to check if the above formula worked for you after trying it.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[kitpalmer · Accepted solution]

Still did not work, but discovered that was because the "Disposition" field in the list was not text...it is a choice field. Modified the formula to:

If(CheckBox1.Value,
SortByColumns(Filter([@'Disposition Tracker'], StartsWith(OrderNumber, TextSearchBox1.Text),IsBlank(Disposition.Value)), "DRDate", If(SortDescending1, Descending, Ascending)),
SortByColumns(Filter([@'Disposition Tracker'], StartsWith(OrderNumber, TextSearchBox1.Text)), "DRDate", If(SortDescending1, Descending, Ascending)))

...works like a charm!

Thanks for your help!