ConcatenateMany

This is the more flexible sibling of Concatenate - it joins up to 10 strings at once, with a defined separator.

This action concatenates 1–10 SourceString inputs, skipping any that are null, using a Separator string between each. If Separator is null, it defaults to empty. UseRawValue controls whether strings are trimmed first (trimmed by default unless set to true). If all source strings are empty, it returns null.

Example: build a full mailing address

You're assembling a one-line shipping address from separate fields on an order:

• Separator = ", "
• SourceString1 = Street → "123 Main St"
• SourceString2 = City → "Springfield"
• SourceString3 = State → "IL"
• SourceString4 = Zip → "62704"

Running ConcatenateMany gives you:

• Result: "123 Main St, Springfield, IL, 62704"

If one of the fields is missing - e.g.. State is null - this action automatically skips it rather than leaving an awkward double separator, so you'd get "123 Main St, Springfield, 62704".

This makes it useful anywhere you need to join several optional fields cleanly, like building a full name from first/middle/last, or combining address lines, without having to nest multiple Concatenate calls or handle null-checking yourself.