Convert Table into string using Power FX Formula

Like (1) Share

Report

Posted on 9 Jul 2024 15:10:20 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.

All responses (2)

Answers (1)

Verified answer

LuisAznar 69 on 09 Jul 2024 at 15:44:05

Like (0)

Report
Convert Table into string using Power FX Formula

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}"
HenryJammes on 09 Jul 2024 at 15:23:38

Like (0)

Report

Convert Table into string using Power FX Formula

Can you share more what your Topic.multiSelect contains?