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
Solved! Go to 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
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
It just worked.
User | Count |
---|---|
183 | |
124 | |
88 | |
45 | |
43 |
User | Count |
---|---|
248 | |
157 | |
127 | |
78 | |
73 |