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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Split the Contacts fie...
Power Automate
Answered

Split the Contacts field by “;” and “-”

(0) ShareShare
ReportReport
Posted on by

Action name: Data Operations > Compose (rename it “Split Contacts”)

  • Inputs: click Expression and paste
    • split(replace(replace(coalesce(item()?['Contacts'],''),'−',';'),'−',';'),';')split(replace(replace(coalesce(item()?['Contacts'],''),'−',';'),'−',';'),';')
       
      unfortunately it is giving me an expression error: "The input parameter(s) of operation 'Split_contacts' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Split_contacts'."
       
      Does someone know how to fix it?...
Categories:
I have the same question (0)
  • Verified answer
    Chriddle Profile Picture
    8,523 Super User 2026 Season 1 on at
    This should be enough:
    split(
    	replace(
    		coalesce(
    			item()?['Contacts'],
    			''
    		),
    		'-',
    		';'
    	),
    	';'
    )
     

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
David_MA Profile Picture

David_MA 124 Super User 2026 Season 1

#2
Ellis Karim Profile Picture

Ellis Karim 52 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 50

Last 30 days Overall leaderboard