Power Platform Community Forum Thread Details

How to return a list from flow to my bot response

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"
        }

Categories:

Flow Integration

Quick Links