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:
Here is the form:
Field:
Workflow Notification:
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:
Here is the form:
Field:
Workflow Notification:
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 + #
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>')
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.