web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Issue on the visualiza...
Power Apps
Answered

Issue on the visualization of the gallery

(0) ShareShare
ReportReport
Posted on by 12

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:
I have the same question (0)
  • Verified answer
    CU-18081211-6 Profile Picture
    9,270 Moderator on at

    @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 !

  • gastonfoselli Profile Picture
    12 on at

    Thank you for your help, it worked really well.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 103

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
wolenberg_ Profile Picture

wolenberg_ 67 Super User 2026 Season 1

Last 30 days Overall leaderboard