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

View solution in original post

Hi Warren,

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,771)