BrowseGallery filtered by TextSearchBox

[mavako]

Hello,

I have an app - searchbox and browsegallery:

The source are columns "Part no after" and "Part no before" in table "TDD":

I would like to filter the Gallery by text in TextSearchBox. If the TextSearchBox is empty, all items vissible is OK, but if I write something to TextSearchBox there is nothing in Gallery. In this example I wrote "CC" which should view CC005, CC006, CC007 etc....but nothing viewed. 

this error

When I had source in GoosleSheet before in another App this fomrula was working. But now I have source in Excel Online (Business) and doesn't work.

Can somebody help me, please?

[zmansuri]

Search([@TDD],TextSearhBoox1.Text,ColumName1,ColumName2)

[mavako]

I have it but doesn't work

Search([@TDD];TextSearchBox1.Text; "Part no after";"Part no before")

[timl]

Hi @mavako 

The Search function with the Excel Online Business connector supports only a single column.

The following workaround should hopefully work for you.

With({tdd1:Search([@TDD]; TextSearchBox1.Text; "Part no after")};
     Search(tdd1; TextSearchBox1.Text; "Part no before"))
)

[mavako]

If I try to search only one column it doesn't work too

Search([@TDD]; TextSearchBox1.Text; "Part no after")

@timl doesn't work, the error is elsewhere probably

[mavako]

I tried to create new Gallery in previous app with source Google Sheet the same way and works fine, so I think the issue is because of the source Excel online (business).

May be?

[timl · Accepted solution]

Hi @mavako 

I think you're right - this appears to be a problem with the Excel online business connector.

I can re-create the problem and the cause of this is the space in the column name. The search function works ok for me with columns that don't include a space.

Would it be easy for you to rename the column header so that it's "PartNoAfter" instead of "Part no after"?

[timl]

Hi @mavako 

Could you try the following to see if this works for you?

With({tdd1:Search(RenameColumns([@TDD];"Part no after";"PartNoAfter";
                                "Part no before";"PartNoBefore"); 
                  TextSearchBox1.Text; "PartNoAfter")};
     Search(tdd1; TextSearchBox1.Text; "PartNoBefore"))
)

In the meantime, I've posted this issue in the ideas forum and you can vote for it to be fixed here:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Bug-Excel-online-business-connector-fails-to-se...