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.
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!