Hi @Anonymous ,
Could you please share more details about the formula you typed within the Items property of the Dropdown1?
Do you want to add another Search bar filter into your existing Filter formula?
Further, do you want to add a "All" feature to the Dropdown box to let you choose "All" feature?
If you want to add another Search bar filter into your existing Filter formula, please consider modify your formula as below:
Filter(
CCB,
If(
IsBlank(Dropdown1.SelectedText.Value),
true,
'Functional Area' in Dropdown1.SelectedText.Value
),
If(
IsBlank(Filter.Text),
true,
StartsWith('Requirement Source',Filter.Text)
),
If( // Add formula here
IsBlank(Searchbar.Text),
true,
StartsWith(Name, Searchbar.Text)
)
)
If you want to add a "All" feature into your Dropdown1, I think you could consider add a ComboBox control in your app to list available options rather than Dropdown control (that you added). Then type some formula within the Items property of the ComboBox as that in your original Dropdown control. Set the SelectMultiple property of the ComboBox to false. Then the default value within the ComboBox would be blank, you could select or deselect option from the ComboBox.
Then you need to modify above Filter formula as below:
Filter(
CCB,
If(
IsBlank(ComboBox1.Selected.Value), // Modify formula here
true,
'Functional Area' in ComboBox1.Selected.Value
),
If(
IsBlank(Filter.Text),
true,
StartsWith('Requirement Source',Filter.Text)
),
If( // Add formula here
IsBlank(Searchbar.Text),
true,
StartsWith(Name, Searchbar.Text)
)
)
Within above Filter formula, it would check if the ComboBox selection is Blank, if true, it would not do any Filter operation against your 'Functional Area' column (in other words, it would retrieve all available 'Functional Area' value records), if not, it would filter your 'Functional Area' column value based on the selected ComboBox option.
Please consider take a try with above solution, hope it helps in your scenario.
Best regards,
