Issue in Search function

[akosbanar]

Dear All,

I found an interesting issue or paradox in Search function usage. 

I have a gallery what I filter with a textinput. Its seems like very easy, it isn't.

(Gallery -> Items)

As you can see for any reason the Power App underlines my code with red but it is working normally (also in the gallery).

The bigger problem when I'd like to use another column too in the Search function it already doesn't working.

If(
    IsBlank(Search_box.Text),
    PBIappsCollection,
Search(
        PBIappsCollection,
        Search_box.Text,
        "UseableTags",
        "Project Name"    
        )
)

I tried another method as well but with the same result.

If(
    IsBlank(Search_box.Text),
    PBIappsCollection,
Search(
        Filter(
            PBIappsCollection,
            Search_box.Text in UseableTags
        ),
        Search_box.Text,
        "Project Name"
	)
)

Note: "PBIappsCollection" is an Excel Online connector's data source.

Can you help me?

[akosbanar · Accepted solution]

I solved. 

It is still red underlined but working.

If(
    IsBlank(Search_box.Text),
    PBIappsCollection,
    Filter(
        PBIappsCollection,
        Search_box.Text in UseableTags || Search_box.Text in 'Project Name'
    )
)

[AJ_Z]

what does it say when you hover over the red?

[akosbanar]

@AJ_Z 

This is the current error message with Filter function.

[AJ_Z]

Sorry i see your problem i can't believe i never saw it sooner.

try this:

If(
    IsBlank(Search_box.Text),
    PBIappsCollection,
    Search(
        PBIappsCollection,
        Search_box.Text,"UseableTags","'Project Name'"
    )
)

But this part "UseableTags","'Project Name'" will likely be different see what the app populates the column names as. Also ensure that Useabletags is string and project name is string for this method

[akosbanar]

@AJ_Z 
Me neither.

I created a test gallery because I don't want to wrong my existed good solution. 

I know that your code is absolutely correct because based on the MS documents but it isn't working.

[AJ_Z]

i really think its the column names back space to until you reach Test_Textinput.text and see what column names it gives. i am happy to get on a teams call and screenshare to help troubshoot if needed

[akosbanar]

@AJ_Z 
Thank you for the opportunity but I think it is a Microsoft issue, at my company we realized more performance problems today and yesterday. 

The other thing that the code is working with Filter function what is the same as the Search just a little slower.

Some days later I check again it is still red underlined or already not.