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 / Copilot Studio / How to return a list f...
Copilot Studio
Unanswered

How to return a list from flow to my bot response

(2) ShareShare
ReportReport
Posted on by Microsoft Employee

In my scenario, I am trying to query Lens DB for a list of TeamGroups. I can query that without issue and return a single value with no problem, and the bot can handle it set as a string. I can concatenate the string to make a comma separated list as a single string and it still works. Where things fall apart though is if I try to return a JSON array. Any ideas here? 

 

Ideally I would be able to return the list, let the user choose an item on the list to further drill down what they are looking for.

 

JSON Being returned is this:

{
"TeamGroupName": [
    "Business Insights",
    "Contact Management",
    "Content and Sites"
  ]
}
 
The Schema is:
{
    "type": "object",
    "properties": {
        "TeamGroupName": {
            "type": "array",
            "items": {
"type": "string"
            }
        }
    }
}
 

The Error is:

"ErrorMessage": "Cannot convert extracted value from template language expression '@parameters('e5e435ce-bfc7-4c0e-ae32-8e7a03c8e0f1')['TeamGroupName']' to target type 'None' for ContextVariable with id '209f66c0-3524-4a98-ac42-a4cca55a4d66'.  This may indicate a breaking signature change in an external dependency, such as a flow or skill output parameter type change." }

 

I can see the variable looks correct:

"e5e435ce-bfc7-4c0e-ae32-8e7a03c8e0f1": "{\r\n  \"TeamGroupName\": [\r\n    \"Business Insights\",\r\n    \"Contact Management\",\r\n    \"Content and Sites\"\r\n  ]\r\n}"

 

And lastly here are the Conversation Specifics:

"CurrentMessageDetail": {
          "TraceId": "JM8Ow",
          "ConversationId": "3w1vdPy1XTiH5wFP9Nt1uV-f",
          "CurrentProblemId": "8a4c5dfc-5a72-4f0c-851e-f6e41bf381d9",
          "ContentVersion": "760aadef-4f04-ea11-a811-000d3a334e11",
          "SentTime": "2019-11-11T07:03:18.0428103+00:00"
        }

I have the same question (0)
  • JoeGill Profile Picture
    175 on at

    I tried returning and formatting arrays from Flow but had no luck either

    Sorry

    Joe

  • MarKol Profile Picture
    Microsoft Employee on at

    Lists(arrays) are currently not a supported type in Power VA - you cannot create variables on type List in your Dialog.

     

    Once support for Lists-type variables is added, the bot will be able to accept JSON Arrays in flow output and parse them into List variables. 

     

    Right now, even though flows are capable of retuning Lists (i.e: you JSON is correct), Power VA cannot read them until List variable type is supported.

  • JonDoesFlow Profile Picture
    on at

    Hey

     

    i saw that List Variables are talked about in Wave 2 documentation 

     

    https://docs.microsoft.com/en-us/power-platform-release-plan/2021wave2/#power-virtual-agents

    I don’t see much other detail on this. Does anyone have anything ?

     

    thanks !

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 572

#2
Haque Profile Picture

Haque 154

#3
chiaraalina Profile Picture

chiaraalina 144 Super User 2026 Season 1

Last 30 days Overall leaderboard