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 / Displaying multiple re...
Copilot Studio
Suggested Answer

Displaying multiple records in Copilot Studio using Adaptive card

(1) ShareShare
ReportReport
Posted on by GS-08070407-0 7
Hello Community,
 
Could anyone help me out with below mentioned scenario.
 
I’m seeking your guidance on a use case I’m currently working on.

I’m building a Copilot Studio solution where the user initially provides an input — an item number. This input is then passed to a Power Automate agent flow, where I filter a SharePoint list based on the provided item number.

The flow returns multiple records from the SharePoint list, which I need to send back to Copilot Studio and display to the user in a tabular format using Adaptive Cards.

While I’m able to successfully send and display a single record, I’m facing issues when handling multiple records. When I pass the collection of items back to Copilot Studio from the flow, the variable ends up as a plain string rather than a properly structured JSON object, which prevents me from displaying the data as intended in the adaptive card.
 
In agent flow the json will be like this:
 
 
    "body": [
        {
            "Currency": "Kr.",
            "Distributor": null,
            "Itemtypenum": "1803895",
            "Unitprice": "42.97000",
            "Website": "DigiKey"
        },
        {
            "Currency": "Kr.",
            "Distributor": null,
            "Itemtypenum": "1803895",
            "Unitprice": "43.800",
            "Website": "Farnell"
        },
        {
            "Currency": "Kr.",
            "Distributor": "element14 Asia-Pacific",
            "Itemtypenum": "1803895",
            "Unitprice": "38.0764",
            "Website": "FindChips"
        }

 
And while passing the same to Copilot studio if it is a single record it is taking the values but if multiple records are coming i was not able to figure this out how i can display dynamic data in tabular form in adaptive card.
 
In Coplit studio the json output is coming like below:
 
[{"Currency":"Kr.","Distributor":null,"Itemnum":"1803895","Unitprice":"42.97000","Website":"DigiKey"},{"Currency":"Kr.","Distributor":null,"Itemnum":"1803895","Unitprice":"43.800","Website":"Farnell"},{"Currency":"Kr.","Distributor":"element14 Asia-Pacific","Itemnum":"1803895","Unitprice":"38.0764","Website":"FindChips"},{"Currency":"Kr.","Distributor":"Onlinecomponents.com","Itemnum":"1803895","Unitprice":"40.951","Website":"Octopart"},{"Currency":"Kr.","Distributor":"DigiKey","Itemnum":"1803895","Unitprice":"42.641","Website":"Octopart"},{"Currency":"Kr.","Distributor":"DigiKey","Itemnum":"1803895","Unitprice":"41.8886","Website":"FindChips"},{"Currency":"Kr.","Distributor":"Mouser","Itemnum":"1803895","Unitprice":"42.114","Website":"Octopart"},{"Currency":"Kr.","Distributor":"DigiKey","Itemnum":"1803895","Unitprice":"6,221.7606","Website":"FindChips"},{"Currency":"Kr.","Distributor":"Verical","Itemnum":"1803895","Unitprice":"44.663","Website":"Octopart"},{"Currency":"Kr.","Distributor":"Mouser Electronics","Itemnum":"1803895","Unitprice":"49.8004","Website":"FindChips"},{"Currency":"Kr.","Distributor":"Arrow Electronics","Itemnum":"1803895","Unitprice":"44.663","Website":"Octopart"},{"Currency":"Kr.","Distributor":"Onlinecomponents.com","Itemnum":"1803895","Unitprice":"2,778.6778","Website":"FindChips"},{"Currency":"Kr.","Distributor":"element14 APAC","Itemnum":"1803895","Unitprice":"38.839","Website":"Octopart"},{"[{"Currency":"Kr.","Distributor":null,"Itemnum":"1803895","Unitprice":"42.97000","Website":"DigiKey"},{"Currency":"Kr.","Distributor":null,"Itemnum":"1803895","Unitprice":"43.800","Website":"Farnell"},{"Currency":"Kr.","Distributor":"element14 Asia-Pacific","Itemnum":"1803895","Unitprice":"38.0764","Website":"FindChips"},{"Currency":"Kr.","Distributor":"Onlinecomponents.com"

Could you please suggest the best approach to handle this scenario? I’m particularly looking for a way to pass and display multiple records from Power Automate to Copilot Studio in a structured format suitable for adaptive cards.

Could anyone please help me with any better suggestion or a possible work around on this??
Categories:
Calling actions from Copilot Studio
I have the same question (1)
  • Suggested answer
    sandeep_angara Profile Picture
    sandeep_angara 430 Moderator on at
     
    To display your data in this kind of table, you would need to structure your output into the below mentioned JSON format, dynamically in Power Automate and send that to Copilot Studio.

     
    {
        "type": "AdaptiveCard",
        "$schema": "https://adaptivecards.io/schemas/adaptive-card.json",
        "version": "1.5",
        "body": [
            {
                "type": "Table",
                "columns": [
                    {
                        "width": 1
                    },
                    {
                        "width": 1
                    },
                    {
                        "width": 1
                    },
                    {
                        "width": 1
                    },
                    {
                        "width": 1
                    }
                ],
                "rows": [
                    {
                        "type": "TableRow",
                        "cells": [
                            {
                                "type": "TableCell",
                                "items": [
                                    {
                                        "type": "TextBlock",
                                        "text": "Currency",
                                        "wrap": true
                                    }
                                ]
                            },
                            {
                                "type": "TableCell",
                                "items": [
                                    {
                                        "type": "TextBlock",
                                        "text": "Distributor",
                                        "wrap": true
                                    }
                                ]
                            },
                            {
                                "type": "TableCell",
                                "items": [
                                    {
                                        "type": "TextBlock",
                                        "text": "Itemnum",
                                        "wrap": true
                                    }
                                ]
                            },
                            {
                                "type": "TableCell",
                                "items": [
                                    {
                                        "type": "TextBlock",
                                        "text": "Unit Price",
                                        "wrap": true
                                    }
                                ]
                            },
                            {
                                "type": "TableCell",
                                "items": [
                                    {
                                        "type": "TextBlock",
                                        "text": "Website",
                                        "wrap": true
                                    }
                                ]
                            }
                        ]
                    },
                    {
                        "type": "TableRow",
                        "cells": [
                            {
                                "type": "TableCell",
                                "items": [
                                    {
                                        "type": "TextBlock",
                                        "text": "Kr.",
                                        "wrap": true
                                    }
                                ]
                            },
                            {
                                "type": "TableCell",
                                "items": [
                                    {
                                        "type": "TextBlock",
                                        "text": "element14 Asia-Pacific",
                                        "wrap": true
                                    }
                                ]
                            },
                            {
                                "type": "TableCell",
                                "items": [
                                    {
                                        "type": "TextBlock",
                                        "text": "1803895",
                                        "wrap": true
                                    }
                                ]
                            },
                            {
                                "type": "TableCell",
                                "items": [
                                    {
                                        "type": "TextBlock",
                                        "text": "38.0764",
                                        "wrap": true
                                    }
                                ]
                            },
                            {
                                "type": "TableCell",
                                "items": [
                                    {
                                        "type": "TextBlock",
                                        "text": "FindChips",
                                        "wrap": true
                                    }
                                ]
                            }
                        ]
                    }
                ]
            }
        ]
    }
     
    If this helps, please mark this as an answer, or let me know if you still have any further questions.
     
    Thank you
     
    Regards,
    Sandeep Angara
  • GS-08070407-0 Profile Picture
    GS-08070407-0 7 on at
     
    Thanks for your time and reply
     
    And i just want to ask it in the below case....
     
    If it is one record then i was able to do it in the same way.. you mentioned.... but if there are multiple records for example 10 or 15 like that then how can we display them in a tabual form in adaptive card...

    How can we use the data in json code??

    If possible, Could you please suggest me in this way?

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 594

#2
chiaraalina Profile Picture

chiaraalina 170 Super User 2026 Season 1

#3
deepakmehta13a Profile Picture

deepakmehta13a 118

Last 30 days Overall leaderboard

Featured topics

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

Product updates

Microsoft Power Platform Community release plans