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 topics

I have the same question (0)

All responses (3)

Answers (1)

Nina131 44 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

HenryJammes Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
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}"

Was this reply helpful? Yes No
Nina131 44 on at

Like (0)

Report
Copy link

Link copied!

Thanks so much!

Was this reply helpful? Yes No