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
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 ?
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.
User | Count |
---|---|
207 | |
92 | |
84 | |
49 | |
41 |
User | Count |
---|---|
254 | |
104 | |
103 | |
61 | |
59 |