Skip to main content

Notifications

Announcements

No record found.

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

Search / Lookup option is not working for Products

Posted on by Microsoft Employee

Hi,

 
I'm currently working on transition to Unified Interface (2020 release wave 1). I noticed that the search functionality for products is not working as it should.
I would expect that if I start to type up the name of a product the list of items start to change (will be filtered) when I have a look up field. So for example if I type "abc*" it shows only products which starts with "abc". However in my case no update happens. I can see that the characters I'm typing appears in bold in the list if there is a match but it's not filtered. I tried to click on magnifying glass and/or press enter but nothing changes. This search is not working either in Sales app neither in Customer Service app. Also the issue appears in every view of products.
 
I also tried to search a product in the entity view but independently from what I search for nothing changes. So even I search for a product which exist even for one which doesn't, it keeps showing all the products in the view.
 
This function is working fine in web client application. Also it works for every other entity (Accounts, Contacts, etc.) and having trouble only with products.
 
Have you encountered something similar? If yes, how did you overcome/resolve the issue. Your assistance is very much appreciated.
Many thanks.
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Search / Lookup option is not working for Products

    Hi,

    I received this from Microsoft team as root of my issue:

    "Post investigating the issue on support instance, we have identified that the cause of the Issue is due to the customization of a view "Quick Find All Products" on Products entity.

    In this view following filter condition is missed

    <filter type="or" isquickfindfields="1">

      <condition attribute="productnumber" operator="like" value="{0}" />

       <condition attribute="name" operator="like" value="{0}" />

    </filter>"

    Once I added these missing lines everything was working fine.

    Kind Regards,

    Nikki

  • Linn Zaw Win Profile Picture
    Linn Zaw Win 3,405 on at
    RE: Search / Lookup option is not working for Products

    Would you able to share the root cause and resolution with us?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Search / Lookup option is not working for Products

    Contacted with Microsoft support and they resolved my issue :)

  • Linn Zaw Win Profile Picture
    Linn Zaw Win 3,405 on at
    RE: Search / Lookup option is not working for Products

    In that case, it is best to raise a support ticket with Microsoft.
    admin.powerplatform.microsoft.com/support

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Search / Lookup option is not working for Products

    I created a new form and lookup was added without any filtering but it still does not work.

  • Linn Zaw Win Profile Picture
    Linn Zaw Win 3,405 on at
    RE: Search / Lookup option is not working for Products

    Do you have any lookup filtering configured or any JavaScript for that lookup field?

    If there any, can you try to create a new form with no customisation and add the Product lookup field to try?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Search / Lookup option is not working for Products
    Hi,
     
    Thank you very much your quick response. I tested it in opportunities within the sales app as you did and here is my result:
    5633.MicrosoftTeams_2D00_image.png

    I'm getting the same result everywhere where I need to work with products:
     
    pastedimage1592381576478v2.png

    I also tried in different browser: Chrome, Firefox and Edge. None of them works. However I am not sure about what you mean by "new trial". Could you please tell me and I can check in that one as well?
     
    It is an interesting issue because as I mentioned the lookup works for everything else e.g. accounts, contacts, etc.
     
    Many thanks.
  • Suggested answer
    Johao Larios Profile Picture
    Johao Larios 1,795 on at
    RE: Search / Lookup option is not working for Products

    Hello there,

    I just checked it and it works as expected:

    pastedimage1592365990569v1.png

    I test it in opportunities within the sales app.  have you tried in a new trial or in other browsers?

    regards

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

Product updates

Dynamics 365 release plans