Gallery Filter

[CarlosN]

Good night,
I have a gallery that filters when I type in a text box (this works for me), but now I want that gallery to also filter when I select a user in a drop-down list.

[WarrenBelz]

Hi @CarlosN ,

What is your current filter code, the name and Items of your drop-down and the name of the field it has to match in your data?

[CarlosN]

This is my filter code, I currently filter by user, but I want to have a drop down list to change that filter and be able to see all the records.

[WarrenBelz]

@CarlosN ,

Firstly, I would do the below, but you did not answer the two other questions - the name of the field you want to match and the Items and name of the drop-down you want to match to. You also want to see all records before anything is typed in?

Can you also please post as Text (not a screenshot) - any mistakes in the below are caused by needing to OCR the picture.

Filter(
   ’Solicitudes ExprèsText;
   (
      SearchBoxl_2.Text in Cliente || 
      TextSearchBoxl_2.Text in Referencia || 
      TextSearchBoxl_2.Text in ID || 
      TextSearchBoxl_2.Text in Producto ||
      TextSearchBoxl_2.Text in EstatusMuestra
   ) && 
   (
      LbLPMNueva.Text in EstatusMuestra || 
      LbLPNReaLizada.Text in EstatusMuestra || 
      LbLPNTramite.Text in EstatusMuestra || 
      LbLPMDevueLta.Text in EstatusMuestra
   ) &&
   UsuarioMuestra=VarUsuario.FullName
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[CarlosN]

Hi Warrent,
I used this code with the instructions given.
also put additional one search by drop down list per user.

Filter('Solicitudes Expres';
(
TextSearchBox1_3.Text in Cliente ||
TextSearchBox1_3.Text in Referencia ||
TextSearchBox1_3.Text in ID ||
TextSearchBox1_3.Text in Producto ||
TextSearchBox1_3.Text in EstatusMuestra
) &&
(
LblPMNueva_1.Text in EstatusMuestra ||
LblPMRealizada_1.Text in EstatusMuestra ||
LblPMTramite_1.Text in EstatusMuestra ||
LblPMDevuelta_1.Text in EstatusMuestra
) && DdPrueba.SelectedText.TipoUsuario in UsuarioMuestra)

[WarrenBelz · Accepted solution]

@CarlosN ,

I cannot help you unless you give me the information I have twice requested (please do not send screen shots - just the answers)

• The name of the field you want to match
• The Items and name of the drop-down you want to match to.
• If you also want to see all records before anything is typed in

[CarlosN]

Hi Warren,

very grateful for your help, capturing them is to show you that I achieved what I needed.