Using IN Operator for lookup field in Filter

[GReddy]

Hi All,

I get an error message when I try with IN operator with lookup column using Dataverse tables.

I have two tables Agreements and WorkOrder .  Agreements table having 1000+ records and agreement column is lookup datatype in workorder table.

Created  colWorkOrder collection for WorkOrders and collection having 10 records . I am trying to create another collection for agreement and  filter agreement table data  based on colworkorder and I get below error message.

Even I tried with primary column(Schedule number) of agreements but I get same error message.

Collect(leaseList, Filter(Agreements, Agreement in colWorkOrder.Agreement));

// msdyn_agreementid( Agreement -display name) - Unique Identifier in Agreements

How do I filter Table2 data based on table1 data?

Thank you in advance

Regards,

GR

[Drrickryp]

@GReddy 

Does Collect(leaseList, Filter(Agreements, Agreement = colWorkOrder.Agreement)) work?

[GReddy]

It doesn't work. I get type conversion error message.

Regards,

GR

[jonckhje]

Did you ever manage to solve this? I'm facing the same challenge currently...