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?
Solved! Go to Solution.
Try any of these:
Filter(Products, Category.Value = Dropdown_Category.Selected.Value)
Or
Filter(Products, Category = Dropdown_Category.Selected.Category)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Try any of these:
Filter(Products, Category.Value = Dropdown_Category.Selected.Value)
Or
Filter(Products, Category = Dropdown_Category.Selected.Category)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Thanks eka24! Filter(Products, Category.Value = Dropdown_Category.Selected.Value) was what fixed the issue 😊
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
183 | |
51 | |
47 | |
32 | |
32 |
User | Count |
---|---|
264 | |
91 | |
78 | |
68 | |
67 |