Answered

Convert table variable to a string for Power Automate flow

(1) Share

Report

Posted on by Nina131

Hi,

I have a table from an adaptive card, and I can't seem to concatenate this table to a string so I can send the variable to PA.

I tried using the the JSON() formula, but it does not support the table data type.

JSON cannot serialize.png

I have tried to concatenate the table to a string, but using Concatenate(Topic.selectedOptionsTable, "") returns an empty string, despite the table having values in it.

The adaptive card has the following JSON formula:

{

"type": "AdaptiveCard",

"$schema": "http://adaptivecards.io/schemas/adaptive-card.json",

"version": "1.0",

"body": [

{

"type": "Input.ChoiceSet",

"id": "selectedOptionsTable",

"isMultiSelect": true,

"choices": [

{"title": "Fire Protection", "value": "Fire"},

{"title": "Drought Protection", "value": "Drought"},

{"title": "Flood Protection", "value": "Flood"},

{"title": "Extreme Temperature Protection", "value": "ExTemp"},

{"title": "Crop Disease Protection", "value": "Crop Disease"},

{"title": "Crop Pest Protection", "value": "Crop Pest"}

"style": "compact"

}

"actions": [

{

"type": "Action.Submit",

"title": "Submit",

"data": {

"cardSubmit": true

}

]

}

If I send the table variable as a message I can see it is a column table, in square brackets, with the values selected. For example: [“Fire”,“Drought”,“Flood”,“ExTemp”]

Am I concatenating this wrong? How can table variables be used?

Thanks

Categories:

General

All responses (3)

Answers (1)

Nina131 33 on at

Like (0)

Report

Re: Convert table variable to a string for Power Automate flow

Thanks so much!
Verified answer

HenryJammes on at

Like (2)

Report
Re: Convert table variable to a string for Power Automate flow

Hi @Nina131,

For simple arrays, you can use the JSON formula, e.g.:

JSON([1, 2, 3])

But, for more complex cases, there's actually an undocumented node that you can set using the code editor view:

- kind: SetTextVariable id: setVariable_IzY7HO variable: Topic.varYourString value: "{Topic.varYourTable}"
Nina131 33 on at

Like (0)

Report

Re: Convert table variable to a string for Power Automate flow

Hi,
I have found a very tedious solution, so if anyone has a better solution, please add it here.

After some trial and error, I have set 6 separate variables named Value1 to Value6. They check if the row count of the table is greater than the current index, and return the field using Index() if true, else "". Then I concatenate the value variables into a string.

eg.
Value1 = If( 1 <= Topic.RowCount, Index(Topic.selectedOptionsTable, 1).Value, "")