Dropdown does not work unless I type and backspace something in the Search Box

[Anonymous]

I'm trying to building a Data Glossary and I put on the Gallery Item the following: 

Sort(Search(
If( 
Dropdown_ReportName.Selected.Result="-",Table3,
Dropdown_ReportName.Selected.Result<> "-", Filter(Table3,'ReportName '=Dropdown_ReportName.Selected.Result)
),SearchTerm.Text,"Terminology"

),Terminology,Ascending
)

Note:

*My table name is Table3

*My columns names are: Report Name, Terminology and Definition

This is what I'm trying to do:

I want to search  as a whole, and within the results when a Report is selected from the dropdown. 

@RandyHayes @WarrenBelz  Please help!  

[RandyHayes]

@Anonymous 

Let's start by cleaning up the formula you have.

Change to this:

SortByColumns(
    Search(
        Filter(Table3, 
            (Dropdown_ReportName.Selected.Result="-" || 'ReportName '=Dropdown_ReportName.Selected.Result)
        ),
        SearchTerm.Text, "Terminology"
    ),
    "Terminology"
)

Then let me know if this changes the situation or not.  If not, provide a little more details on the datasource you have and they type of columns.

I hope this is helpful for you.

[Anonymous]

Thank you Randy, I was able to search within the results when a report is selected 🙂 .

However, I could not search the whole table by typing any terminology on the search box ,when the dropdown selection is blank. 

I have tried everything, it seems like I can't have both. I think your expertise can help, many brains thinks better than one. 

[RandyHayes]

@Anonymous 

Strange....

This is a wildshot, but try the following:

With({_items:
    Filter(Table3, 
       (Dropdown_ReportName.Selected.Result="-" || 'ReportName ' = Dropdown_ReportName.Selected.Result)
    )},

    SortByColumns(
        Search(_items, SearchTerm.Text, "Terminology"),
        "Terminology"
    )
)

[Anonymous]

Hi Randy, heheh we go back to the initial issue. The drop down data does not work unless I type something in the search bar and backspace, then it shows the reports data. 

If you have more ideas keep it coming. I appreciate it. 

[RandyHayes]

@Anonymous 

Hmm...works great for me with a similar scenario.  

What is your Datasource?  

[Anonymous]

Hi, 

my data source is an Excel Sheet.

[RandyHayes]

@Anonymous 

Sorry for delay...trying to catch up on all the posts.  Are you still experiencing issues that you need help with?

[Anonymous]

Yes, It seems that it is impossible to do it like that. It wont take both (search bar and drop down box) for large data. I'm actually working on a large data glossary. But, I worked it around by creating a 2 options on the welcome page for people to search by report name with drop down bar or by typing the term on the search bar.