web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to use expression ...
Power Automate
Answered

How to use expression to convert array of data to string values separated by commas

(0) ShareShare
ReportReport
Posted on by 299

This should be easy for me to do, but I'm hitting a wall as to why the following options are invalid expressions.

 

I have a Select action I am using, to help filter column results from a SharePoint list.   Within this action, under the Map section we can add values. Looks like this...

 

kensley_0-1713901489607.png

 

 

The value I am struggling with is my Event Type value. It looks like this as an expression...

 

 

 

@item()?['Event_x0020_Type']

 

 

 

It produces something like this...

 

 

["one","two","three"]

 

 

 

But I want....

 

 

 

"one", "two", "three"

 

 

 

I tried adjusting this value to be an expression like so...

 

 

 

item()?join('Event_x0020_Type',',')

 

 

 

and

 

 

item()?join(outputs('Event_x0020_Type'),', ')

 

 

 

but neither of them are valid expressions.

 

Please help

Categories:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @kensley 

     

    after select action, use the following expression in compose action which join the array produced as a result of select action  

     

    join(body('Select'),',')

     

    Hope this helps !

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • CU09091757-0 Profile Picture
    299 on at

    @Nived_Nambiar  I updated my original question so you see my what Select action looks like. I have multiple values in it.  I am happy with all of them, but just need my "Event Type" value to convert to a string, so that it does not appear as an array of values later.

     

    Let me know what you think. Many thanks!

     

     

     

  • Verified answer
    Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @kensley 

     

    I got it EventType appears as array but you want it as string, I would say try these two expressions , see which works for you !

     

    replace(replace(string(item()?['Event_x0020_Type']),'[',''),']','')

     

    Or try this as well (not sure whether this works)

    join(item()?['Event_x0020_Type'],',')

     

    Let me know whether this helps?

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • CU09091757-0 Profile Picture
    299 on at

    That was perfect on the first one!  Many thanks!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 224 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 181 Super User 2026 Season 1

#3
Kalathiya Profile Picture

Kalathiya 97 Super User 2026 Season 1

Last 30 days Overall leaderboard