Skip to main content

Notifications

Calling Actions from Copilot Studio
Answered

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

Posted on by 212

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,

  • Audrie101 Profile Picture
    Audrie101 on at
    Re: Passing list rows values as choice to Power Virtual Agents from Power Automate

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

    AudrieMSFT_0-1709259132935.png

     

  • EricW Profile Picture
    EricW 2 on at
    Re: Passing list rows values as choice to Power Virtual Agents from Power Automate

    pvaEditSchema.png

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

     

    himanshu_23_0-1688473762403.png

     

  • HenryJammes Profile Picture
    HenryJammes on at
    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:

     

     

    HenryJammes_2-1686237875922.png

     

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

     

    HenryJammes_3-1686237901501.png

     

    Otherwise, use this formula to define the question options:

    ForAll(Topic.VarTable, DisplayName)

    HenryJammes_4-1686238046511.png

     

    And the output will be saved as a text string.

     

     

     

  • darylvogan Profile Picture
    darylvogan 40 on at
    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 Profile Picture
    renatoromao 6,459 on at
    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)

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,997

#3
Expiscornovus Profile Picture

Expiscornovus 1,708

Leaderboard

Featured topics