Gallery Filter with diferent type of column

(1) Share

Report

Posted on by JulianPP

I am trying to apply a filter to the gallery data, when I try to filter the column “TIPO DE APRENDIZAJE it shows me an error and no data appears in the table.

Search('Base Datos - Lecciones Aprendidas';Textapren.Text;'Tipo de Aprendizaje')

The list of data is stored in a sharepoint and the column “TIPO DE APRENDIZAJE” is an Option column.

Then I do the same with the column “DESCRIPCION DEL APRENDIZAJE” and although it shows an advisability if the filter is executed.

Search('Base Datos - Lecciones Aprendidas';Textdescrip.Text;'Descripción del Aprendizaje')

The column “DESCRIPCION DEL APRENDIZAJE” is of the type several lines of text.

How can I apply the filter to the gallery for the different columns….

UPDATE 30/07/2024

i use the filter option and combobox but dont work.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Giraldoj 762 Super User 2025 Season 2 on at

Like (0)

Report
Hi There,

You should try using Filter function instead, because Search Function only works with text columns, your code using Filter function Should look similar to this:

Filter('Base Datos - Lecciones Aprendidas', Text('Tipo de Aprendizaje') = Textopren.Text)

you can find more information and some samples about the differences of Search, Filter and Lookup

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup

and finally if your search function is working fine you can combine both in your gallery Items property:

Filter( Search('Base Datos - Lecciones Aprendidas', Textdescrip.Text, 'Descripción del Aprendizaje'), Text('Tipo de Aprendizaje') = Textopren.Text )

If this helps, please mark it as the solution by clicking "Accept as solution." A "Thumbs Up" would be greatly appreciated if you found the content helpful. Thanks!
Best,
LinkedIn: https://www.linkedin.com/in/jhonatan-giraldo-2b20561b9/

Was this reply helpful? Yes No
Chris Ludwig 34 on at

Like (0)

Report

Hello,
If I see it correctly, you are trying to do a “Search” on a selection field. This is theoretically possible, but you have to work with the .value extension.
In general, I would also recommend working with a filter. In particular, I would filter a selection field with a combo box or radio buttons - this makes it much easier for users.

If you still want to work with the search, you can try the following

Search('Base Datos - Lecciones Aprendidas';Textapren.Text;'Tipo de Aprendizaje'.Value)

Was this reply helpful? Yes No