Answered

Search Gallery with Number

(0) Share

Report

Posted on by Community Power Pla...

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

Verified answer

Sienna 1,532 on at

Like (3)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Sienna 1,532 on at

Like (0)

Report

Can you try Text(TableName.IDNumber)
What datasource are you using? Sharepoint?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Sienna 1,532 on at

Like (1)

Report

Never tried that. Any chance to use Filter instead?

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Sienna 1,532 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
evalindag 117 on at

Like (0)

Report

Hi @Sienna
I have made a collection and am now trying to search in that collection. Can you help me? 🙂

Best regards
Eva

Was this reply helpful? Yes No
sadjei 22 on at

Like (10)

Report
Another solution is to first create a custom column in your dataset using the AddColumns function, that converts that number field to text, then you can search on it.
Search( AddColumns('Table', "MyTextCol", Text(IDNumber)), TextSearchBox1.Text, "MyTextCol")

Was this reply helpful? Yes No
Ruben-Ruiz 26 on at

Like (2)

Report

Hi, try this:

Property Items in your gallery component:

Search(
AddColumns(colYourTable, "IDSearch", Text(IDNumber)),
TextSearchBox1.Text,
"IDSearch"
);

Was this reply helpful? Yes No