cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Szabolcs
Level: Powered On

How to filter on enumeration field?

Hi there,

 

I have a custom entity (Event) with Title, Date and State fields. The State field's type is Enumeration of "Active/Inactive".

I want to filter my data to show only the active events.

What is the syntax of it?

 I set the Items property of the Gallery object to Filter('Event', Title = "xyz") works well, but Filter('Event', State = Active) nor Filter('Event', State = "Active") do not work.

 

Thanks,

Szabolcs

1 ACCEPTED SOLUTION

Accepted Solutions
Perumal
Level 10

Re: How to filter on enumeration field?

Try Text() function to convert the State enumeration to string and compare as below.

 

Filter(Event, Text(State)="Active")

 

 

View solution in original post

2 REPLIES 2
Perumal
Level 10

Re: How to filter on enumeration field?

Try Text() function to convert the State enumeration to string and compare as below.

 

Filter(Event, Text(State)="Active")

 

 

View solution in original post

Szabolcs
Level: Powered On

Re: How to filter on enumeration field?

Thanks Perumal,

 

It works fine.

 

Regards,

Szabolcs

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,315)