Filter gallery with text input

(0) Share

Report

Posted on by 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.

Screenshot 2023-07-30 at 8.51.47 PM.png Screenshot 2023-07-30 at 8.52.00 PM.png

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
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
pinball2 80 on at

Like (0)

Report
Copy link

Link copied!

@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
);

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No