cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Filter Function: Expected Text Value

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

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

View solution in original post

3 REPLIES 3
Super User II
Super User II

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

View solution in original post

It just worked.

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

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (35,068)