Skip to main content

Notifications

Calling Actions from Copilot Studio
Answered

Send Multiple Choiceset selection as input to Power Automate

Posted on by 16

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:
  • Re: Send Multiple Choiceset selection as input to Power Automate

    Hi @St4rsup,

    Thanks for your sharing.

  • Verified answer
    St4rsup Profile Picture
    St4rsup 16 on at
    Re: Send Multiple Choiceset selection as input to Power Automate

    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,",")

  • Umianta Profile Picture
    Umianta 293 on at
    Re: Send Multiple Choiceset selection as input to Power Automate

    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.

    Umianta_0-1713834731084.png

     

    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

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Getting Started…

Welcome to the Power Platform Community! We appreciate your visit…

Welcome to the new Power Platform Community!…

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

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 138,030

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,085

Leaderboard

Featured topics