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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Adaptive Card in Outlo...
Power Automate
Unanswered

Adaptive Card in Outlook ( Using Choices Data From Excel Which is Stored in SharePoint )

(0) ShareShare
ReportReport
Posted on by 50

I Have one excel file in the share point in that file i have one worksheet where i have created one table. Where i have mentioned the Choices. After some research on adaptive card i have created one card .

The Code for the Card is Below:

{
"type": "AdaptiveCard",
"$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
"version": "1.0",
"body": [
{
"type": "TextBlock",
"text": "Files which You Have Send",
"id": "Heading"
},
{
"type": "TextBlock",
"text": "New TextBlock",
"id": "orderid"
},
{
"type": "Input.ChoiceSet",
"choices": [
{
"title": "Choice 1",
"value": "Choice 1"
},
{
"title": "Choice 2",
"value": "Choice 2"
}
],
"placeholder": "Placeholder text",
"id": "choiceSelect",
"isMultiSelect": true
},
{
"type": "Input.Text",
"placeholder": "Placeholder text",
"id": "reason"
}
],
"actions": [
{
"type": "Action.Http",
"title": "Action.Http",
"id": "response",
"method": "POST",
"url": "https://prod-21.centralindia.logic.azure.com:443/workflows/aada00e59cca4661b81868d9351e789a/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=mxtd5b_2Uwf5lPKxhCV8m1MqZx-0fzbuvxSy2etf1RY",
"body": "{\n\"choices\":\"{{choiceSet.value}}\",\n\"orderid\":\"{{orderid.text}}\",\n\"reason\":\"{{reason.value}}\"\n}",
"headers": [
{
"name": "Authorization",
"value": ""
},
{
"name": "Content-Type",
"value": "application/json"
}
]
}
]
}

 

 

After That I have created on flow Like:

Rushi_Chandak_0-1650951277143.png

In Compose Action I have Past The Code is:

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script type="application/adaptivecard+json">

{

"type": "AdaptiveCard",
"$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
"version": "1.4",
"body": [
{
"type": "TextBlock",
"text": "Approval For Orders",
"id": "Heading"
},
{
"type": "TextBlock",
"text": "@{first(outputs('List_rows_present_in_a_table')?['body/value'])}",
"id": "orderid"
},
{
"type": "Input.ChoiceSet",
"choices": @{variables('Choices')},

"placeholder": "Placeholder text",
"id": "choiceSelect",
"isMultiSelect": true
},
{
"type": "Input.Text",
"placeholder": "Placeholder text",
"id": "reson"
}
],
"actions": [
{
"type": "Action.Http",
"title": "Action.Http",
"id": "response",
"method": "POST",
"url": "https://prod-16.centralindia.logic.azure.com:443/workflows/13f6c09efa244485ad644e1d6c0d6b0f/triggers/manual/paths/invoke?api-version=2016-06-01&sp=%2Ftriggers%2Fmanual%2Frun&sv=1.0&sig=Lo_5rkKwf6sGA96dzG9d-zFJ5vaUa1qM43P6XqAArn0",
"body": "{\n\"Choices\":\"{{choiceSet.value}}\",\n\"orderid\":\"{{orderid.text}}\",\n\"reason\":\"{{reson.value}}\"\n}",
"headers": [
{
"name": "Authorization",
"value": ""
},
{
"name": "Content-Type",
"value": "application/json"
}
]
}
]
}
<body>
<button type="button" class="btn btn-primary">Primary</button>
</body>
</script>
</head>
</html>

 

............................

 

-->

Rushi_Chandak_1-1650951359765.png

 

 

As the Output i should get one card in the mail 

but in the mail i am gating the blank thing 

like:

Rushi_Chandak_2-1650951434046.png

 

 

 

Anyone Any Idea about this..

How to work on it>>

 

 

Categories:
I have the same question (0)
  • Rushi_Chandak Profile Picture
    50 on at

    I Have Tried Some Different Way Now But This Time I am Gating Output Like:

    Rushi_Chandak_0-1650975077140.png

     

  • Verified answer
    Rushi_Chandak Profile Picture
    50 on at

    I Get My Answer. Everything is ok just my outlook doesn't support the card. So now i have upgrade it now its working finely.. 

    Rushi_Chandak_0-1651407010075.png

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard