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
Thanks Pstork1.
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.
Pablo Roldan
27
Romain The Low-Code...
25
stampcoin
10