Answered

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

All responses (9)

Answers (2)

Verified answer

DBO_DV 4,534 Super User 2025 Season 1 on at

Like (2)

Report

Re: Filter Grid based on Dropdown

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?
Dunes 55 on at

Like (2)

Report

Re: Filter Grid based on Dropdown

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)
Verified answer

DBO_DV 4,534 Super User 2025 Season 1 on at

Like (1)

Report

Re: Filter Grid based on Dropdown

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.
Dunes 55 on at

Like (1)

Report

Re: Filter Grid based on Dropdown

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

But I still get the following error here
I
DBO_DV 4,534 Super User 2025 Season 1 on at

Like (1)

Report
Re: Filter Grid based on Dropdown

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)
Dunes 55 on at

Like (2)

Report

Re: Filter Grid based on Dropdown

It is connected correctly. I had played with the names before I screen shot it. The name of the list is CAPX. See below.
DBO_DV 4,534 Super User 2025 Season 1 on at

Like (1)

Report

Re: Filter Grid based on Dropdown

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?
Dunes 55 on at

Like (1)

Report

Re: Filter Grid based on Dropdown

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:
DBO_DV 4,534 Super User 2025 Season 1 on at

Like (2)

Report
Re: Filter Grid based on Dropdown

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.