Unanswered

Populating word template with flow - Option Set showing value not label

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I am populating a word template from data within Dynamics crm via MS Flow. I have a optionset field which is bringing through the 'Value of the option set :(Ownershipcode) but I want to bring through the _ownershipcode_label

Can someone please advise on the steps I should take please? (Fairly New to flow)

Thank you in advance

value I want.PNG

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

MJain 2,450 on at

Like (0)

Report

Hi @Anonymous ,

You are already getting the value as per your screenshot. What is it missing here ?

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

The word template is showing the number string (ownership code) rather than the value (ownershipcod_label)…
its a option set field .

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Are you getting the values from a Get Item action step. If it is then use the below expression

item()?['_ownershipcode_label']

Label names don't appear as dynamic selection. You need to copy the above expression and paste under the expression text box.

Please see below

Thanks

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous

If the below suggestion doesn't work then try the below expression. Suppose your previous step Get method where it retrieve the record details is called 'Get_record' then use the outputs('Get_record') and reference the field name.

outputs('Get_record')?['body/_ownershipcode_label']

Thanks

Was this reply helpful? Yes No
Tsingh1 5 on at

Like (0)

Report

Thank you - the get records function worked with a tweak 🙂

Thanks again !

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous

Thanks for the update. If your problem has solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thanks

Was this reply helpful? Yes No