Skip to main content

Notifications

Announcements

No record found.

Service | Customer Service, Contact Center, Fie...
Suggested answer

Filtration on look up field is not available.

Posted on by 65

Hello, 

We need to search on the look up field by Project number (custom entity). Out of the box it is possible to look for the record on the look up field only by name of the record. I changed the view and added number, so it shows the number when I change the view but I still can't type number and find the record. Any ideas how to do it with out of the box solution?  Thank you 

  • Torrado Profile Picture
    Torrado 1,270 on at
    RE: Filtration on look up field is not available.

    Hello Elena,

    Do you need additional help? Any news?

    If it's already clarified, and the answer was helpful, could you please mark it as verified? That will help others in future.

    Thanks

  • Suggested answer
    Torrado Profile Picture
    Torrado 1,270 on at
    RE: Filtration on look up field is not available.

    Hello Elena,

    When entering a value into a lookup field and the button or lookup icon is pressed, a search is carried out on the related item’s data using the Find columns defined in the related entity’s Quick Find View.

    In your case, you would need to add the "Project number" field to the related entity's Quick Find View -> Add Find Columns.

    You can follow the steps described in this article: https://powerobjects.com/dynamics-365/lookup-and-search-views/ 

    Please mark the answer as verified if helpful.

Under review

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

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans