Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Lookup field isn't showing existing active records...

Posted on by 2,645

Hello,

I have entity A, and on this entity I have created a lookup field to entity B.  I have imported records into Entity B and I can see over 60 active records listed.  However, when I am on entity A and look at the lookup field that is pointing to Entity B, it doesn't show me any records.  What am I missing?

Thank you.

  • Suggested answer
    Paul_Owen Profile Picture
    Paul_Owen 2,027 on at
    RE: Lookup field isn't showing existing active records...

    Are you using the new Unified Interface, are you just clicking in the Lookup field? If so hit enter or click the magnifying glass instead, clicking in the lookup field will by default show recently used.

    Regards

    Paul

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Lookup field isn't showing existing active records...

    Hi partner,

    Open the form editor and open the lookup field properties, check if Only show records where: is enabled.

    pastedimage1586313343629v1.png

    If so, disable it.

  • USA80 Profile Picture
    USA80 2,645 on at
    RE: Lookup field isn't showing existing active records...

    Tried that it didn't work.  

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: Lookup field isn't showing existing active records...

    Hi partner,

    The lookup field has the view selector, so please change the view of the lookup field to all entities B.

    Taking the Account lookup field on the Contact form as an example, we click Change View to select the All Accounts view. Then we can see all the accounts.

    pastedimage1586253919372v1.png        pastedimage1586253966170v2.png

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans