cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Filtering results of the List Records (Common Data Service)

I have a flow with a step to get a list of records from an entity defined in Common Data Service, I want to filter the results based on another filed I am passing in my flow. But I can't figure out what the left side (entity property) of my equal should be. I have tried passing the entity name.field name, tried putting quotes around it, tried brackets, tried just using the display name - nothing seems to work. Does anyone know the syntax for the odata filter property on the CDS - List Records action?

Here are the messages I am getting for each:

 

"message": "Could not find a property named 'GroupID' on type 'Microsoft.Dynamics.CRM.cr8e0_cms_groups'.",
"message": "Could not find a property named 'cr8e0_GroupID' on type 'Microsoft.Dynamics.CRM.cr8e0_cms_groups'.",
"message": "The left side of the \"Equal\" operator must be a property of the entity.",
 
My entity name is CMS_Groups
My field name is GroupID (display name)  cr8e0_GroupID field name.
groupid.GIF
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate II
Advocate II

Re: Filtering results of the List Records (Common Data Service)

Finally figured out that the name is case sensitive. Must type field name in lower case!

View solution in original post

1 REPLY 1
Highlighted
Advocate II
Advocate II

Re: Filtering results of the List Records (Common Data Service)

Finally figured out that the name is case sensitive. Must type field name in lower case!

View solution in original post

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

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

Users online (3,982)