Answered

How to filter a gallery using a dropdown ?

(0) Share

Report

Posted on by Community Power Pla...

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

1.png

I have the same question (0)

All responses (5)

Answers (1)

eka24 20,923 on at

Like (0)

Report

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

Like (0)

Report

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... on at

Like (0)

Report

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 on at

Like (0)

Report
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... on at

Like (0)

Report

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