You’re offline. This is a read only version of the page.
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!
Hi @St4rsup,
Thanks for your sharing.
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,",")
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
Share
Report
All responses (
Answers (
