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 / Retrieve a list (JSON)...
Copilot Studio
Unanswered

Retrieve a list (JSON) from Flow action

(0) ShareShare
ReportReport
Posted on by 5

Will it be possible to retrieve a list of items from Virtual Agent Flow action response? The requirement is to query CDS database entity  with Flow and retrieve a list of corresponding records (for example store locations) and present them for the end user to choose from? 

Has anyone managed to do this somehow?

  • jpirelli Profile Picture
    Microsoft Employee on at

    Almost exactly what I was looking for too!!!

    https://powerusers.microsoft.com/t5/Power-Virtual-Agents-Forum/Is-there-a-way-to-handle-array-or-sets-in-a-response-from-a-flow/m-p/400421#M58 

     

    This is the same scenario I have, hope we can get a timeline on this feature!

     

  • Dhinakaran Profile Picture
    31 on at

    Hi Antonio,

    I ran into the same limitation as well and I don't think it is possible yet.

    Noticed that there is no idea submitted already on this scenario. Would you be willing to submit this as an idea to the PVA team? https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

     

    Best,
    Dhina

  • jpirelli Profile Picture
    Microsoft Employee on at

    In the meantime, check out Markdown support! I wrote a quick post on using it to better format a list:

    https://powerusers.microsoft.com/t5/Power-Virtual-Agents-Forum/PVA-Response-Support-some-portions-of-Markdown-formatting/m-p/409413 

     

  • AntonioV Profile Picture
    5 on at

    I hope that they will add this soon, @jpirelli I will check your workaround from the last post. Tnx.

      

  • MarKol Profile Picture
    Microsoft Employee on at

    There is currently no List (Array) variable type supported in Power VA, so the Arrays returned by flows cannot be read by bots.

     

    Once List variable type is added to Power VA, accepting Lists (Arrays) returned by flows will become possisble.

     

    Power AV supports the following variable types with flows:

    • String
    • Number
    • Boolean

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Copilot Studio

#1
Mohsin Ali Profile Picture

Mohsin Ali 320

#2
Valantis Profile Picture

Valantis 173 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 139 Super User 2026 Season 2

Last 30 days Overall leaderboard