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’]
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 –
- Let’s say this is the OptionSet in Dynamics

- 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

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

Result –

- 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
Discover more from Nishant Rana's Weblog
Subscribe to get the latest posts sent to your email.

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