Customer experience | Sales, Customer Insights,...

How to make a dropdown list from text field in dynamic CRM

(0) Share

Report

Posted on by MalikDanish

Hi I have a requirement that I have a course Column in my entity which i want to make as simple single Line Text field , but when someone enter the course like I entered Mathmatics so when next time i open up the form this field should appear as dropdown and have the values which i have added previously mathmatics in this case , and if i add physics now and on next time when i open up the form i should be able to see both Mathmatics and physics and so on....

can someone assists me how to achieve that in dynamic365 CRM

I have the same question (0)

All responses (6)

Answers (0)

Esteban Coto Alfaro 722 on at

Like (0)

Report

RE: How to make a dropdown list from text field in dynamic CRM

Hello,

A dropdown previously configured with its respective options is possible, however a dropdown from a text field is not possible.

You could: Create a table (entity) where users can create records with the necessary Subject as input.

i.e. Mathematics, Physics

Thanks!

Community Support Team - Esteban

If this Post helps, then please consider Accept as solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Suggested answer

Fubar 2,756 on at

Like (0)

Report

RE: How to make a dropdown list from text field in dynamic CRM

You could do it, but you would have to write a PCF Control to do it (or a Web Resource with custom JS)

But, would question why you wouldn't just use a Lookup and give the user privileges to create new items..

Was this reply helpful? Yes No
MalikDanish on at

Like (0)

Report

RE: How to make a dropdown list from text field in dynamic CRM

Basically I do not want an admin to have the control to add new items and use it as dropdown I want what ever the user type and saved for every next time it would be available into the list .

Was this reply helpful? Yes No
Sandesh G 30 on at

Like (0)

Report

RE: How to make a dropdown list from text field in dynamic CRM

Hi MalikDanish,

In this case you can have separate Entity to hold the course values with all possible values you have beforehand.

Next step would be to have singleline field on your form, with autocomplete and source as lookup to above entity.

On-change of above field you can have a js to check if it's new or existing value, and store in some temp variable.

Later you can write plug-in or MS-flow(powerAutomate) to insert if it's new value based on above temp variable.

Was this reply helpful? Yes No
Suggested answer

Inogic 623 on at

Like (0)

Report

RE: How to make a dropdown list from text field in dynamic CRM

Hi,

To achieve your requirement, you need to write custom code (plugin) and create two fields - 1. Single line text (Subject_String) 2. Option set (Subject). Option set value will be the final value for the subject.

Users can enter a value in the text field or Option set. If the user selected an option in the option set then no action needed, but when the user entered the value in a text field, in background code will trigger and add an option as a text field value to the option set and clear the text field value.

Code should trigger on record save and update of the subject text field.

In code, check if text field value is available in the option set then set the option as the selected value. Exit code.

If text field value contains data and entered text does not exist in option set then add logic to add new option as text field value to option set. Also, set the newly added option as the selected value for the option set and then clear the text field value.

You can refer to the below link to add value to the options set:

https://docs.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.messages.insertoptionvaluerequest?view=dynamics-general-ce-9#examples

Hope this helps!

Was this reply helpful? Yes No
MalikDanish on at

Like (0)

Report

RE: How to make a dropdown list from text field in dynamic CRM

A dropdown previously configured with its respective options is possible, however a dropdown from a text field is not possible.

I can have a dropdown but I would like to allow user to populate values in it.

Was this reply helpful? Yes No