Skip to main content

Notifications

Power Apps - Building 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:
  • gastonfoselli Profile Picture
    gastonfoselli 12 on at
    Re: Issue on the visualization of the gallery

    Thank you for your help, it worked really well.

  • Verified answer
    CU-18081211-6 Profile Picture
    CU-18081211-6 9,261 on at
    Re: Issue on the visualization of the gallery

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

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard