Answered

Issue on the visualization of the gallery

(0) Share

Report

Posted on by gastonfoselli

Hello everybody,

I have a gallery linked to an excel on one drive. This gallery has a conditional that sort and filter the values shown in the gallery and one of this filters logic test is linked to a text entry control but when I execute the app, it does not show any values until I change the value of the text entry control. This text entry control has a default value set but it does not activate the gallery until I change it.

This is the conditional for the gallery items being "filtro_dias1" the text entry control value.

If(!IsBlank(varRanking1);
 Sort(
 Filter(Base_Python_temp;
 Value(filtro_dias1) >= Value(DiasDifIP);
 IsBlank(filtro_pozo1) || filtro_pozo1 = pozo_mayusc;
 IsBlank(filtro_distrito1) || filtro_distrito1 = distrito_desc;
 IsBlank(filtro_proyecto1) || filtro_proyecto1 = proyecto_secundaria;
 IsBlank(filtro_equipo1) || filtro_equipo1 = equipo_produccion;
 IsBlank(filtro_bateria1) || filtro_bateria1 = bateria;
 IsBlank(filtro_sistema1) || filtro_sistema1 = sistema_x0020_de_x0020_extracción);
 Value(ranking;"en-US");
 If(
 varRanking1 = true;
 Ascending;
 Descending
 )
 );
 Filter(Base_Python_temp;
 Value(filtro_dias1) >= Value(DiasDifIP);
 IsBlank(filtro_pozo1) || filtro_pozo1 = pozo_mayusc;
 IsBlank(filtro_distrito1) || filtro_distrito1 = distrito_desc;
 IsBlank(filtro_proyecto1) || filtro_proyecto1 = proyecto_secundaria;
 IsBlank(filtro_equipo1) || filtro_equipo1 = equipo_produccion;
 IsBlank(filtro_bateria1) || filtro_bateria1 = bateria;
 IsBlank(filtro_sistema1) || filtro_sistema1 = sistema_x0020_de_x0020_extracción)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!
@gastonfoselli ,

From your description it seems that filtro_dias1 is a variable and most probably you set it's value onChange property of the text input control. Refer inside items property of the gallery directly to the value of TextInputControl.Text.

Here is my proposal.

With( {filterResults: Filter(Base_Python_temp; Value(TextInputControl.Text) >= Value(DiasDifIP); IsBlank(filtro_pozo1) || filtro_pozo1 = pozo_mayusc; IsBlank(filtro_distrito1) || filtro_distrito1 = distrito_desc; IsBlank(filtro_proyecto1) || filtro_proyecto1 = proyecto_secundaria; IsBlank(filtro_equipo1) || filtro_equipo1 = equipo_produccion; IsBlank(filtro_bateria1) || filtro_bateria1 = bateria; IsBlank(filtro_sistema1) || filtro_sistema1 = sistema_x0020_de_x0020_extracción)}; If(!IsBlank(varRanking1); Sort( filterResults; Value(ranking;"en-US"); If( varRanking1 = true; Ascending; Descending ) ); filterResults ) )

Hope it helps !

Was this reply helpful? Yes No
gastonfoselli 12 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your help, it worked really well.

Was this reply helpful? Yes No