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
Users Online
Currently online: 177 members 5,940 guests
Please welcome our newest community members: