Multiselect picklist - copy to text? - SOLUTION WORKS!!!

(0) Share

Report

Posted on by DawnK

I have a multiselect picklist that I want to show in an email in a process. I understand this cannot be done by simply selecting the field.

Can the picklist be copied to a plain text field using jscript or some other method? Does anyone have any sample code? THANKS!

I have the same question (0)

All responses (8)

Answers (1)

Torrado 1,270 on at

Like (0)

Report
Hello,

Please refer to these posts:

JavaScript

https://balugajjala.wordpress.com/2018/09/19/get-and-set-multiselect-option-set-field-values-through-javascript/

Power Automate

https://powerusers.microsoft.com/t5/Building-Flows/How-to-retrieve-an-option-set-label/td-p/547354

https://powerusers.microsoft.com/t5/Building-Flows/How-to-read-multioptions-set-from-dynamics-365/m-p/496889#M61792

Hope this helps you

Please mark the answer as verified if helpful. That will help others in future.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

Hi DawnK,

You can create an automated flow to copy Multiselect picklist to a plain text field automatically.

Here are steps. (For example, I have two fields in Account entity).

1.Go power automate(https://us.flow.microsoft.com/en-us/) to create an automated flow.

2.Set Trigger.

3.Add action 'Get a row by ID'

3.Add 'Compose' action.

you can copy following function and replace multiselect field logic name.

outputs('Get_a_row_by_ID')?['body/new_multiselectpicklist@OData.Community.Display.V1.FormattedValue']

4.Add 'Update a row' action

5.Test.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
DawnK 90 on at

Like (0)

Report

Leah - thank you so much for the detailed instructions! I sure do appreciate it!

Unfortunately I cannot get it to work. The text field is being filled with the text:

outputs('Get_a_row_by_ID')?['body/new_swapprovedswmultilookup@OData.Community.Display.V1.FormattedValue']

Any ideas what I did wrong? THANKS!

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi DawnK,

Not copying value i provided and paste it into in the 'compose' step directly.

You need firstly click '+Add dynamic content' and navigate to 'Expression' tab in the dialog.

Then you can paste value in it and click ok button

Finally, result should like following screenshot:

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
DawnK 90 on at

Like (0)

Report

Hi Leah, thanks for your response. My Compose does not offer the "Add Dynamic Content" so that's why I put the code there.

Was this reply helpful? Yes No
Julia Streatfield 25 on at

Like (0)

Report

Hi

Did you resolve this? I'm stuck at the same point - entering the text as per the example into the Expression box, returns invalid expression when I click OK.

Cheers

Jules

Was this reply helpful? Yes No
DawnK 90 on at

Like (0)

Report

Yes I did! Attached is my documentation. Hope it works for you!

Flow-to-copy-a-multi_2D00_select-field-to-a-text-field.docx

Was this reply helpful? Yes No
GBarkin 84 on at

Like (0)

Report

This is simple, and it works, thanks!

Was this reply helpful? Yes No