web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Copilot Studio Convert Table into str...

Copilot Studio

Answered

Convert Table into string using Power FX Formula

(1) Share

Report

Report

Posted on by LuisAznar

69

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

HenryJammes Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Can you share more what your Topic.multiSelect contains?

Was this reply helpful? Yes No
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

Join the conversation