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?
Solved! Go to 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"?
Search([@TDD],TextSearhBoox1.Text,ColumName1,ColumName2)
I have it but doesn't work
Search([@TDD];TextSearchBox1.Text; "Part no after";"Part no before")
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"))
)
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
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?
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"?
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:
User | Count |
---|---|
156 | |
97 | |
87 | |
78 | |
58 |
User | Count |
---|---|
190 | |
180 | |
107 | |
95 | |
91 |