You’re offline. This is a read only version of the page.
27
I posted in regards to this a few nights ago which was solved. However, I'd like to still be able to use the other search boxes without requiring something to be selected in the dropdown1 box.
For example, I want to be able to search using ModelInput.Text and SInput.Text without needed to select an option in dropdown1. Right now I have to select the dropdown for anything to appear.
Share
ReportSort(
If(
Dropdown1.Selected.Result=Blank(), 'IT Equipment List',
Filter(
'IT Equipment List',textInputSearch.Text in User,
ModelInput.Text in Model,
SInput.Text in 'Serial Number',
'Equipment Type'.Value = Dropdown1.Selected.Result
)
), User
)
If you are allowing blank values to be selected in your dropdown, then consider the following formula:
All responses (
Answers (
Sort(
Filter('IT Equipment List',
textInputSearch.Text in User,
ModelInput.Text in Model,
SInput.Text in 'Serial Number',
IsBlank(Dropdown1.Selected.Result) || 'Equipment Type'.Value = Dropdown1.Selected.Result
),
User
)This will incorporate the other selections and a blank dropdown choice.
Always avoid using If statements in your filters when possible (usually always!). This will save you the double (or more) work.
I hope this is helpful for you.
