web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to: Dataverse Simp...
Power Automate
Answered

How to: Dataverse Simple Choice field value in adaptive card

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I'm trying to an adaptive card to our Team group. In the JSON I include dynamic content as:

Patriarch3257_0-1692710622606.png

However, when it arrives in Teams it is displaying the index not the value:

Patriarch3257_1-1692710691142.png

Unlike a SharePoint field, I only get one option to pick in the dynamic content UI:

Patriarch3257_2-1692710750225.png

What am i supposed to do differently to display the user friendly value?

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I have been trying to use the following expression to get the value:

     

    body('When a row is added, modified or deleted')?['_rar_employmentstatus_label']

     

    But it doesn't like the expression.

     

  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Please use below expression:

    triggerOutputs()?['body/employmentstatus@OData.Community.Display.V1.FormattedValue']

    you can find the logical name in column settings and put it inside the expression.

     

    Best regards,

     
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I get this error:

    Patriarch3257_0-1692791083668.png

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I found the solution to the error. The expression got pasted at the top of the card json AND in the location where it was supposed to be.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I still do not see the value in the adaptive card. No errors, it is simple blank.

    This is what the card looks like:

    {
     "type": "AdaptiveCard",
     "$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
     "version": "1.4",
     "body": [
     {
     "type": "TextBlock",
     "text": "Remote Access Request",
     "wrap": true,
     "weight": "Bolder",
     "size": "Large"
     },
     {
     "type": "ColumnSet",
     "columns": [
     {
     "type": "Column",
     "width": "stretch",
     "items": [
     {
     "type": "TextBlock",
     "text": "Requester",
     "wrap": true,
     "weight": "Lighter",
     "size": "Small"
     },
     {
     "type": "TextBlock",
     "text": "@{outputs('Get_user_profile_(V2)')?['body/displayName']}",
     "wrap": true
     },
     {
     "type": "TextBlock",
     "text": "Employee Status",
     "wrap": true,
     "size": "Small",
     "weight": "Lighter"
     },
     {
     "type": "TextBlock",
     "text": "@{triggerOutputs()?['body/rar_employmentstatus@OData.Community.Display.V1.FormattedValue']}",
     "wrap": true
     },
     {
     "type": "TextBlock",
     "text": "Email",
     "wrap": true,
     "weight": "Lighter",
     "size": "Small"
     },
     {
     "type": "TextBlock",
     "text": "@{outputs('Get_user_profile_(V2)')?['body/mail']}",
     "wrap": true
     },
     {
     "type": "TextBlock",
     "text": "Manager",
     "wrap": true,
     "size": "Small",
     "weight": "Lighter"
     },
     {
     "type": "TextBlock",
     "text": "@{outputs('Get_manager_(V2)')?['body/displayName']}",
     "wrap": true
     }
     ]
     },
     {
     "type": "Column",
     "width": "stretch",
     "items": [
     {
     "type": "TextBlock",
     "text": "User ID",
     "wrap": true,
     "weight": "Lighter",
     "size": "Small"
     },
     {
     "type": "TextBlock",
     "text": "@{triggerOutputs()?['body/rar_userid']}",
     "wrap": true
     },
     {
     "type": "TextBlock",
     "text": "Work Phone",
     "wrap": true,
     "weight": "Lighter",
     "size": "Small"
     },
     {
     "type": "TextBlock",
     "text": "@{triggerOutputs()?['body/rar_workphone']}",
     "wrap": true
     },
     {
     "type": "TextBlock",
     "text": "Device Type",
     "wrap": true,
     "size": "Small",
     "weight": "Lighter"
     },
     {
     "type": "TextBlock",
     "text": "@{triggerOutputs()?['body/rar_devicetype']}",
     "wrap": true
     }
     ]
     }
     ]
     },
     {
     "type": "TextBlock",
     "text": "Business Use",
     "wrap": true,
     "size": "Small",
     "weight": "Lighter"
     },
     {
     "type": "TextBlock",
     "text": "@{triggerOutputs()?['body/rar_notes']}",
     "wrap": true
     },
     {
     "type": "ActionSet",
     "actions": [
     {
     "type": "Action.Submit",
     "title": "Approve",
     "id": "actionApprove"
     },
     {
     "type": "Action.Submit",
     "title": "Reject",
     "id": "actionReject"
     }
     ]
     }
     ]
    }
  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I got it to work. After looking through the output of the trigger I found that there was a field that held the value I needed. This is the expression I used.

     

    triggerOutputs()?['body/_rar_employmentstatus_label']

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 304

#2
David_MA Profile Picture

David_MA 245 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 243 Most Valuable Professional

Last 30 days Overall leaderboard