Skip to main content

I'm creating a workflow to send a notification, and trying to format the values from a field where "Allow multiple values" has been selected.

Currently this is the format the emails are being received:

2015-11-29_17-25-45.png

Here is the form:

2015-11-29_17-17-56.png

Field:

2015-11-29_17-18-41.png

Workflow Notification:

2015-11-29_17-28-27.png

Hi Jason

You can format output by html, e.g. as a table.

On form create a Calculated Value control with formula:

replace(replace(replace(ScheduleCreator, ',', '</td></tr><tr><td>' ), '^', '<table><tr><td>' ), '$',  '</td></tr></table>')

I used a Choice Control named ScheduleCreator, so values are separated by comma.

First all ',' will be replaced by '</td></tr><tr><td>'.

Then begin of string ('^') will be replaced by '<table><tr><td>'.

Then end of string ('$') will be replaced by '</td></tr></table>'.

Assign calculated value control to a workflow variable und insert this variable in Send Notification rich text field.

Kind regards

Manfred


Hi Manfred,

    I have implemented the suggested changes, and my output to the form is showing the item Id + #

2015-11-30_09-26-35.png

When trying to assign the value of the calculated control to a variable, I'm not seeing the control in the list of item properties.


to remove IDs:

replace(replace(replace(ScheduleCreator, ',[^;]+;#', '</td></tr><tr><td>' ), '^[^;]+;#', '<table><tr><td>' ), '$',  '</td></tr></table>')


Reply