Retrieve a list (JSON) from Flow action

[Antonio_V]

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]

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]

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]

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

[Antonio_V]

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

[MarKol]

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