0

I have a collection "Accounts". In that, we have a field which is "Full Name".How to refer to this field in a filter function. I used the following formula:

Filter(Accounts,'Full Name' in TextInput2.Text)

Here TextInput2.Text is a text input. When I apply this formula,it says 'Full Name' is not recognized.

I expected it to filter by using the 'Full Name' field name.But its saying name not recognized.

zangetsu
  • 1
  • 1
  • I think you have the field and textinput the wrong way round. Shouldn't it be: Filter(Accounts,TextInput2.Text in 'Full Name') – HSS Feb 14 '23 at 09:48
  • Surprisingly, this formula works in items property of the DataTable but not on onSelect property of a button or OnChange property of a text input. – zangetsu Feb 20 '23 at 08:22

0 Answers0