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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Delimeter Separation

(0) ShareShare
ReportReport
Posted on by 6
Hi,
 
I'm having an array which is having a following types. The delimiter I'm currently using is , (Comma) to separate the columns in the array. This array has more than 5 columns.
The Expression is : split(item(),',')?[7]
 
1) \"Chemicals, Material & Sustainability\"
 
2) Digital Services & Solutions
 
How to eliminate the commas inside the string (From Example 1) by not considering that as a delimiter.
 
Thanks
 
Categories:
I have the same question (0)
  • David_MA Profile Picture
    13,321 Super User 2025 Season 2 on at
    Please show what your array looks like. Arrays in Power Automate would look like this:
     
    [
      "Chemicals",
      "Materials",
      "Sustainability"
    ]
     
    Or:
     
    [
      { "Name": "David", "Dept": "IT" },
      { "Name": "Sandy", "Dept": "IT" }
    ]
     
    Or:
     
    ["A", "B", "C"]
     
     
    If the value you pass through the split() is \"Chemicals, Material & Sustainability\", it should return this array of values:
     
    [
      "\"Chemicals",
      " Material & Sustainability\""
    ]
     
    Can you show your flow run and what is being returned and input into the expression?

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 392 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 263 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 207 Most Valuable Professional

Last 30 days Overall leaderboard