cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Antonio_V
Regular Visitor

Retrieve a list (JSON) from Flow action

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?

5 REPLIES 5
jpirelli
Microsoft
Microsoft

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-set... 

 

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

 

Dhina
Frequent Visitor

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

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... 

 

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

  

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

Top Solution Authors
Top Kudoed Authors
Users online (3,556)