How to get submitted values from your Choices/optionset column in Dataverse

Use Compose and combine with append to string variable

I’d like to explain how you can get the value for your dropdown.

There is a difference between the display name, and the actual name of that value. Dataverse often uses @OData.Community.Display.V1.FormattedValue instead of the previous new_value_label.

In your Power automate flow, either run the flow and check the body, or add a Compose step after your Get Items/Update Item etc. step for Dataverse.

  • In your Compose, add the value of your dataverse action.

  • Run your flow

  • Copy the contents of your compose into notepad

    /posts/collectvalues-choiceoptionsets/compose%20step.png
    Compose example
  • Check out the values for the column you want, for example I have a simple dropdown for City.

    "cr215_city@OData.Community.Display.V1.FormattedValue": "New York"
    "cr215_city": 941200000
    
  • These 2 entries represent the dataverse value for the choice/optionset, and the actual name.

  • In your flow, copy the selected step

  • Paste in notepad and it will look similar to this: @{items('Apply_to_each')?['cr215_city']}

  • Remove the @{, and the } at the end.

  • Modify the cr215_city into cr215_city@OData.Community.Display.V1.FormattedValue

  • Paste into the expression area, where you want the value to come into.

/posts/collectvalues-choiceoptionsets/old.png
Old
/posts/collectvalues-choiceoptionsets/new.png
New
  • Run your flow and it should display the correct name/value for you.

If not, check if it’s correct based on your output from the dataverse action.