Hi
I am trying to create a search filter on a collection, which has person fields. I understand that Search does not do complex columns.
My search uses multiple columns, so I didn't wat to use Filter.
My question is there any easy way that I can extract the DisplayName into another temporary field.
To make it more difficult the person Column can have multiple values. I have tried Concat() but to no avail
i.e. Collect(coltemp, AddColumns(ListName, ApproversDisplayName, Concat(Approver, DisplayName, ",")))
Is there something that can be done, or do I need a complex filter query?
I also have date fields (although may exclude them anyway as just a pain) and other complex columns(ComboBox results etc)
TIA
