Skip to main content
Question

How to split multiple company names from Azure DevOps for HubSpot integration

  • October 7, 2025
  • 2 replies
  • 12 views

I have created a Zap that takes information from Azure DevOps and uses it to update a property in Hubspot.

One of the fields I’m taking from DevOps contains a string with multiple company names, delineated by a comma. This is being pulled through as one output which is being used by the subsequent input to find the matching company name in Hubspot. 

 

I’ve tried everything to get it to split this into multiple outputs to then search for the company record in Hubspot and complete the rest of the actions in the Zap. 

 

Any ideas?

2 replies

Sparsh from Automation Jinn
Forum|alt.badge.img+6

Hey ​@JB24653,

Try using Formatter in Zapier→ Text→ Split text. Put comma(,) in the Separator and All as Separate fields in the Segment. See below to understand it a bit more-

 


Hope it helps!


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • October 27, 2025

Hi ​@JB24653, just checking in!

Did that Formatter action Sparsh suggested do the trick?

Let us know how it went 🙏