Announcements
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
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).
Now outside the Loop you can pass in the String Variable back 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)
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.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 267
Vish WR 163
Romain The Low-Code... 153 Super User 2026 Season 1
