Skip to main content

Notifications

Community site session details

Community site session details

Session Id : nXKpNDI3wo+1IpqpemTWGd
Copilot Studio - General
Answered

Convert Table into string using Power FX Formula

Like (1) ShareShare
ReportReport
Posted on 9 Jul 2024 15:10:20 by 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.

 

  • Verified answer
    LuisAznar Profile Picture
    69 on 09 Jul 2024 at 15:44:05
    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 Profile Picture
    on 09 Jul 2024 at 15:23:38
    Convert Table into string using Power FX Formula
    Can you share more what your Topic.multiSelect contains?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Copilot Studio - General

#1
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 99

#2
Pablo Roldan Profile Picture

Pablo Roldan 61

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 26 Super User 2025 Season 1

Overall leaderboard
Loading started