Answered

Convert Table into string using Power FX Formula

(1) Share

Report

Posted on by LuisAznar

Hello fellow forum members,

I’m encountering an issue with the Concat function in Power FX. I’ve tried using it to concat values from a table that was automatically created by an Adaptive Card multiple select, but it’s returning empty results. Here’s the formula I’m using:

Concat(Topic.multipleSelect, ",")

What is weird, is that multipleSelect which is a table variable when I printed it into a message box is showing me the values correctly: ["value1", "value2", "value3"]

Any insights or suggestions would be greatly appreciated! Thank you in advance for your help.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

LuisAznar 69 on at

Like (0)

Report
Copy link

Link copied!
I could find the solution for convert exactly what a table variable provided me into a String variable editing the node into the code editor, now I'm trying to replace double quotes into single quotes and remove brackets from String:
- kind: SetTextVariable id: setVariable_IzY7HO variable: Topic.varYourString value: "{Topic.varYourTable}"

Was this reply helpful? Yes No
HenryJammes on at

Like (0)

Report
Copy link

Link copied!

Can you share more what your Topic.multiSelect contains?

Was this reply helpful? Yes No