Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Sales forum / Lookup field in Modern...
Sales forum
Answered

Lookup field in Modern Advanced Find Filter Criteria

(0) ShareShare
ReportReport
Posted on by AndyArndt 110

When specifying criteria for a lookup field in classic advanced find, the "Lookup Records" pop up allowed the user to select which view to use and those views may contain columns that help choose the correct record. In Modern Advanced Find, it appears that when you are searching for a record in a lookup column, it only shows the name property of those records and you cannot get to a more advanced/useful search experience within that lookup field criteria. Anyone have an idea how to get more robust searching within lookup columns in Modern Advanced Find?

Categories:
Other
  • AndyArndt Profile Picture
    AndyArndt 110 on at
    RE: Lookup field in Modern Advanced Find Filter Criteria

    Leah,

    Thank you for taking the time to respond, I marked your answer as verified. I suspected that this was a limitation, but wanted to confirm with other users and admins. I think this is a big step backward because the column displayed in the lookup is not always unique per row. We have many queries where I will need to continue using classic Advanced Find because of this limitation. I found a suggestion on the ideas site from June, 2022 that is describing the same issue, so I voted for that. Link is here: experience.dynamics.com/.../

    Thanks,

    Andy

  • Verified answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: Lookup field in Modern Advanced Find Filter Criteria

    Hi AndyArndt,

    Unfortunately, the lookup column filter in Modern Advanced Find can't switch to specific view, which is by-design.

    You can populate value and search, then it will be shown:

    3652.pastedimage1667356444910v2.png

    If you insist on getting the feature in the Modern Advanced Find, maybe you can create a new idea through the below URL, then ask your colleagues to raise up the votes.

    Ideas (dynamics.com

    Our product team has direct visibility of these ideas and they will implement it on the basis of the highest number of votes received.

    ===========

    Or you can use old Advanced Find if you must need to select views when filter lookup column:

    Go to Settings > Advanced Settings, then you click 'Advanced Find' button in current page, then you can get old Advanced Find window:

    0647.pastedimage1667355152812v1.png

  • AndyArndt Profile Picture
    AndyArndt 110 on at
    Lookup field in Modern Advanced Find Filter Criteria

    When specifying criteria for a lookup field in classic advanced find, the "Lookup Records" pop up allowed the user to select which view to use and those views may contain columns that help choose the correct record. In Modern Advanced Find, it appears that when you are searching for a record in a lookup column, it only shows the name property of those records and you cannot get to a more advanced/useful search experience within that lookup field criteria. Anyone have an idea how to get more robust searching within lookup columns in Modern Advanced Find?

  • AndyArndt Profile Picture
    AndyArndt 110 on at
    Lookup field in Modern Advanced Find Filter Criteria

    When specifying criteria for a lookup field in classic advanced find, the "Lookup Records" pop up allowed the user to select which view to use and those views may contain columns that help choose the correct record. In Modern Advanced Find, it appears that when you are searching for a record in a lookup column, it only shows the name property of those records and you cannot get to a more advanced/useful search experience within that lookup field criteria. Anyone have an idea how to get more robust searching within lookup columns in Modern Advanced Find?

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

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

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Community Spotlight for September 2024

Kudos to Mohana Yadav!

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,353 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,251 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans