Format the Power Automate response in PVA for sexy renderer

(0) Share

Report

Posted on by JM78

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 :

And i pass the variable as a return value for PVA

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

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

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Pstork1 69,330 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
JM78 28 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
JM78 28 on at

Like (0)

Report
Copy link

Link copied!

Here's the style i'm looking for :

Was this reply helpful? Yes No
Pstork1 69,330 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Pstork1 69,330 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
JM78 28 on at

Like (0)

Report
Copy link

Link copied!

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 ";"

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

The result is shown like that :

Was this reply helpful? Yes No
Pstork1 69,330 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

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

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
JM78 28 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No