Answered

How to filter a gallery using a dropdown ?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a gallery that I can filter with a SearchBox, the problem is I also want to filter it with a dropdown.

In the dropdown (EquipeOT), I manually put the data that I have in the field "EquipePrincipale" of the List, but in the code (attachment 1.png) it shows an error.

Here is the code of the galley : Sort(Filter('Liste OT test V2',StartsWith(NumOT,RechercheOT.Text) Or RechercheOT.Text in DescriptionOT, EquipePrincipale = EquipeOT.Selected.Value), DateEdition, SortOrder.Descending)

I would like to know what I have to do to make it work

Thanks for your help,

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

The in function cannot be delegated so I suggest for a dropdown, create a collection Onvisible;

ClearCollect (ColListV2,'Liste OT test V2')

Then change the code to:

Sort(Filter('ColListV2',StartsWith(NumOT,RechercheOT.Text) , RechercheOT.Text in DescriptionOT, EquipePrincipale = EquipeOT.Selected.Value), DateEdition, SortOrder.Descending)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi js7,

try to use "search" function and have a look on this article which seems to answer your questions in detail.

Regards

SwiPowE

SwiPowE - Swiss Powerapps Enthusiast

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous :
I noticed that there is a red wavy line under the "=" operator. Usually this is caused by the mismatch of the data types of the values on both sides of the "=" operator.
Could you tell me:
What is EquipeOT.Selected.Value's datatype?
What is EquipeOT? A dropdown control or a combo box control?
What is EquipeOT's items property?
What is EquipePrincipale's datatype?(Does it allow multiple selections)
Best Regards,
Bof

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Actually I resolved the problem by using "value",

EquipeOT is my dropdown
EquipePrincipale is my choice column

Here is my filter formula : Filter('Liste OT test V2',StartsWith(NumOT,RechercheOT.Text) Or RechercheOT.Text in DescriptionOT,EquipeOT.Selected.Value = EquipePrincipale.Value)

Here is my dropdown formula : Choices([@'Liste OT test V2'].EquipePrincipale)

Was this reply helpful? Yes No