Skip to main content
Community site session details

Community site session details

Session Id : DhMpbPtJDIRBPNY84X6cdi
Copilot Studio - Topic Creation & Management
Unanswered

Retrieve a list (JSON) from Flow action

Like (0) ShareShare
ReportReport
Posted on 12 Nov 2019 14:57:38 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?

  • MarKol Profile Picture
    on 22 Nov 2019 at 01:01:56
    Re: Retrieve a list (JSON) from Flow action

    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
  • AntonioV Profile Picture
    5 on 21 Nov 2019 at 14:28:23
    Re: Retrieve a list (JSON) from Flow action

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

      

  • jpirelli Profile Picture
    Microsoft Employee on 21 Nov 2019 at 05:51:19
    Re: Retrieve a list (JSON) from Flow action

    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 

     

  • Dhinakaran Profile Picture
    31 on 12 Nov 2019 at 17:30:05
    Re: Retrieve a list (JSON) from Flow action

    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 12 Nov 2019 at 17:21:59
    Re: Retrieve a list (JSON) from Flow action

    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!

     

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

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!

Announcing the Engage with the Community forum!

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

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 169 Super User 2025 Season 1

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 150

#3
sandeep_angara Profile Picture

sandeep_angara 75

Featured topics

Loading complete