Passing list rows values as choice to Power Virtual Agents from Power Automate

(0) Share

Report

Posted on by Monkeyman

325

Hi,

I have a Power Automate flow which list rows in a Dataverse table and then appends the results of the list rows step to a string variable.

If I wanted to then pass each one of those items as a choice back to the user, is this possible?

Thanks,

Categories:

Power Automate Flows

Flow Integration

All responses (7)

Answers (1)

Audrie101 on at

Like (0)

Report

Re: Passing list rows values as choice to Power Virtual Agents from Power Automate

In your schema the first DisplayName is missing the 's':
EricW 5 on at

Like (0)

Report

Re: Passing list rows values as choice to Power Virtual Agents from Power Automate

I'm getting the same error that the DisplayName is missing because I'm unable to define the schema. No matter how I try to define it, it either throws an exception, or simple vanishes when I save it. How do I define the schema for my array of objects?
Sample:
{
"id": 30755950,
"address1": "addr 1",
"address2": "Suite 300",
"diplayName": "Test Name 1"
},
{
"id": 30755951,
"address1": "addr 1",
"address2": "addr 2",
"displayName": "Test Name 2"
}
Thanks,
Eric
gsouthwood 2 on at

Like (0)

Report

Re: Passing list rows values as choice to Power Virtual Agents from Power Automate

Hi, @HenryJammes,

Did you get a solution to the above as I am also experiencing the exact same issue.

Thanks,

Graeme
himanshu_23 2 on at

Like (0)

Report

Re: Passing list rows values as choice to Power Virtual Agents from Power Automate

Hi
,

I am getting below error there is an error; "MissingDisplayName". however i am getting proper output
button getting generated but when it is not able to Delpy a solution
HenryJammes on at

Like (0)

Report
Re: Passing list rows values as choice to Power Virtual Agents from Power Automate

Yes, this is a feature now @darylvogan

Simply return the JSON as a string from Power Automate, use the Parse Value node to make it a table variable, and use the table as options from a list table in your question.
It works with no additional work if one of your property is defined as DisplayName:

The bonus is that if your table has a DisplayName property, the selected value will be saved as record.

Otherwise, use this formula to define the question options:
ForAll(Topic.VarTable, DisplayName)

And the output will be saved as a text string.
darylvogan 274 on at

Like (0)

Report

Re: Passing list rows values as choice to Power Virtual Agents from Power Automate

Is this yet a feature? Would love to return data back to PVA and have it present list of options to select from
Verified answer

renatoromao 6,819 on at

Like (1)

Report

Re: Passing list rows values as choice to Power Virtual Agents from Power Automate

Hi @Monkeyman ,

Unfortunately, not yet.

We have many ideas here: https://aka.ms/pva/community/ideas

You can set up an output using Markdown, then show a formatted list in the bot message.

(I recommend you to show this variable in a free text question, and the user type the option manually)