cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JVO
Regular Visitor

Filtering a gallery from a CDS Option Set Entity

I'm trying to filter a gallery to the value of a CDS Entity (Option Set).  It works great with a SharePoint list, but returns "this data is unsupported for evaluation" trying to use it in CDS.

 

Example:

 

When we move a work order from incomplete to complete, I want only the completed fields to show in a gallery.

 

Please help.

 

CDS

 
1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @JVO ,

Could you please share a bit more about the "Field Status" column? Is it a Option Set type column?

 

If the "Field Status" column is a Option Set type column, I think there is something wrong with the formula you provided. Please consider modify your Filter formula as below:

Filter(
       VOJOBS,
       If(
          Dropdown1.Selected.Value = "Completed",
          'Field Status' = [@'Field Status'].Completed,
          Dropdown1.Selected.Value = "InCompleted",
          'Field Status' = [@'Field Status'].InCompleted
       )
)

More details about Filter Entity records based on Option Set column, please check the following blog:

https://powerapps.microsoft.com/en-us/blog/option-sets-and-many-to-many-relationships-for-canvas-app...

 

Please take a try with above solution, check if the issue is solved.

 

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.

View solution in original post

2 REPLIES 2
v-xida-msft
Community Support
Community Support

Hi @JVO ,

Could you please share a bit more about the "Field Status" column? Is it a Option Set type column?

 

If the "Field Status" column is a Option Set type column, I think there is something wrong with the formula you provided. Please consider modify your Filter formula as below:

Filter(
       VOJOBS,
       If(
          Dropdown1.Selected.Value = "Completed",
          'Field Status' = [@'Field Status'].Completed,
          Dropdown1.Selected.Value = "InCompleted",
          'Field Status' = [@'Field Status'].InCompleted
       )
)

More details about Filter Entity records based on Option Set column, please check the following blog:

https://powerapps.microsoft.com/en-us/blog/option-sets-and-many-to-many-relationships-for-canvas-app...

 

Please take a try with above solution, check if the issue is solved.

 

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.

View solution in original post

It worked!  Thank you so much!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,979)