Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Guides forum / OOB Lookup filtering n...
Guides forum
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

OOB Lookup filtering not working for self referential lookup

Posted on by 5

Hello Folks,

I have a custom lookup field "Region (of type Team entity)" on the Team entity itself (i.e. have created a self-referential relationship (1: N) on Team entity).

And I also have a lookup field "Employee" of custom entity Employee on Team entity as shown below:

pastedimage1632424567231v2.png

Now, I want to filter Employee lookup based on the Region selected.

But in Related records filtering it does not show the Region Lookup field i.e. self-referential lookup, see screenshot below:

 pastedimage1632424550817v1.png

Note: I do not want to use custom javascript code.

 

Query:

Why I am not able to see the Region lookup (of type Team entity) in the Related records filtering list? Self-reference might be causing the problem, but anyone has an idea why this isn't working.

 

Any help will be appreciated.

 

Thank you

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans