Unanswered

Filter Grid based on Dropdown

(1) Share

Report

Posted on by Dunes

Hi All,

I want to filter my table based on a dropdown box. I have a dropdown box that has list of distinct Statuses from a SharePoint list 'Requests' (example: Rejected, Approved, Pending). My table also uses the same SharePoint list. The status field in the SharePoint list is a choice column.

I keep getting this error "Incompatible Types for Comparison. These types can't be compared Record : Record" in my table items property code.

I have the following code on the table Items property :

Filter(Requests, Status = drpStatusFilter.Selected.Value)

This is my dropdown code:

Distinct(Requests,Status)

Any help is appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (2)

Report
Hey @Dunes ,

We all had that problem. Basically it's because a choice Column is not only a Value but a table.
to get this Filter Working you could do the following:

in the Drop-down Items property you can add this:
Filter(Requests, Status.Value = drpStatusFilter.Selected.Value)

Let me know if it worked for you.

Was this reply helpful? Yes No
Dunes 55 on at

Like (1)

Report

Hi @DBO_DV ,

When I put that in my dropdown items property I get the error "Incompatible Types for Comparison. These types can't be compared Record : Record".

See below I have my dropdown above my grid where I want to select distinct values of the Status field from my same SharePoint list that feeds the grid and have the grid only show those records with that Status.

This is the dropdown code you suggested:

This is my grid items property where I want to filter based on the dropdown:

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report

Sorry my bad not the dropdown Items property but the Gallery items property has ti have this code .

Now that you've send some screenshots, I can see, that the table Request is not Recognized as table. Is this a visual Bug or is the table not connected correctly?

Was this reply helpful? Yes No
Dunes 55 on at

Like (2)

Report

It is connected correctly. I had played with the names before I screen shot it. The name of the list is CAPX. See below.

Was this reply helpful? Yes No
Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report
But maybe you can also do this in DropDown Items put
Choices(Requests.Status)

And in the Gallery Items Property:
Filter(Requests, Satus=Dropdown1.Selected)

Was this reply helpful? Yes No
Dunes 55 on at

Like (1)

Report

The Status choices display with this code you mentioned with no errors

But I still get the following error here
I

Was this reply helpful? Yes No
Verified answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report

Could you try to add .Value on Both sides for the Gallery. I don't really understand why the two can't be compared since they should be formatted exactly the same.

Was this reply helpful? Yes No
Dunes 55 on at

Like (2)

Report

This worked...Thank you so much for your help..trying to find the right syntax on this part was not fun.

Filter(CAPX, Status.Value=drpStatusFilter.Selected.Value)

Was this reply helpful? Yes No
Verified answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (2)

Report

Yes it's not easy with those columns (LookUp, Choice Column, People Picker,...)

could you please accept the answer as Solution, so that others can find it as well?

Was this reply helpful? Yes No