cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Highlighted
Continued Contributor
Continued Contributor

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
Highlighted
Continued Contributor
Continued Contributor

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

Highlighted
Helper I
Helper I

Re: How to filter on enumeration field?

Thanks Perumal,

 

It works fine.

 

Regards,

Szabolcs

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

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

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,917)