Solved: Filter Function: Expected Text Value

Brianmaric · ‎08-24-2020

I have a simple one column excel spreadsheet which I added as a data source to a Gallery.

I then added a Text Input box to use as a filter. I then added the following formula, but keep getting the error 'expected text value'

Filter(Table1,Title2 = Fbox.Text)

Can some one help?

Thx

PowerAddict · ‎08-24-2020

Where is this filter function being used? Is it in a label or is the items property of a gallery? Also, what is the data type of the Title column?

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

View solution in original post

PowerAddict · ‎08-24-2020

Where is this filter function being used? Is it in a label or is the items property of a gallery? Also, what is the data type of the Title column?

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP