Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio - Calling Actions from Copilot S... / How to return a list v...
Copilot Studio - Calling Actions from Copilot S...
Answered

How to return a list value to PVA

(1) ShareShare
ReportReport
Posted on by KarthikLohan 10

HI,

 

I have a multiple rows of data for a single District Name which is also a column value. When user input the district name, how to search and get all the multiple rows of data for that district and display it in PVA Chat  Bot. If I use "List Rows Present In a Table", it does not allow the row values to get displayed in the Return action stating error as :  "The output you selected is inside a collection and needs to be looped over to be accessed. This action cannot be inside a foreach."

 

Total no of columns is 5.

 

what is the solution, please suggest.

Karthik

Categories:
Power Automate Flows
Flow Integration
  • Pstork1 Profile Picture
    Pstork1 66,829 Most Valuable Professional on at
    Re: How to return a list value to PVA

    Another way to do this is to use the markdown features and Append to a string to create a formatted table to return to the Chat.  The table can then be displayed as a list.  Take a look at the following article.

    How to make your Teams bots richer with markdown – Vesa Nopanen – My Teams & Microsoft 365 Day (myteamsday.com)

  • Verified answer
    Jcook Profile Picture
    Jcook 7,779 Most Valuable Professional on at
    Re: How to return a list value to PVA

    Hello @KarthikLohan 

     

    Unfortunately, you cannot pass arrays back to PVA at this time.

     

    As a work around you can do the following:

    Add a String Variable, Inside the Loop use an Append to String Variable action (This is used to add all the data from the Loop into one variable).

    Jcook_0-1618329554399.png

     

     Now outside the Loop you can pass in the String Variable back to PVA:

    Jcook_1-1618329590764.png

     

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans