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"
Solved! Go to 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
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
185 | |
53 | |
41 | |
36 | |
30 |
User | Count |
---|---|
242 | |
81 | |
71 | |
69 | |
65 |