Copilot Studio: Convert Table Variable to String from Adaptive Card to Agent Flow

Introduction

When building solutions in Copilot Studio, you may use Adaptive Cards to collect multi-choice input from users. The selected values from a multi-select field are stored as a table variable. However, if you want to pass these values to an Agent Flow (for example, to create a SharePoint list item), you need to convert the table variable into a single string.

This post shows how to concatenate the selected values from a multi-choice Adaptive Card field into a semicolon-separated string using the concat function in a Set Variable value action within your topic.

Convert Table to String

Solution

Suppose you have a multi-choice variable called assistiveTech and another variable called otherAssisTech. To combine all selected values into a single string, use the following formula:

Concatenate(Concat(Topic.assistiveTech, Text(Value), ";"), Topic.otherAssisTech)
  • Concat(Topic.assistiveTech, Text(Value), ";") joins all selected values from the table with a semicolon.
  • Concatenate(..., Topic.otherAssisTech) appends the value of otherAssisTech to the result.

Formula Example

Passing the String to an Agent Flow

Once you have the concatenated string, you can easily pass it to an Agent Flow as a parameter. This allows you to create a SharePoint list item with the selected values stored as a single, semicolon-separated string.

Pass string to Agent Flow

Result

The SharePoint list item will display the concatenated multi-choice values in a single field, making it easy to store and view user selections.

Concatenated Multivalues

Summary

  • Adaptive Card multi-choice selections are stored as a table variable.
  • Use the Concat and Concatenate functions to convert the table to a string.
  • Pass the string to an Agent Flow to create SharePoint list items or for other downstream processes.

This approach streamlines handling multi-choice data from Adaptive Cards in Copilot Studio and Power Automate scenarios.