Microsoft Dynamics 365 | Integration, Dataverse...

Can anyone suggest better approach for adding custom lookup on City/County/Country fields in "Address" Entity for Account/Contact

(0) Share

Report

Posted on by Dynamics 365 Sumit ...

110

Hi,

Account and Contact entity can store multiple addresses in Entity called Address.

But this address entity contains field like city , county or country in free text format.

We dont want user to enter free text into these fields rather we want to give lookup option so that user can select address from existing masters.

So we tried creating new custom lookup datatype field in Address entity but it did not allow us to create. Also Microsoft confirmed that Address entity is not customizable for adding custom relationship to any other entity apart from Contact, Account.

Then i went through couple of URL and found that some people suggested to use javascript code to build some custom search on Text field.

So can anyone suggest better approach that we can follow , we don't want to create new custom entity for address , we wanted to use existing address entity only.

Below are couple URL that suggest creating custom lookup view using javascript but i think these custom lookup view can be associated with lookup field only . Am i right ?

https://mscrmtutorials.com/create-custom-lookup-view-using-javascript-in-d365-mscrm/

http://a2zcrmstuff.blogspot.com/2015/10/add-customview-dynamically-to-lookup.html

https://www.encorebusiness.com/blog/dynamics-crm-address-entity/

Thanks

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Steven RH JIANG on at

Like (0)

Report

Hi Sumit,

You're right. I don't think you can use js to create custom lookup view for city/county/country fields inside address entity.

There are lots of limitation with address entity.

To achieve your goals, you might consider to use a custom address entity, or add city/county/country lookup fields in parent entities, i.e. contact/account.

Was this reply helpful? Yes No
Dynamics 365 Sumit ... 110 on at

Like (0)

Report

Hi Steven,

Yes we also gave thought on creating new custom entity for Address but we want to use existing entity for address so that we can get any future update from Microsoft on existing entity.

About creating fields in Account entity for address that we dont want to do because we want to store N number of address against Account .

Is it possible to add some custom intelligance on Text field like by writing some javascript which will suggest data from City or State master in lookup format.

Thanks

Was this reply helpful? Yes No
Steven RH JIANG on at

Like (0)

Report

Hi Sumit,

Sorry for getting back to you late.

As far as i know, it's not feasible to add custom intelligence on Text field. It's the limitation inside Dynamics CRM.

Was this reply helpful? Yes No