Skip to main content

Notifications

Calling Actions from Copilot Studio
Unanswered

Format the Power Automate response in PVA for sexy renderer

Posted on by 26

Hi all, 

 

I'm new in PVA. 

 

From a PVA topic, i'm calling a Power Automate in order to get Event list. 

From Power Automate, i've created an array of JSON object but PVA response only accept string fromat. 

I've created a variable that store json values in a string format as below : 

JM78_0-1689077158709.png

And i pass the variable as a return value for PVA

JM78_1-1689077207813.png

 

It works but the presentation of the values are not sexy 😞 

JM78_2-1689077330504.png

 

i'm looking for a way to show values in a click format to select an event on the list or maybe an adaptive card ?

 

Is there a way to display my events list as a clickable event selection list ?

 

Many thanks for your help. 

 

Regards, 

Jean-Michel DOS SANTOS

  • JM78 Profile Picture
    JM78 26 on at
    Re: Format the Power Automate response in PVA for sexy renderer

    Hi @HenryJammes 

     

    I've finally created an adaptive card process this morning. 

    Very easy to create and sexy as i expected 🙂 

     

    But the first version with standard multi choices have been released on prod environment.

     

    It'll be ready on the next release 🙂

     

    Many thx for help

  • HenryJammes Profile Picture
    HenryJammes on at
    Re: Format the Power Automate response in PVA for sexy renderer

    @JM78, have you considered adaptive cards to offer richer UX?

    E.g. Solved: Re: How to create an adaptive Card for Multiple op... - Power Platform Community (microsoft.com)

    Henry

  • Pstork1 Profile Picture
    Pstork1 1,997 on at
    Re: Format the Power Automate response in PVA for sexy renderer

    I thought of that, but that won't give you the multi-line formatted value that you used in the image of what you were trying to achieve.

  • JM78 Profile Picture
    JM78 26 on at
    Re: Format the Power Automate response in PVA for sexy renderer

    I've finally found a way to do this. 

    It's not really the most beautifull way as i expected but it'll do the job for a first version. 

     

    First step on Power Automate, i've added a separate character ";"

    JM78_3-1689085758173.png

     

    On PVA, i've just splitted my string value returned by Power Automate like that Split(Topic.AllEvents, ";")

    Then i've chosen the action "Options from a list variable" from question panel

     

    JM78_1-1689085457692.png

     

    The result is shown like that : 

    JM78_2-1689085737124.png

     

  • Pstork1 Profile Picture
    Pstork1 1,997 on at
    Re: Format the Power Automate response in PVA for sexy renderer

    I don't believe that is going to be possible.

  • Pstork1 Profile Picture
    Pstork1 1,997 on at
    Re: Format the Power Automate response in PVA for sexy renderer

    The only way I can think of to do that would be to return the list as a delimited list of some type and then use a PowerFX formula to convert it and save the result in a variable.  There is no support for returning an array of items directly to the Bot.

  • JM78 Profile Picture
    JM78 26 on at
    Re: Format the Power Automate response in PVA for sexy renderer

    Here's the style i'm looking for : 

     

    JM78_0-1689084261713.png

     

  • JM78 Profile Picture
    JM78 26 on at
    Re: Format the Power Automate response in PVA for sexy renderer

    Hi @Pstork1 , 

     

    I've tested the markdown language and its worked but it's not exactly what i need. 

    I'm looking more into purpose a picklist or choice options of events. 

     

    So, i need to find a way to transform the a string into a choice list. 

    My target is to let the user select for an event to subscrib

     

    Many thx for your help

  • Pstork1 Profile Picture
    Pstork1 1,997 on at
    Re: Format the Power Automate response in PVA for sexy renderer

    To format a response sent from Power Automate to PVA you need to use the markdown language to build the string so that PVA will display it in a formatted fashion.  Here's an article on how to use the markdown language.

    Use markdown to format Power Automate approvals - Power Automate | Microsoft Learn

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