Filterering Distinct Results in a DropDown

[BenGillard]

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

[R3dKap]

Hi @BenGillard,

Try this:

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

Emmanuel

[BenGillard]

Thanks for your reply:

I now get this: Find has some invalid arguments 😞

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

[R3dKap]

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

[RandyHayes]

@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 @R3dKap suggests, if this is a Choice type or Lookup column, you may need to adjust accordingly. 

Hope this helps.