Lookup field in Modern Advanced Find Filter Criteria

(0) Share

Report

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?

All responses (4)

Answers (1)

Sort by

AndyArndt 110 on at

Like (0)

Report
Copy link

Link copied!

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 110 on at

Like (0)

Report
Copy link

Link copied!

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?
Verified answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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:

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:
AndyArndt 110 on at

Like (0)

Report
Copy link

Link copied!

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