Read OptionSet Labels from CDS/Dataverse Triggers or Action Steps in a Flow | Power Automate


Triggers triggeroutputs()?[‘body/_optionsetname_label’]

Get a row by id outputs(‘action_name’)?[‘body/optionsetname@OData.Community.Display.V1.FormattedValue’]

List Rows – items(‘action_name’)? [‘body/optionsetname@OData.Community.Display.V1.FormattedValue’]

D365 Demystified

Retrieving OptionSet Labels from CDS data in a Cloud Flow / Power Automate / Flow is an extra step than just picking from the Dynamic Values. Check this post!!

Scenario

While working with data that is either a result of a Dataverse Trigger (on Create/Update) or Action like (Get record, list record), the OptionSet fields from CDS/Dataverse return the Values of the OptionSet instead of the Text Labels –

  1. Let’s say this is the OptionSet in Dynamics
  2. And when you pick the OptionSet field from CDS either from an Action or a Trigger like this
    Let’s say I’m capturing this in a variable to show you

    I’m storing this in a variable for this example to show you

  3. I’ll capture the Value of the OptionSet i.e. the Value part

    Result –

  4. What needs to be displayed is the Label of the OptionSet! Let’s see how we can do this –

View original post 660 more words

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

One thought on “Read OptionSet Labels from CDS/Dataverse Triggers or Action Steps in a Flow | Power Automate”

Please share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.