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)
Solved! Go to Solution.
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...
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?
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')
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.