Filter gallery with text input

[pinball2]

Hi, 

I have to filter gallery with text input, but I want to make it filtered possible with only few words. 

I mean, for now the gallery gets filtered when the user have to put the whole same text in 'Request ID'. 

However, I want to make it possible for users to filter the gallery with only some part of the text, for example 11102. 

I'm filtering the gallery like this: 

SortByColumns(
Filter(
'LIST',
(IsBlank(drp_status_2.Selected) || Status_ = drp_status_2.Selected.Value)
&& (IsBlank(txtRequestIDFilter.Text) || Title = txtRequestIDFilter.Text)
&& Requestor.Email=User().Email
),
"Title",
SortOrder.Descending
)

[Amik]

@pinball2 , use non-delegable search to filter by a partial match. E.g.:

SortByColumns(
    Search(
        Filter(
            'LIST',
            Len(drp_status_2.Selected.Value) = 0 || Status_ = drp_status_2.Selected.Value,
            Requestor.Email = User().Email
        ),
        txtRequestIDFilter.Text,
        "Title"
    ),
    "Title",
    SortOrder.Descending
)

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

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

[pinball2]

@Amik 

Hi, thank you so much! 

Could I ask you a help for having the same partial text search enable for this formula too?

I'm not quite familiar with powerapps and new to this, so I'm really bad at syntaxes etc.. 

I would really appreciate it if you could help me with this case too. 

I want to have partial text search enable for txtTitle_3 and txtJobNo_1: 

SortByColumns(
Filter(
'Parent POCO Inventory List',
(IsBlank(drp_status_3.Selected) || Status_ = drp_status_3.Selected.Value) && (IsBlank(cmb_requestor_3.Selected) || Requestor.DisplayName = cmb_requestor_3.Selected.DisplayName) && (IsBlank(drp_CCMgr_1.SelectedText) || 'Cost Centre Manager Approval' = drp_CCMgr_1.SelectedText.Value) && (IsBlank(drp_CostCenter_1.SelectedText) || 'Cost Center'.Value = drp_CostCenter_1.SelectedText.Value) && (IsBlank(txtJobNo_1.Text) || 'Job Number' = txtJobNo_1.Text) && (IsBlank(txtTitle_3.Text) || Title = txtTitle_3.Text)
),
"Title",
SortOrder.Descending
);

[v-hanytian-msft]

Hi @pinball2 ,

Please try this:

We Suggest use "in" replace "=".

Filter(
'Parent POCO Inventory List',
(IsBlank(drp_status_3.Selected) || Status_ = drp_status_3.Selected.Value) && (IsBlank(cmb_requestor_3.Selected) || Requestor.DisplayName = cmb_requestor_3.Selected.DisplayName) && (IsBlank(drp_CCMgr_1.SelectedText) || 'Cost Centre Manager Approval' = drp_CCMgr_1.SelectedText.Value) && (IsBlank(drp_CostCenter_1.SelectedText) || 'Cost Center'.Value = drp_CostCenter_1.SelectedText.Value) && (IsBlank(txtJobNo_1.Text) ||  txtJobNo_1.Text in 'Job Number' ) && (IsBlank(txtTitle_3.Text) ||  txtTitle_3.Text in Title )
)

Hope this will help you,

Best Regards,
Tina

[Amik]

Hi @pinball2 - please accept my response as the solution if it has answered the original question. Ideally, you should raise new questions as new posts rather than adding them to existing ones.

I will provide a suggestion if the suggestion from @v-hanytian-msft does not work for you.