Showing results for 
Search instead for 
Did you mean: 
New Member

Filter a Dataverse table based on a collections look up column

I have two datasources
okrs - Dataverse table 

PerformancePlanDetails - Collection that has a lookup column called okr_id that references the okrs table. 

I'm trying to filter the records in the okrs table based on the the list of records in PerformancePlanDetails

These are the formulas I've tried:
Filter(okrs, id in - it gives me a delegation warning
Filter(okrs, id in PerformancePlanDetails.okr_id).id - it says incompatible data types between a text value and record

Any help would be appreciated!

Super User
Super User


Use = instead of "in". 

I still get the same warnings even if I use "="

Helpful resources

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,861)