I have a list of values in a gallery that I want to filter based on a text box.
On start I assign the value to "" using
Set(val,"")
And then whenever the text box changes I reassign val to the new value using the "On Changed" field under the advanced settings of the text box.
Set(val,TB1.Text)
Under the items property of the gallery I use the equation
Filter(Table, val in 'Value Column')
I get a delegation warning on the "in", and if I set it to "=" instead the warning goes away. I'd like to be able to search the column for any values that contain my search string. Is there a better way of doing this to avoid the warning?

Report
All responses (
Answers (