Answered

Data Table Filtering with search field and Dropdown

(0) Share

Report

Posted on by Chrisguff12

229

I have a data field that I want to filter using a search Textbox and a dropdown. I have been testing a lot of different formulas but I cant get it to work right. I have these three formals that work independently but I need to combine them.

Sort('Expense App List New',RequestedBy,Ascending)

Filter('Expense App List New',StartsWith(RequestedBy,Tech_Name_Search_TextInput1.Text))

Filter('Expense App List New',ItemStatus = Filter_Item_Status_Dropdown1.Selected.Value)

Categories:

General Questions

I have the same question (0)

All responses (6)

Answers (2)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Re: Data Table Filtering with search field and Dropdown

@Chrisguff12

Sort( Filter( 'Expense App List New',IsBlank(Tech_Name_Search_TextInput1.Text)|| StartsWith(RequestedBy,Tech_Name_Search_TextInput1.Text) && ItemStatus = Filter_Item_Status_Dropdown1.Selected.Value ), RequestedBy,Ascending )

If you wanted to see the entire datasource you could add a blank value to the status dropdown and filter the table this way.

Sort( Filter( 'Expense App List New',IsBlank(Tech_Name_Search_TextInput1.Text)|| StartsWith(RequestedBy,Tech_Name_Search_TextInput1.Text) && IsBlank(Filter_Item_Status_Dropdown1.Selected.Value|| ItemStatus = Filter_Item_Status_Dropdown1.Selected.Value ), RequestedBy,Ascending )

Was this reply helpful? Yes No
Chrisguff12 229 on at

Like (0)

Report

Re: Data Table Filtering with search field and Dropdown

@Drrickryp

Hey tried your formula. I don't get any errors but when I start typing in the Search box the records disappear and none of the results show up.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Re: Data Table Filtering with search field and Dropdown

@Chrisguff12
I think there may be a problem with the starts with. Could you check if this is OK? It will give a delegation warning but you can ignore it for now. I'm troubleshooting here.

Sort( Filter( 'Expense App List New',IsBlank(Tech_Name_Search_TextInput1.Text)|| Tech_Name_Search_TextInput1.Text in RequestedBy, IsBlank(Filter_Item_Status_Dropdown1.Selected.Value|| ItemStatus = Filter_Item_Status_Dropdown1.Selected.Value ), RequestedBy,Ascending )

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Re: Data Table Filtering with search field and Dropdown

@Chrisguff12

I think I found the problem there shouldn't be an && it should be a comma

Sort( Filter( 'Expense App List New',IsBlank(Tech_Name_Search_TextInput1.Text)|| StartsWith(RequestedBy,Tech_Name_Search_TextInput1.Text), IsBlank(Filter_Item_Status_Dropdown1.Selected.Value|| ItemStatus = Filter_Item_Status_Dropdown1.Selected.Value ),

a typo on my part.

Was this reply helpful? Yes No
Verified answer

Chrisguff12 229 on at

Like (0)

Report
Re: Data Table Filtering with search field and Dropdown

@Drrickryp

This work beautifully, but you had one typo. There was a missing ) after the the first dropdown string. Can you edit it then I will mark your post as the solution?

I was having an issue until I realized I needed set "AllowEmptySelection" for the dropdown.

Sort( Filter( 'Expense App List New',IsBlank(Tech_Name_Search_TextInput1.Text)|| StartsWith(RequestedBy,Tech_Name_Search_TextInput1.Text), IsBlank(Filter_Item_Status_Dropdown1.Selected.Value)|| ItemStatus = Filter_Item_Status_Dropdown1.Selected.Value ), RequestedBy,Ascending )

Thanks for you help again.

Was this reply helpful? Yes No
Chrisguff12 229 on at

Like (0)

Report

Re: Data Table Filtering with search field and Dropdown

For anyone looking to filter out certain values I continued working on this formula on this thread.

https://powerusers.microsoft.com/t5/Building-Power-Apps/Filtering-out-records-with-certain-values/td-p/875485

Was this reply helpful? Yes No