Filter Quert in List Records not workin for Lookup fields

[Ali_Nawaz]

Hi PowerUsers,

I am trying to list/get records from CDS "Leave Request" entity on the basis of a WorkerID.
WorkerId is a lookup field in "Leave Request" entity, making relation with "Worker" entity.

When i am applying the below filter query in List records action of CDS i'm getting the following error.

ERROR:

A binary operator with incompatible types was detected.
Found operand types 'Microsoft.Dynamics.CRM.cdm_worker' and 'Edm.Guid' for operator kind 'Equal'

I have tried passing the GUID without qoutes around it as well but still same issue.

Basically anydata type i am putting against the lookup column it is returning me the same error.
What datatype should be put againts lookup field to fetch data ?

Looking forward to swift and helpful response.
Regards,
Ali Nawaz

[mdevaney · Accepted solution]

@Ali_Nawaz 

You might want to consider posting this in the Flow Community as well.  They can teach you how to create an ODATA query over there.  IMHO, this is more of a Flow question than a PowerApps question and I feel like you'll get a quicker reponse over there.