Search function with dynamic set of fields

[iwonder]

Thank you for taking the time to read my question.

I have a combo box with a list of table fields in it. I am using the .SelectedItems to create a string of Field Names that I thought I could use in my Select() function

Field Name String

With({FieldList:Concat(ComboBox1.SelectedItems,"""" & tFields & """" & ",")}, Left(FieldList,Len(FieldList)-1))

Search()

Search(colAssets,TextInput1.Text,With({FieldList:Concat(ComboBox1.SelectedItems,"""" & tFields & """" & ",")}, Left(FieldList,Len(FieldList)-1)))

but I'm getting an error saying that Search is expecting a string where the With() starts.

Is there a proper way to generate a dynamic list of fields in which to search based on users selection?

Thanks

[BCLS776 · Accepted solution]

Unfortunately, Power Apps doesn't support using column names in a dynamic, runtime form such as this. Is there anything stopping you from listing all the possible columns in the Search() function?

Bryan

[iwonder]

Hi Bryan,

Thank you for the info. I guess that will have to be the only way. The group wanted to be able to define what fields they search in.

have a great day