Answered

Send Multiple Choiceset selection as input to Power Automate

(0) Share

Report

Posted on by St4rsup

Hello Experts,

I have been searching and looking around to get a solution to my needs. I have an "Input.ChoiceSet" from an Adaptive Card that allows me to select multiple items. The result of the selection is stored in a variable type "Table" as default. I need to send those values to a Power Automate "When Power Virtual Agents calls a flow" but the flow only admits Text, Yes/No, Number as Input.

I tried to use functions Text, ParseJSON, and JSON without success yet. Here is the Input.ChoiceSet that stores all the selectable values

{
"type": "Input.ChoiceSet",
"choices": [
{
"title": "Customer Sound",
"value": "CS"
},
{
"title": "Old Sound",
"value": "OS"
},
{
"title": "Data Sound",
"value": "DS"
},
{
"title": "Sound Blaster",
"value": "SB"
}
],
"placeholder": "Select component",
"value": "CS",
"id": "GPD_COMPONENT",
"isMultiSelect": true,
"isRequired": true,
"errorMessage": "Please, select at least one component",
"label": "Select Component(s)"
}

Maybe I am taking the wrong path to solve the issue but any help will be very well received.

Thanks in advance!

Categories:

Calling actions from Copilot Studio

I have the same question (0)

All responses (3)

Answers (1)

Umianta 290 on at

Like (0)

Report
Copy link

Link copied!

Hi @St4rsup
You can retrieve the value of a field of type Table using the First function.
For instance, consider the following example where Var1 is a Table type variable, and I am attempting to access the Content inside the Message.

If my response has addressed your query, kindly mark your post as Solved.
If you found my response helpful or it provided you with a direction to proceed, please give it a Thumbs Up. Your Kudos are appreciated. You can accept multiple posts as solutions.
If you're still encountering any issues or challenges, please don't hesitate to inform me so I can assist you further. I'm here to help.
Cheers ,
Umesh Khandelwal

Was this reply helpful? Yes No
Verified answer

St4rsup 16 on at

Like (1)

Report
Copy link

Link copied!

Thanks, @Umianta for your quick answer.

I was able to find a value from the table using the following:
Index(Topic.Var_type_table,1)

Now I need to create an array with all the values but at least I was able to get the values and pass them to power automate.

UPDATE:
Using the following formula I am able to get a string with all the values from the variable type Table.
Concat(Topic.var_type_table,Value,",")

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @St4rsup,

Thanks for your sharing.

Was this reply helpful? Yes No