web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Search / Lookup option is not working for Products

(0) ShareShare
ReportReport
Posted on by

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.
I have the same question (0)
  • Suggested answer
    Johao Larios Profile Picture
    1,795 on at

    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

  • Community Member Profile Picture
    on at
    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.
  • Linn Zaw Win Profile Picture
    3,407 on at

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

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

  • Linn Zaw Win Profile Picture
    3,407 on at

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

  • Community Member Profile Picture
    on at

    Contacted with Microsoft support and they resolved my issue :)

  • Linn Zaw Win Profile Picture
    3,407 on at

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

  • Community Member Profile Picture
    on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
iampranjal Profile Picture

iampranjal 41

#2
Martin Dráb Profile Picture

Martin Dráb 38 Most Valuable Professional

#3
Satyam Prakash Profile Picture

Satyam Prakash 35

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans