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.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
187 | |
82 | |
50 | |
37 |
User | Count |
---|---|
290 | |
243 | |
123 | |
74 | |
54 |