Can the search()-function search in a column which has table value?
In my Example colTest:
|Name 1||Adress 1||Id= 1; Value="Value1"|
|Name 2||Adress 2||Id= 1; Value="Value2"|
|...||...||Id=... ; Value="..."|
This function doesn't work because the column "lookup.value" is not correct. But how can I search in the column "lookup" for the column value??
Search(colTest,TestInput2.Text in "Name","Address","Lookup column.Value")
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Add a column to your collection before you search it.
I can't tell which type of datasource you are using to create your collection. I don't use lookup columns and prefer to use a separate table and save the ID from that table as a foreign key. This will execute much faster as the keys are indexed.
It looks like you got most of your question answered. I just wanted to pop in and add a bit more information. Feel free to take a look.
Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.