cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
charafRef
Level 8

How to filter by using many dropdowns on the same formula ?

Hi Powerapp Community ,

i'm building my first app powerapp. i have three screen : HOME , ANNOUNECEMENTS & LISTS.


After filtring the announcementType by my drowpdown1.Then , I want to add another action on the same Item.
I wanna filter by language (it's my dropdown2 & dropdown3). i tried but still doesn't work don't know where is the issue !
How may i using many dropdowns (the three dropdown of my app) on the same formula Items to show them on my List screen.

 

 

Tnx a lot for your help.

Regards ,

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to filter by using many dropdowns on the same formula ?

Hi charafRef,

 

Please try if this will work for you.

SortByColumns(Filter(ProjectEmail,StartsWith(Status.Value,Dropdown1.Selected.Value)&&Dropdown2.Selected.Value in Title),"Title",If(SortDescending1,Descending,Ascending))


In this function, I have two Dropdown controls, Dropdown1 for a Choice column, Dropdown2 for a Text column.


Please modify the function according to your scenario.


If you need more help, please feel free post back.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: How to filter by using many dropdowns on the same formula ?

Hi charafRef,

 

Please try if this will work for you.

SortByColumns(Filter(ProjectEmail,StartsWith(Status.Value,Dropdown1.Selected.Value)&&Dropdown2.Selected.Value in Title),"Title",If(SortDescending1,Descending,Ascending))


In this function, I have two Dropdown controls, Dropdown1 for a Choice column, Dropdown2 for a Text column.


Please modify the function according to your scenario.


If you need more help, please feel free post back.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

charafRef
Level 8

Re: How to filter by using many dropdowns on the same formula ?

Hi @v-yamao-msft 

Sorry for my late answer. I had found the solution by myself. Exaclty like your formula.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 165 members 5,896 guests
Please welcome our newest community members: