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')
Can you explain why this is not working.
Filter(Choices(KUADictionary.Category_type), Value = Products.Value)
I have a gallery which I want to be filtered based on a collection.
@JHS2020 what error do you get (or if you don't get errors, how is it not working)?
If 'Products' is a collection, and you want to filter the Category_type choices only for those whose values are present in the gallery, then you can use should use the in operator instead of the equality one:
Filter(Choices(KUADictionary.Category_type), Value in Products.Value)
Hope this helps!
Since the Filter is requiring to use value instead table. I’ve used ‘AddColumns’ function to convert it as a value. Then, I used Distinct to extract duplicate values.
Distinct(Filter(AddColumns(Test,"lookup1value",Lookup1.Value),Choice.Value <> "Choice 2"),lookup1value)
I hope this will save someone from headache. 😄
I am having a lookup field that referred to another list which has more than 5k rows. Threshold view error message is spamming at me. From what I understand, as long as I filter my lookup combobox to less than 5k rows, it will work right?
Have you ever encounter such a scenario? Appreciate if you can feed some formula reference here. 🙂
Got it; in this case, you can filter the result of the "Choices" based on another filter on the linked table, something along the lines ofFilter( Choices(ProjectTasks.Sprint); Value in Filter(ProjectSprints, Project = "PROJ0112").Title)
This thread still seems to be active, and I think this is relevant:
I think this is VERY close to the solution I need, but I can't seem to dial it in. I'm building an app where users may register for a class by selecting a date. The date selection is 'Attendee Registration'.DatesFirstChoice . The available class dates are in a lookup table 'Lookup Dates'.StartDate . The Lookup Table also has column .Status , which I'd like to be able to use as a choice filter.
I've tried to apply this formula but it doesn't like the way I'm using "Value".
Filter( Choices( 'Attendee Registration'.DatesFirstChoice ); Value in Filter( 'Lookup Dates', Status="Registration Open" ) .'Start Date' )
I get "Name isn't valid. 'Value' isn't recognized"
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.