cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Filter Gallery by Combo Box containing Choice (Option Set)

Been struggling to get my gallery to filter correctly, I mean at all... lol

I have a gallery that needs to be filtered by a few combo boxes. The combo boxes contain items from a choice (option set) tied to the gallery entity as seen below:

Tristan_Falcon_0-1602114917652.png

All of the options show up correctly in the combo box, now I am trying to filter my gallery by these selections but I get the following error, "Invalid Argument Type"

Tristan_Falcon_2-1602115051743.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Tristan_Falcon ,

 

The code that filter on OptionSet field should be delegable. The issue is because of the IsBlank() function within Filter() function.

Please modify as follows.

If(
IsBlank(BuildingGalleryStatusCombo.Selected.Value),
LeaseBuildings, 
Filter(LeaseBuildings,'Status (crc10_status)' = BuildingGalleryStatusCombo.Selected.Value)
)

Hope this helps.

Sik

View solution in original post

3 REPLIES 3
Community Support
Community Support

Hi @Tristan_Falcon ,

 

I made a test on my side, but I can't reproduce your issue.

It seems there are more than one Status field with the same display name in Entity, please make sure the Status field is chosen correctly.

I recommend you use logic name of status field('crc10_status'), rather than display name('Status (crc10_status)'), to avoid risk.

For example: Choices(LeaseBuildings.'crc10_status')

Then refresh the Entity Connection to see if the issue is fixed.

Sik

Weird, seems to be working ok after logging in today?
But now I need to find a way to make this delegable... 

Hi @Tristan_Falcon ,

 

The code that filter on OptionSet field should be delegable. The issue is because of the IsBlank() function within Filter() function.

Please modify as follows.

If(
IsBlank(BuildingGalleryStatusCombo.Selected.Value),
LeaseBuildings, 
Filter(LeaseBuildings,'Status (crc10_status)' = BuildingGalleryStatusCombo.Selected.Value)
)

Hope this helps.

Sik

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,143)