cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dallenap
Advocate I
Advocate I

Filter Based on Choice Column

Hi,

 

I'm struggling with something that should be super simple:

 

I have a table in CDS with a Choice datatype column.  I'd like to Filter the records in this table based on an ID and specific choice value.

 

So, the table has columns:

Type - Choice column with three choices: "option one"  "option two" and "option three"

OtherId - Text column; foreign key to another table

 

I'd like to perform the following:

Filter('Table Name', OtherId = varForeignKey && Type = "option two")

 

I can't figure this out.  I've tried the following:

Filter('Table Name', OtherId = varForeignKey && Type = Choices(Type.'option two').Value )
Filter('Table Name', OtherId = varForeignKey && Type = Filter(Choices(Type).Value = "option two"))

 

At this point I'm just hacking away at something that really shouldn't be this difficult.

 

Any help would be greatly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@dallenap 

It's difficult because it is not possible to use the optionsets from Dataverse in your formulas like that.

You would think this would be simple, but, although I don't work with dataverse that much, it is a challenge.

 

This thread offers a solution/workaround that might be of interest to you.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

3 REPLIES 3
RandyHayes
Super User
Super User

@dallenap 

It's difficult because it is not possible to use the optionsets from Dataverse in your formulas like that.

You would think this would be simple, but, although I don't work with dataverse that much, it is a challenge.

 

This thread offers a solution/workaround that might be of interest to you.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

Drrickryp
Super User
Super User

@dallenap 

Shane Young @Shanescows has a 20 min video on how he uses option sets in CDS here:  https://www.youtube.com/watch?v=1L633HIvNGE 

@RandyHayes Thanks!  I figured it was something simple.

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,144)