Having issues filtering on a choice dropdown from sharepoint list

[Cato]

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?

[eka24 · Accepted 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.

[Cato]

Thanks eka24! Filter(Products, Category.Value = Dropdown_Category.Selected.Value) was what fixed the issue 😊