cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Super User III
Super User III

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (34,439)