Hi @Anonymous ,
Something like - the Char(10) is just a new line.
"Hazard Summary" & char(10) &
Physical Hadards" & char(10) &
Concat(
Last(
'Change Management Master List'
).'Physical Hazards',
Value & ","
) & char(10) &
Chemical Hadards" & char(10) &
Concat(
Last(
'Change Management Master List'
).'Chemical Hazards',
Value & ","
)
if you want to get rid of the last commas - you can try
With(
{
vPhysical:
Concat(
Last(
'Change Management Master List'
).'Physical Hazards',
Value & ", "
),
vChemical:
Concat(
Last(
'Change Management Master List'
).'Chemical Hazards',
Value & ", "
)
},
"Hazard Summary" & char(10) &
Physical Hadards" & char(10) &
Left(
vPhysical,
Len(vPhysical)-2
) & char(10) &
Chemical Hadards" & char(10) &
Left(
vChemical
Len(vChemical)-2
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
