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:

Calling actions from Copilot Studio

All responses (7)

Answers (1)

Sort by

Verified answer

CU22081450-0 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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)
darylvogan 274 on at

Like
a
(0)

Report
Copy link

Link copied!

Is this yet a feature? Would love to return data back to PVA and have it present list of options to select from
HenryJammes Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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.
himanshu_23 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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
gsouthwood 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @HenryJammes,

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

Thanks,

Graeme
EricW 11 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Audrie101 Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

In your schema the first DisplayName is missing the 's':