Microsoft Dynamics 365 | Integration, Dataverse...

Choices (picklist) merge result show values, not labels

(0) Share

Report

Posted on by Thinkering

A flow generates a template words document with merged data.

The merged data, for choices (picklists), shows the values (numbers), and not the text labels. I need the text labels to show in the merged document.

What step do I add to the flow to convert the choices values to the choices labels? Or is there another solution?

I'm using Adobe Document Services API and it's pulling the data correctly/merging correctly, except that Dynamics 365 is feeding it the numbered values instead of the choices (picklist) text values.

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Partner,

The label of the Choice is needed in addition to the value, we need to expose the metadata of the Choice column to use throughout the flow.

I noticed that there is one 'Get a row by ID' action in your flow, you can check run history of the flow:

Then you can search the choice in the action:

It should be: fieldname@OData.Community.Display.V1.FormattedValue

Add one 'compose' action after 'Get a row by ID':

Get dynamic choice value from the 'Get a row by ID', then combine it with @OData.Community.Display.V1.FormattedValue, just like following screenshot:

Then you can use the output from the action to populate the word template.

You can refer the following link for more details:

https://www.encorebusiness.com/blog/power-automate-get-choice-label-metadata/

Was this reply helpful? Yes No
Thinkering 5 on at

Like (0)

Report
Copy link

Link copied!

Thank you Leah,

This work-around does function correctly. I do have about 100 choice fields I need to do this for in a single flow and if I understand correctly, for each I need to set 3 actions 'Compose, Initialize, and Set'. It's also a lot of work.

Is there not a way to have an action so that labels are retrieved for the entire table by default in the flow? As opposed to configuring this one value at a time?

-Daniel

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Adding these actions are optional process, it is intended to make it easier for you to understand the expressions of the choice field label.

In fact, you can use the final expression(outputs('Get_a_row_by_ID')?['body/customertypecode@OData.Community.Display.V1.FormattedValue') directly in the word template.

My test:

You can view that results are same:

Was this reply helpful? Yes No