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 youI’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
One thought on “How to – Read OptionSet Labels from CDS/Dataverse Triggers or Action Steps in a Flow | Power Automate”