Customer experience | Sales, Customer Insights,...

Get Selected Option Set Labels as Text

(0) Share

Report

Posted on by EBMRay

905

Hello everyone!

I have created a Flow for Leads entity to get added data in sub-grid, and send the selected data to an email.

The problem I am facing is in the flow the selected option set is returning the result as a number instead of showing the label text of the added items.

Here are some screenshots:

87304.Capture.PNG 3487.Cap2.PNG

In those screenshots, I've mentioned above it's showing that 100000003 is the value of the "Item" text. As you see here it's returning the value of the option selected instead of showing the text "Item".

I have found this tutorial, and it's very helpful to find all the options set and its related details from the StringMap table.
But unfortunately, In this tutorial, it returns the selected option set as values, instead of showing the label text.

Here is the code to get the selected options set:

Here I am using the same script inside my flow:

0116.Flow.PNG

What I should change in the script to get the selected label as text and use it in my flow?

Any help will be greatly appreciated.

Thank you!

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

TylerS.Dev 729 on at

Like (0)

Report

Try changing your last condition from 'attributevalue' to 'value', attributevalue will get you the number from option set so you are actually comparing the value instead of label.

Was this reply helpful? Yes No
LeoAlt 16,331 Moderator on at

Like (0)

Report

Hi partner,

I found a simialr thread about how to use flow to get the option set label.

powerusers.microsoft.com/.../163269

flow.microsoft.com/.../

Hope it helps.

Best Regards,

Leo

Was this reply helpful? Yes No
EBMRay 905 on at

Like (0)

Report

Hello Tyler S,

I have changed the condition as you mentioned but as a result, nothing has been changed and it keeps showing the value of the item instead of text.

Was this reply helpful? Yes No
EBMRay 905 on at

Like (0)

Report

Hello LeoAlt,

Those threads are very helpful but unfortunately, I couldn't achieve my needs.

I have tried to use this expression that is mentioned in the solution:
item()?['_crd1f_MYOptionSetField_label'], as result it doesn't return any values.

Here is a screenshot:

As you see on those screenshots nothing is returned as the value after using the expressions I have mentioned.

Thanks for your support!

Was this reply helpful? Yes No
LeoAlt 16,331 Moderator on at

Like (1)

Report

Hi partner,

Thanks for your reply.

Since you are using Flow to archieve your requirement, I suggest that you could ask the question in flow community for more professional answers and helps.

powerusers.microsoft.com/.../MPACommunity

Happy new year!

Best Regards,

Leo

Was this reply helpful? Yes No
EBMRay 905 on at

Like (0)

Report

Thank you very much.

Happy new year!

Was this reply helpful? Yes No
Suggested answer

Linn Zaw Win 3,407 on at

Like (0)

Report

SmithBZ

With the latest update of Common Data Service (current environment) connector, we can now query the formatted values of supported field types such as lookup display name, option set value label, formatted date/time by using the OData.Community.Display.V1.FormattedValue property of the field in the expression.

linnzawwin.blogspot.com/.../get-lookup-display-name-and-option-set.html

Was this reply helpful? Yes No