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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Create a dynamic adapt...
Copilot Studio
Unanswered

Create a dynamic adaptive card from sharepoint lists.

(0) ShareShare
ReportReport
Posted on by Alexa2022 58

Evening All, 

I have fairly recently discovered PVA web based site and am trying to create a “simple” dynamic adaptive contact card using info from a Sharepoint list. 

I have heard that I need to create variables first using a PA flow and insert those variables in my card. How do I insert variables into an adaptive card. I’m familiar with the Microsoft developer portal app. 

Thanks 

Categories:
General topics
I have the same question (0)
  • Expiscornovus Profile Picture
    Expiscornovus 33,874 Most Valuable Professional on at

    Hi @Alexa2022,

     

    You should be able to select/use the dynamic content fields like variables in your adaptive card json.


    Below is an example article which demonstrates the usage of Link to item field in an adaptive card:

    https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Send-an-Adaptive-Card-to-Microsoft-Teams-using-Power-Automate/ba-p/1512206

     

  • AJ-02050920-0 Profile Picture
    AJ-02050920-0 2 on at
    Hi,

    Suppose you wanna add a dropdown in adaptive card, whose data is dynamically coming from a SharePoint list.
    Example - there's a column name Team in SharePoint List which you you want to use.
    You can follow these steps –
    1. To fetch the Team/Technology name from SharePoint list, click on “+ (Add Node)” sign -> Add an action -> New Power Automate Flow

     
    It will open Power Automate in a new window.
     To create the flow please follow these steps -
    • Add Get items node. Add SharePoint site address and select the list name. Also add Order By to sort the team/technology name in Alphabetical order.
    • ​​​​​​​Use built-in Select operation to extract the value of Title and ID.



     
    • ​​​​​​​Use compose with fx – string(body('Select'))

     
    • ​​​​Initialize a string variable.
    • ​​​​​​​Use another compose with fx- concat(variables('q'),outputs('Compose'),'}')

    • ​​​​​​​Respond compose’ s value as output.
     
    • After publishing the flow come back to the topic and you will see the new created flow in the list. Click on it.

     
    1. Click on “+ (Add Node)” sign -> Variable Management -> Parse Value
    Schema -
    kind: Record
    properties:
      items:
        type:
          kind: Table
          properties:
            title: String
            value: String


     
    1. Click on “+ (Add Node)” sign -> Variable Management -> Set a variable value
    Fx –ForAll(Topic.Var1.items, { title: ThisRecord.title, value: ThisRecord.title})
    1. Click on “+ (Add Node)” sign -> Ask with adaptive card
    2. Click on adaptive card and use the following formula-
    {
      type: "AdaptiveCard",
      body: [
        {
          type: "TextBlock",
          size: "Medium",
          weight: "Bolder",
          text: "To Raise A Request/Incident",
          color: "Accent"
        },
        {
          type: "TextBlock",
          text: "Please select the name of the team or technology so that I can provide you the Service Now Application and Assignment Group.
          ",
          wrap: true
        },
       
        {
          type: "Input.ChoiceSet",
          choices: Topic.InputChoiceSet,
          placeholder: "Team/Technology",
          id: "ch1",
          label: "Select your Team/Technology"
        },
        {
          type: "ActionSet",
          actions: [
            {
              type: "Action.Submit",
              title: "View Response",
              style: "positive",
              id: "btn1"
            }
          ]
        }
           
      ],
      '$schema': "http://adaptivecards.io/schemas/adaptive-card.json",
      version: "1.3"
    }




     

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

News and Announcements

Welcome to the Power Platform Communities

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!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 895

#2
Vish WR Profile Picture

Vish WR 337

#3
Haque Profile Picture

Haque 276

Last 30 days Overall leaderboard

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Block PII/PCI in Copilot Studio agent user prompt

Product updates

Microsoft Power Platform Community release plans