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.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications