Hello all!
I'm having an issue with filtering.
Scenario:
I have a SharePoint list named Products with the following data structure.
Text: ProductName
Text: Description
Choice: Category
In my PowerApp I have an Edit form that connects to this list.
Since the edit form has the user select a product from the sharepoint list (And there are about 400 of them) I want to filter their selection by using Category.
I've added a dropdown list for both ProductName and Category in the form.
Category Dropdown - Items: Choices(Products.Category)
Now, when I try to filter the Product dropdown I get an "Invalid argument type". Formula:
Filter(Products, Category = Dropdown_Category.Selected.Value)
Even trying to enter a defined text into the filter yields the same result, ie:
Filter(Products, Category = "Pipes")
I've even tried to create a collection whenever a category is selected, but I get the same issue, "Invalid argument type".
When clicking the Product dropdown in GUI and selecting depends on, I don't even get the option of selecting Category in the Matching Field value dropdown.
Any idea how to resolve this, or do I have to create a copy of the entire list where Category isn't a Choice based input option of the list, but regular text?
