cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Search Gallery with Number

Search('Table', TextSearchBox1.Text, "IDNumber")

 

Is there a way to Search for a number in a Gallery? Attempting to use a field in my Search that is a Number format just seems to lead to a error.

1 ACCEPTED SOLUTION

Accepted Solutions
Sienna
Level 10

Re: Search Gallery with Number

You can search only for text. you can either format the number to text

 Search('Table', Text(TextSearchBox1.Text), Text(IDNumber))

Or use filter instead

7 REPLIES 7
Sienna
Level 10

Re: Search Gallery with Number

You can search only for text. you can either format the number to text

 Search('Table', Text(TextSearchBox1.Text), Text(IDNumber))

Or use filter instead

Anonymous
Not applicable

Re: Search Gallery with Number

Issue is Text(IDNumber) doesn't work. It says Text has a invalid value.

Sienna
Level 10

Re: Search Gallery with Number

Can you try Text(TableName.IDNumber)

What datasource are you using? Sharepoint?

Anonymous
Not applicable

Re: Search Gallery with Number

No luck. Invalid argument again. I am using CDS (Common Data Service).

Sienna
Level 10

Re: Search Gallery with Number

Never tried that. Any chance to use Filter instead?

 

Filter('Table', Value(TextSearchBox1.Text) = IDNumber)

Anonymous
Not applicable

Re: Search Gallery with Number

Was hoping to use Search for this specific part... but if it isn't possible not a lot can be done. I'll slot this into my existing Filter

Sienna
Level 10

Re: Search Gallery with Number

One of the option how you can achive to use search is to collect your datasource into a collection and search in the collection. Need a help doing that?

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 122 members 4,545 guests
Please welcome our newest community members: