Showing results for 
Search instead for 
Did you mean: 
Advocate III
Advocate III

How to filter choices() on Combobox

I am not apple to filter Sharepoint data where the field is a lookup-field in a form.


Is it possible to filter like this:


Filter( Choices(ProjectTasks.Sprint); Project.Value="PROJ0112")


Unfortunately the above is not working when using FILTER.


If I do not use FILTER - it works but lists all data without filterering like: Choices(ProjectTasks.Sprint)


Please help me understand how to filter the new Combobox in a Form using the commando Choices(dbsource.field)


sorry @Stijn007  - the project i was working on a year ago never went anywhere so I never did get this problem resolved.  good luck; if you do get an answer please post the solution because i'm still interested...

Frequent Visitor

I'm working through a similar issue where I am accessing data from lookup columns in my sharepoint list with a series of cboxes. The first combobox accessess my list of customers, then the next combobox accesses the same list but a different column populated by all of the sites owned by each customer, then in the next column I have all the different components owned located on each site.  I would like to show distinct values in the customer combobox, but for some reason with my current formula, the customer names are showing up as blank.  I think there is definitely something there because I can click on one of the blank fields, and the customer sites field populates correctly.. Can someone help me understand what is wrong my formula?


Frequent Visitor

Just dropping this in here for added reference since this post was so helpful and had several replies over the years.

Was able to filter a list of Payment Methods with a Choice called 'Type' when all I wanted to show was "Credit Card" or "Debit Card".


Filter(Choices(Type), Value = Type.'Credit Card' || Value = Type.'Debit Card')


Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,131)