Answered

Search Funtion finding no Matches in table column

(0) Share

Report

Posted on by Tob447

Ive been working on app to help making quotes easier at the company where I work. I have this table that I want to search an specific id from the second column called "id_proceso"

I have this dropdown menu in powerapps where I want to display an specific field from all the records that match the search string in the the search function. As you can see the "id_proceso" with value "66506" yields no result , but it does excist in the table which is shown above.

When I put an empty search string in the search function , it does return to me every record as shwon in the image below.

why cant the search function find the matching records in the table when using a valid search string that excist in the table and in the column I am searching in.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

Try using Filter(costos_variables, id_proceso=66506)

Was this reply helpful? Yes No
Verified answer

timl 37,271 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Tob447

The reason for this is because the Search function works only against text fields and in your case, id_proceso is a number field.

One way to work around this is to add a column that contains the text representation of convert id_proceso like so:

Search(AddColumns(costos_variables;"id_proceso_text";Text(id_proceso)); "66506"; "id_proceso_text" )

Was this reply helpful? Yes No