Answered

Search Gallery with personal number

(0) Share

Report

Posted on by MazingerZ_68

I have problems getting the number information for each person to be shown with the gallery's Search function.

I created an example of 5 personal data. I dont have problems if i search the name. I need to find the personal data by number, but dont show me anything. The information comes from an excel table.

Search(Contratistanew;TextSearchBox1.Text;"Cedula")

Please let me know how to solve this.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MazingerZ_68 ,

What is the name of your number field and it is stored as a number format or text ?

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MazingerZ_68

Have you tried wrapping the TextSearchBox.Text inside of the value function?:
Value(TextSearchBox.Text)

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
MazingerZ_68 63 on at

Like
a
(0)

Report
Copy link

Link copied!

The name is Cedula. Its store as General.

Was this reply helpful? Yes No
MazingerZ_68 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I tried, but doesnt work. When i simulated the search, can´t find any number.
Dont show me any error , but dont work.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@MazingerZ_68 ,

You cannot Search on number columns - try

Search( AddColumns( Contratistanew; "CedulaTxt"; Text(Cedula) ); TextSearchBox1.Text; "CedulaTxt" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
MazingerZ_68 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Super, it solve..but when i made this change something happens with the visualization of the form.

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MazingerZ_68 ,

You need to specify the record you need - put in whatever field is the unique identifier of your record. In the Form Item

LookUp( TableName, YourIdentifier = BrowseGallery1.Selected.YourIdentifier )

or if you want instead to leave the Form alone (this is a bit messy) - in the Gallery Items

DropColumns( Search( AddColumns( Contratistanew; "CedulaTxt"; Text(Cedula) ); TextSearchBox1.Text; "CedulaTxt" ), "CedulaTxt" )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No