Unable to extract a value from Jason from power automate and then pass it to Virtual agent

Like (0) Share

Report

Posted on 23 Nov 2021 15:09:21 by Tak103

I am new to Power Virtual and was trying to extract a value from Jason and past to output for Power Virtual agent but kept getting the error "The output you selected is inside a collection and needs to be looped over to be accessed. This action cannot be inside a foreach.". Tried to create a variable to store value from Jason but still can't get it to work.

Appreciate any guidance to perform this and thank you in advance

Categories:

General

All responses (2)

Answers (1)

Tak103 72 on 23 Nov 2021 at 19:19:29

Like (0)

Report

Re: Unable to extract a value from Jason from power automate and then pass it to Virtual agent

Thanks Pstork1.
Verified answer

Pstork1 67,170 Most Valuable Professional on 23 Nov 2021 at 18:34:59

Like (0)

Report

Re: Unable to extract a value from Jason from power automate and then pass it to Virtual agent

You can't return an array of data to the Bot from a flow. You have to format the array as some type of string. There are ways to create markup to turn the array entries into a Table (as a string). Then you can return the string and have the Bot display the table. Here's a screenshot of an example. varAvailable is an array variable that was Parsed from JSON. I then created a three column table by looping through the array and appending three values separated by pipe characters into a string. That string is then returned to the Bot. The Bot will display it as a table.