Gallery with 3 combobox as filter

[Anonymous]

Hello everyone,

I am currently having problems with a gallery I have that is from a search that uses 3 combobox as filter. What the end result I want to reach to is something like this:

Where when a term is searched, it will throw all the results that have those words.

What I currently have, however, does not give back all the ones that have one with the terms searched:

As comparison, if in the second picture I have chosen those two in the combobox available, it should show all the results like the one in the first picture.

Regarding the codes I have, they are the following:

• Combobox1 ("listadoProyectosCB"):

Distinct(Consolidado_Piloto_v5, 'Nombre Proyecto')

• Combobox2 ("listadoTareasCB"):

Distinct(Filter(Consolidado_Piloto_v5, 'Nombre Proyecto'=listadoProyectosCB.Selected.Result), 'Nombre Tarea')

• Combobox3 ("listadoSubTareasCB"):

Distinct(Filter(Consolidado_Piloto_v5, 
'Nombre Proyecto' = listadoProyectosCB.Selected.Result,
'Nombre Tarea' = listadoTareasCB.Selected.Result), 'Nombre Subtarea')

• Gallery:

Filter(Consolidado_Piloto_v5,
Or(Lower(User().Email)=Lower('PowerApp Admin'),
Lower(User().Email)=Lower('Responsable ARQ'), 
Lower(User().Email)=Lower('Responsable ING'), 
Lower(User().Email)=Lower('Responsable ING Vial'), 
Lower(User().Email)=Lower('Responsable PlaceHolder1'), 
Lower(User().Email)=Lower(FelipeFlores), 
Lower(User().Email)=Lower(AlejandroBustamante)),
If(!IsBlank(listadoProyectosCB), 'Nombre Proyecto'=listadoProyectosCB.Selected.Result),
If(!IsBlank(listadoTareasCB), 'Nombre Tarea'=listadoTareasCB.Selected.Result),
If(!IsBlank(listadoSubTareasCB), 'Nombre Subtarea'=listadoSubTareasCB.Selected.Result))

Anyone can tell me what I am doing wrong, or what should I change?

[RandyHayes · Accepted solution]

@Anonymous 

Try changing your Gallery filter to this formula and see if you get any further:

Filter(Consolidado_Piloto_v5,
  (
  Lower(User().Email)=Lower('PowerApp Admin') || Lower(User().Email)=Lower('Responsable ARQ') || Lower(User().Email)=Lower('Responsable ING') ||
  Lower(User().Email)=Lower('Responsable ING Vial') || Lower(User().Email)=Lower('Responsable PlaceHolder1') || Lower(User().Email)=Lower(FelipeFlores) ||
  Lower(User().Email)=Lower(AlejandroBustamante)
  )
  && If(!IsBlank(listadoProyectosCB), 'Nombre Proyecto'=listadoProyectosCB.Selected.Result, true)
  && If(!IsBlank(listadoTareasCB), 'Nombre Tarea'=listadoTareasCB.Selected.Result, true)
  && If(!IsBlank(listadoSubTareasCB), 'Nombre Subtarea'=listadoSubTareasCB.Selected.Result, true)
)

But, what I am missing here is - where does your search term text box come into play?  I didn't see any reference to it except in the first photo.

[Anonymous]

@RandyHayes 

The searchbox from picture 1 is just as a reference, not anything else.

Also, the code I think did not work. As additional information, when I have chosen the 3 combobox, the gallery displays all items that should be seen going by those CB/"filter". If I put the first two, and also delete the line with

If(!IsBlank(listadoSubTareasCB), 'Nombre Subtarea'=listadoSubTareasCB.Selected.Result, true)

Then the gallery also works with what should be seen then. I am not sure what is causing this, to be honest. Going  by that, I would think on having 3 gallery, one on top of the other, changing the visible control, however that would be a hassle, probably, and/or make the app slower, perhaps

[RandyHayes · Accepted solution]

@Anonymous 

Ah I just realized one thing I glossed over at first...these are ComboBoxes.  So, your formula should really be this:

Filter(Consolidado_Piloto_v5,
  (
  Lower(User().Email)=Lower('PowerApp Admin') || Lower(User().Email)=Lower('Responsable ARQ') || Lower(User().Email)=Lower('Responsable ING') ||
  Lower(User().Email)=Lower('Responsable ING Vial') || Lower(User().Email)=Lower('Responsable PlaceHolder1') || Lower(User().Email)=Lower(FelipeFlores) ||
  Lower(User().Email)=Lower(AlejandroBustamante)
  )
  && If(!IsEmpty(listadoProyectosCB.SelectedItems), 'Nombre Proyecto'=listadoProyectosCB.Selected.Result, true)
  && If(!IsEmpty(listadoTareasCB.SelectedItems), 'Nombre Tarea'=listadoTareasCB.Selected.Result, true)
  && If(!IsEmpty(listadoSubTareasCB.SelectedItems), 'Nombre Subtarea'=listadoSubTareasCB.Selected.Result, true)
)

See if that helps.

[Anonymous]

@RandyHayes 

I used the following code:

Filter(Consolidado_Piloto_v5,
(Lower(User().Email)=Lower('PowerApp Admin') || Lower(User().Email)=Lower('Responsable ARQ') || 
Lower(User().Email)=Lower('Responsable ING') || Lower(User().Email)=Lower('Responsable ING Vial') ||
Lower(User().Email)=Lower('Responsable PlaceHolder1') || Lower(User().Email)=Lower(FelipeFlores) ||
Lower(User().Email)=Lower(AlejandroBustamante))
&& If(Text(listadoProyectosCB.Selected.Result)<>"", 'Nombre Proyecto'=listadoProyectosCB.Selected.Result)
&& If(Text(listadoTareasCB.Selected.Result)<>"", 'Nombre Tarea'=listadoTareasCB.Selected.Result)
&& If(Text(listadoSubTareasCB.Selected.Result)<>"", 'Nombre Subtarea'=listadoSubTareasCB.Selected.Result, true)
&& Dependientes=0)

Where 'dependientes' is hiding/filtering one line that is in blank.

With that code, I get the following:

• When using the 3 CB:

• When using 2 CB:

• When using only the first CB:

As seen, so far, somehow, managed to get the gallery to show all items when using 2 and 3 of the CB; however when using only one I am still getting stuck, so to speak. Any clue here?

[Anonymous · Accepted solution]

@RandyHayes 

Did find the solution, by doing some rework of the code. Can now see everything I wanted via the following code:

If(Text(listadoSubTareasCB.Selected.Result)<>"",
    (Filter(Consolidado_Piloto_v5,
    (Lower(User().Email)=Lower('PowerApp Admin') || Lower(User().Email)=Lower('Responsable ARQ') || 
    Lower(User().Email)=Lower('Responsable ING') || Lower(User().Email)=Lower('Responsable ING Vial') ||
    Lower(User().Email)=Lower('Responsable PlaceHolder1') || Lower(User().Email)=Lower(FelipeFlores) ||
    Lower(User().Email)=Lower(AlejandroBustamante))
    && If(Text(listadoProyectosCB.Selected.Result)<>"", 'Nombre Proyecto'=listadoProyectosCB.Selected.Result)
    && If(Text(listadoTareasCB.Selected.Result)<>"", 'Nombre Tarea'=listadoTareasCB.Selected.Result)
    && If(Text(listadoSubTareasCB.Selected.Result)<>"", 'Nombre Subtarea'=listadoSubTareasCB.Selected.Result, true)
    && Dependientes=0)),
If(Text(listadoTareasCB.Selected.Result)<>"",
    (Filter(Consolidado_Piloto_v5,
    (Lower(User().Email)=Lower('PowerApp Admin') || Lower(User().Email)=Lower('Responsable ARQ') || 
    Lower(User().Email)=Lower('Responsable ING') || Lower(User().Email)=Lower('Responsable ING Vial') ||
    Lower(User().Email)=Lower('Responsable PlaceHolder1') || Lower(User().Email)=Lower(FelipeFlores) ||
    Lower(User().Email)=Lower(AlejandroBustamante))
    && If(Text(listadoProyectosCB.Selected.Result)<>"", 'Nombre Proyecto'=listadoProyectosCB.Selected.Result)
    && If(Text(listadoTareasCB.Selected.Result)<>"", 'Nombre Tarea'=listadoTareasCB.Selected.Result)
    && Dependientes=0)),
If(Text(listadoProyectosCB.Selected.Result)<>"",
    (Filter(Consolidado_Piloto_v5,
    Or(Lower(User().Email)=Lower('PowerApp Admin'), Lower(User().Email)=Lower('Responsable ARQ'), 
    Lower(User().Email)=Lower('Responsable ING'), Lower(User().Email)=Lower('Responsable ING Vial'),
    Lower(User().Email)=Lower('Responsable PlaceHolder1'), Lower(User().Email)=Lower(FelipeFlores),
    Lower(User().Email)=Lower(AlejandroBustamante)),
    'Nombre Proyecto'=listadoProyectosCB.Selected.Result, Dependientes=0)))
    ))