Display Items in Gallery

[mssa12345]

I have a list named Office Documents and within that list I have a Status column which is Single of text, Position column which is choice column and office which is also a choice column .

In the gallery I have displayed everything that is created by current logged in user only  ( 100s of them ), but I want to filter that by one dropdown selected value (offices) and a search inputttext box , this inputtext text should only search position and status column. 

SortByColumns(
    If(
        Dropdown2.Selected.Value = "All Offices" , Filter('Office Documents', 'Created By'.DisplayName = varCurrentUser ),
        Dropdown2.Selected.Value <> "All Offices", Filter('Office Documents', Office.Value = Dropdown2.Selected.Value)
        Filter('Office Documents',  TextInput4.Text in 'Position Title'.Value || TextInput4.Text in Status)
         
    ),
    varSortColumn,
    varSortDirection 
)

This works for the dropdown, but does not work for the search Textinput box.

Please help.

[JohnM86 · Accepted solution]

There are a couple of issues with the formula you provided. One issue is that there is a missing comma between the filter conditions for the Dropdown2.Selected.Value <> "All Offices" and TextInput4.Text in 'Position Title'.Value. Another issue is that the filter condition for Status should use the dot notation to access the value of the Status column.

Here is a modified formula that should work for your scenario:

SortByColumns( If( Dropdown2.Selected.Value = "All Offices", Filter('Office Documents', 'Created By'.DisplayName = varCurrentUser && (IsBlank(TextInput4.Text) || TextInput4.Text in 'Position Title'.Value || TextInput4.Text in Status.Value)), Dropdown2.Selected.Value <> "All Offices", Filter('Office Documents', Office.Value = Dropdown2.Selected.Value && (IsBlank(TextInput4.Text) || TextInput4.Text in 'Position Title'.Value || TextInput4.Text in Status.Value)) ), varSortColumn, varSortDirection )

This formula filters the 'Office Documents' list based on the selected value of the Dropdown2 and the text entered in the TextInput4. It checks if the TextInput4 text is present in either the 'Position Title' or 'Status' column values. The IsBlank function is used to check if the TextInput4 is empty, so that the filter doesn't apply when the TextInput4 is empty. Finally, the SortByColumns function sorts the filtered records based on the specified column and direction.