combine filter text box with combo drop down

(0) Share

Report

Posted on by kouliscon

247

hello all,

i have a text box and i am using the below formula to filter data at a DataTable:

SortByColumns(Filter(Helpdesk,( StartsWith(Requestor.DisplayName , FilterBox.Text)) Or (StartsWith(Subject , FilterBox.Text))),"Request_x0020_Date",Descending)

i would like also to add at the formula a combobox, any ideas of how the formula should be modified?

thank you in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (1)

BCBuizer 22,535 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Is this an addition on top of the current functionality? Also, what is the name of the column you want to filter and what type is it?

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report
Copy link

Link copied!

yes its an addition to the current functionality and the name of the column is "Status"

thanks

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @kouliscon,

Based on the issue that you mentioned, do you want to filter the DataTable based on the Combo Box?

Could you please share a bit more about the scenario, is this Status column a Choice column or Text?

If it is a Choice, try as below:

SortByColumns( Filter(Helpdesk,( StartsWith(Requestor.DisplayName , FilterBox.Text)) Or (StartsWith(Subject , FilterBox.Text)) Or Status.Value=ComboBox1.Selected.Value ), "Request_x0020_Date",Descending )

If it is a Text, try as below:

SortByColumns( Filter(Helpdesk,( StartsWith(Requestor.DisplayName , FilterBox.Text)) Or (StartsWith(Subject , FilterBox.Text)) Or Status=ComboBox1.Selected.Satus ), "Request_x0020_Date",Descending )

Regards,

Qi

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report
Copy link

Link copied!

thank @v-qiaqi-msft the Choice option works great with only one thing that the combo box (dropdown) will not return any values only if i will input something at the text filter, even if i press the space on the text filter.

any recommendations?

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report
Copy link

Link copied!

any update on this @v-qiaqi-msft
thank you

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @kouliscon,

Sorry for the late reply. Have you solved your problem?

Do you mean that the Combo Box display nothing when there is no search text?

I want to confirm with you that if you want to filter the records using the StartsWith() based on the Combo Box?

If so, you should use the And(&&) operator rather than the Or(||),please modify as below:

SortByColumns( Filter(Helpdesk,( StartsWith(Requestor.DisplayName , FilterBox.Text) Or StartsWith(Subject , FilterBox.Text)) And Status.Value=ComboBox1.Selected.Value ), "Request_x0020_Date",Descending )

You should make the two StartsWith() as a whole and the Combo Box selected as another part, this formula will display the records based on the Combo Box selected even you have nothing input within the search box.

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report
Copy link

Link copied!

hello @v-qiaqi-msft and thanks for the reply.

what i would like is when i input data at the text filter to then filter and return data.
If the text filter is empty then if i select the combobox to return data.

either way i would like to have the possibility to input to one of the two (filterbox) or (Combobox) and to return data or to input to both and to return values.

let me know if that is clear.

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report
Copy link

Link copied!

hello @v-qiaqi-msft do you have any update on my question above?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @kouliscon,

Sorry for the late reply due to my weekend off.

Have you tried my solution on your side?

To achieve the need you mentioned "

what i would like is when i input data at the text filter to then filter and return data.

If the text filter is empty then if i select the combobox to return data.", if you only want to filter based on the Combo Box once the text filter is empty, try as below:

If(IsEmpty(SortByColumns(Filter(Helpdesk,( StartsWith(Requestor.DisplayName , FilterBox.Text)) Or (StartsWith(Subject , FilterBox.Text))),"Request_x0020_Date",Descending)), Sort(Filter(Helpdesk,Status.Value=ComboBox1.Selected.Value),ID), SortByColumns(Filter(Helpdesk,( StartsWith(Requestor.DisplayName , FilterBox.Text)) Or (StartsWith(Subject , FilterBox.Text))),"Request_x0020_Date",Descending) )

Was this reply helpful? Yes No
kouliscon 247 on at

Like (0)

Report
Copy link

Link copied!
hello @v-qiaqi-msft and thank you for your reply,

maybe i am not very clear,

from the picture above what i want is:

when i input data at 1 to then return data
when i select from 2 to then return data
if i input data at 1 which will return data and i select something from 2 to then return different data

tried your formula and i didnt work. i have to press "space" at 1 in order for 2 to work after i selected something.

hope is clear

Was this reply helpful? Yes No