Filter Function: Expected Text Value

[Brianmaric]

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 · Accepted solution]

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

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

[Brianmaric]

It just worked.

[PowerAddict]

I am glad it worked! Good luck with the rest of the app! Feel free to reach out in case of any questions!

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email