Filtering a Browse Gallery with IsBlank and Text Filter

[voglejm]

Hello Everyone,

My organization has asked me to create a basic app that will allow employees to volunteer to help with activities throughout the company during the COVID situation.

I have a list of all available assignments and I would like the browse gallery to only show items with no support resource assigned. I've been able to successfully accomplish this utilizing the following statement. 

SortByColumns(Filter(Support_Needs_List,IsBlank(Support_Resource)),"StartDate",Descending)

As you can see from the image above I would also like to include a FilterTextBox to allow users to filter this list down by Facility; however, I'm not having much success with this. Below is the statement I've tried, when I insert this code on ITEM the gallery doesn't show anything. Any help or insight would be appreciated.

If('FilterTextBox'.Text="",Filter('Support_Needs_List',IsBlank(Support_Resource),Filter(Filter('Support_Needs_List',IsBlank(Support_Resource),'FilterTextBox'.Text in 'Facility'))))

[mdevaney · Accepted solution]

@voglejm 

From what I can tell the user is supposed to type a facility name into the text box to filter the gallery.

Here is the code I came up with:

SortByColumns(
    Filter(
        Support_Needs_List,
        IsBlank(Support_Resource),
        IsBlank(FilterTextBox.Text) Or FilterTextBox.Text in Facility
    ),
    "StartDate",
    Descending
)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[voglejm · Accepted solution]

@mdevaney  - Unfortunately I get the same results as I was experiencing before. The browse gallery shows nothing. I should be seeing two records in the browse gallery. The statement utilized is below.

SortByColumns(Filter(Support_Needs_List, IsBlank(Support_Resource), IsBlank(FilterTextBox.Text) Or FilterTextBox.Text in Facility), "StartDate", Descending)

[mdevaney]

@voglejm 
Two questions:

#1  What type of column is Facility in SharePoint?
#2  Does the facility criteria work on its own?

SortByColumns(Filter(Support_Needs_List, FilterTextBox.Text in Facility), "StartDate", Descending)

 ---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[voglejm]

@mdevaney You were right. I wasn't using the correct column. The facility column is a choice field, so I created a calculated text field to allow this functionality. Thanks for all the help and the quick response.