Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Filter data in Gallery using Enum field



I have data source PurchaseOrderHeader for my powerApps, I want to filter data in Gallery based on one field of type ENUM namely PurchaseOrderStatus, suggest me how do I achieve this.

I tried this code but its throwing error

Filter(PurchaseOrderHeader,PurchaseOrderStatus = "Ordered")


Community Support
Community Support

Re: Filter data in Gallery using Enum field

Hi @Gautam,


Could you please share a bit more about the PurchaseOrderHeader data source within your app?

Could you please share a bit more about the ENUM type column that you mentioned? Is it a Choice type column in SP list?


Please take a try to modify your formula as below:

Filter(PurchaseOrderHeader,PurchaseOrderStatus.Value= "Ordered")

then check if the issue is solved on your side.


If you could provide more details about your scenario, we could provided a proper workaround for you.


Best regards,




Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

Re: Filter data in Gallery using Enum field

I know this thread is old but i'm facing a similar issue where I am not able to filter on Enums using the Dynamics Finance and Operations Connector (using CDS is not an option). In my App I have the following filter


Filter(Datasource,EnumField= "Null")


In this case Invoice is a custom Enum field. I get the following: An error has occurred. A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.DataEntities.EnumField' and 'Edm.String' for operator kind 'NotEqual'.


I have seen a solution posted to convert the enumfield into a string to compare however this will make the query  non-delegatable and therefore is not an acceptable solution.


I know the correct Odata Syntax for this however I can't seem to cast the "Null" string as the enum type through the filter function.


Is there a way to filter on Enums using the finance and operations connector and still maintain delegation?

Helpful resources


Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!


Community Highlights

Check out whats happening in Power Apps


Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,320)