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,
In your schema the first DisplayName is missing the 's':
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
Hi, @HenryJammes,
Did you get a solution to the above as I am also experiencing the exact same issue.
Thanks,
Graeme
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
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.
Is this yet a feature? Would love to return data back to PVA and have it present list of options to select from
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)