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 / Unable to extract a va...
Copilot Studio
Answered

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

(0) ShareShare
ReportReport
Posted on by 72

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

 

Tak103_0-1637680074021.png

 

 

Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    69,397 Most Valuable Professional on at

    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.

    image.png

     

  • Tak103 Profile Picture
    72 on at

    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.

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 April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 895

#2
Vish WR Profile Picture

Vish WR 337

#3
Haque Profile Picture

Haque 276

Last 30 days Overall leaderboard