Announcements
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
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.
Thanks Pstork1.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 633
Vish WR 301
Haque 216