Microsoft Dynamics 365 | Integration, Dataverse...

Search / Lookup option is not working for Products

(0) Share

Report

Posted on by Community Member

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.

All responses (8)

Answers (0)

Community Member on at

Like (1)

Report

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 3,407 on at

Like (0)

Report

RE: Search / Lookup option is not working for Products

Would you able to share the root cause and resolution with us?
Community Member on at

Like (1)

Report

RE: Search / Lookup option is not working for Products

Contacted with Microsoft support and they resolved my issue :)
Linn Zaw Win 3,407 on at

Like (0)

Report

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

Like (0)

Report

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 3,407 on at

Like (0)

Report

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

Like (0)

Report

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:

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

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 1,795 on at

Like (0)

Report

RE: Search / Lookup option is not working for Products

Hello there,

I just checked it and it works as expected:

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

regards