Filter Gallery by Combo Box containing Choice (Option Set)

[Tristan_Falcon]

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:

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"

[v-siky-msft]

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

[Tristan_Falcon]

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

[v-siky-msft · Accepted solution]

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