How to work with optionset lables in Power Automate? – Power Flow

Greate post form Thomas (CRM Addicted)

http://crmaddicted.blogspot.com/2020/01/working-with-optionset-lables-in-power.html

Posts on Power Platform Forum:

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/I-want-using-Option-Set-field-choose-label-value/m-p/162486

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

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/I-want-using-Option-Set-field-choose-label-value/m-p/162486

Lin post:

https://linnzawwin.blogspot.com/2020/07/get-lookup-display-name-and-option-set.html
https://powerusers.microsoft.com/t5/Building-Flows/How-to-retrieve-an-option-set-label/td-p/547354

The full expression is Triggeroutputs()?[‘body/_leadqualitycode_label’].

  The main issue I have is that this will only work with the CDS connector and not the CDS (current environment) connector as the label value is not returned in the JSON for the CDS (current environment) connector.  I hope this is fixed in the future as the current environment connector provides more Actions and is more efficient for processing lists of record.

If you wanted to do this from a different record than the record that triggered the flow then use the Get Record action and then the following expression Outputs(‘Get_record’)?[‘body/_leadqualitycode_label’] where ‘Get_record’ is the name of the action.

Hope this helps someone.

Other links

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/I-want-using-Option-Set-field-choose-label-value/m-p/162486
https://powerusers.microsoft.com/t5/Microsoft-Dataverse/I-want-using-Option-Set-field-choose-label-value/td-p/162486
https://powerusers.microsoft.com/t5/Building-Flows/Option-Set-in-MS-Automate-flow/td-p/499217
https://www.powerautomatetraining.co.uk/post/how-to-retrieve-cds-option-set-label-name

Leave a Reply

Your email address will not be published. Required fields are marked *