cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CarlosN
Helper IV
Helper IV

Gallery Filter

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.

1 ACCEPTED SOLUTION

Accepted Solutions

@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

View solution in original post

6 REPLIES 6
WarrenBelz
Super User
Super User

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?

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.

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

 

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)

@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

Hi Warren,

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

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (2,436)