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"
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.
Watch Microsoft Business Applications Summit sessions on-demand.
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!
Features releasing from April 2020 through September 2020