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
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!