web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 7Pi9dWxGineStueGWlwIsH
Copilot Studio - Calling Actions from Copilot S...
Answered

How to return a list value to PVA

Like (1) ShareShare
ReportReport
Posted on 13 Apr 2021 12:08:32 by 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

  • Pstork1 Profile Picture
    67,194 Most Valuable Professional on 18 May 2021 at 21:46:25
    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
    7,779 Most Valuable Professional on 13 Apr 2021 at 16:00:02
    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

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 169 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 150

#3
sandeep_angara Profile Picture

sandeep_angara 75 Super User 2025 Season 2

Featured topics