Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Copilot Studio - Topic Creation & Management
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?

  • MarKol Profile Picture
    on at
    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 at
    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 at
    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 at
    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 at
    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

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 >

Featured topics