cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenGillard
Level: Powered On

Filterering Distinct Results in a DropDown

I currently have a drop down control with this formula:

Distinct('BAU Course Dates',Course.Value)

This works fine.

I would like to also have a filter on this so it also only shows the items that contain the word "Ellispe". I have tried this but i did not work.

Filter(Distinct('BAU Course Dates',Course.Value),Choice.Value = "Ellispe"

Thanks

 

 

4 REPLIES 4
egallis
Level 10

Re: Filterering Distinct Results in a DropDown

Hi @BenGillard,

Try this:

Filter(Distinct('BAU Course Dates',Course.Value),Find("Ellispe",Course.Value))

Emmanuel

BenGillard
Level: Powered On

Re: Filterering Distinct Results in a DropDown

Thanks for your reply:

I now get this: Find has some invalid arguments 😞

Filter(Distinct('BAU Course Dates',Course.Value),Find("Ellispe",Course.Value))
egallis
Level 10

Re: Filterering Distinct Results in a DropDown

Ok... Is your Course column a choice or lookup column type ?

Super User
Super User

Re: Filterering Distinct Results in a DropDown

@BenGillard 

You will basically want to filter the results of the Distinct based on the results containing "Ellispe"

 

So, consider this formula for your Items:

   Filter(Distinct('BAU Course Dates', Course.Value), Find("Ellispe", Result)>0)

 

As @egallis suggests, if this is a Choice type or Lookup column, you may need to adjust accordingly. 

 

Hope this helps.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

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: 367 members 6,372 guests
Please welcome our newest community members: