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

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

CU22081450-0 Most Valuable Professional on at

Like (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)

Was this reply helpful? Yes No
darylvogan 274 on at

Like (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

Was this reply helpful? Yes No
HenryJammes Microsoft Employee on at

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

Was this reply helpful? Yes No
himanshu_23 2 on at

Like (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

Was this reply helpful? Yes No
gsouthwood 2 on at

Like (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

Was this reply helpful? Yes No
EricW 11 on at

Like (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

Was this reply helpful? Yes No
Audrie101 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No