cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

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
Super User
Super User

Hi @BenGillard,

Try this:

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

Emmanuel

Thanks for your reply:

I now get this: Find has some invalid arguments 😞

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

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

@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.

_____________________________________________________________________________________
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.
Check out my PowerApps Videos too!

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (34,888)