Skip to main content

Notifications

Topic Creation & Management
Unanswered

Retrieve a list (JSON) from Flow action

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
    MarKol 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
    AntonioV 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
    jpirelli 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
    Dhinakaran 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
    jpirelli 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!

     

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Getting Started…

Welcome to the Power Platform Community! We appreciate your visit…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 138,030

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,085

Leaderboard

Featured topics