Hi @kcgov ,
Do you want to filter your Gallery Items based on the Buttons click against the Option Set Type column in your CDS Entity?
Based on the formula that you mentioned, I think there is something wrong with it. I have made a test on my side, please try the following workaround:
Set the OnSelect property of "All" button to following:
Set(CurrStatus, "All")
Set the OnSelect property of "Open" button to following:
Set(CurrStatus, "Open")
Set the OnSelect property of "Pending" button to following:
Set(CurrStatus, "Pending")
Set the OnSelect property of "Approved" button to following:
Set(CurrStatus, "Approved")
Set the OnSelect property of "Declined" button to following:
Set(CurrStatus, "Declined")
Set the Items property of the Gallery to following:
Filter(
CASES,
If(
CurrStatus = "All" || IsBlank(CurrStatus),
true,
CurrStatus = "Open",
Status = [@StatusOptionSetName].Open,
CurrStatus = "Pending",
Status = [@StatusOptionSetName].Pending,
CurrStatus = "Approved",
Status = [@StatusOptionSetName].Approved,
CurrStatus = "Declined",
Status = [@StatusOptionSetName].Declined
)
)
Note: The StatusOptionSetName represents the OptionSet name your Option Set column related to, please replace it with your own Option Set Name from your CDS.
Please check and see if the following blog would help in your scenario:
https://powerapps.microsoft.com/en-us/blog/option-sets-and-many-to-many-relationships-for-canvas-apps/
Please consider take a try with above solution, check if the issue is solved.
Best regards,
