Announcements
All,
I'm trying to use a Search (textinput1) SQL date and decimal data types in a Gallery. Receiving an error Expect text type. For example: trying to Search Gallery1 for Processing Dates or Payment Amounts. Any help would be appreciated. Thank you
Hi @Anonymous ,
Search only works for text column, however you could use filter instead.
I think this link will help you a lot:
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup
Best Regards,
Bof
@Anonymous
As @v-bofeng-msft says search works only for text columns.
If you want to use Search, my advice is to create a view that's based on your SQL table and to cast the date and decimal columns to nvarchar. That would enable you to call Search against those columns.
The difficulty of using a single text input control and Filter is that you would need to determine what the user is entering and to convert the input into a date or number in your call to Filter. There's also more complexity involved in building a call to Filter so that it matches multiple columns against a single input value.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
