Concatenate multiple fields
I would like to create a workflow to concatenate 3 diferent fields, the first and second ones are list/record’s type, and the third and last one is a text field. The problem is that the first and second fiels are not recognized at the formula and must be converted, and the formula doesn’t work. Does anybody could help me with the correct formula to convert the first and second fields and concatenate all fields? Note: I’m using the simple formula: concat(field1,field2,field3) and it’s not working.
Hi, CONCAT only takes two values. You could try either nesting the CONCAT functions
CONCAT({field1}, CONCAT({field2}, {field3}))
or more simply using the concatenation operator “||”
{field1}||{field2}||{field3}
Hello Guys,
You can use this format to combine ‘Text’ and {data base fields} .
CONCAT(‘Field text1 ‘, CONCAT({Field1}, CONCAT(‘Field Text2’: ‘,{Field2})))
