How to format multi choice field in workflow email
-
17 พฤศจิกายน 2554 22:52
I have a field called "Choices" that is a choice field, check boxes, allowing multiple selections. I have programmed the list to send an email with all the information once submitted.
My code for the field in my workflow email is just a lookup of the field with a title before it: Choices: [%CurrentItem:Choices%]
Here is what it looks like in the email, Is there any way to get rid of the # before each choice, and can I list each item instead of a long string?
Choices: ;#Telephoned;#Came to See You;#Please Call;#Returned Your Call;#Confidential;#Will Call;#Wants to See You;#Rush;#
ตอบทั้งหมด
-
21 พฤศจิกายน 2554 8:37ผู้ดูแล
Hi ,
When you perform the look up in the email body ,you can choose to return the field as ‘Choices, with Comma Delimited’ instead of ‘As String’.
Data Source: Current Item
Field from source: Choices
Return field as :Choices ,with Comma Delimited.
Thanks,
Entan Ming
- ทำเครื่องหมายเป็นคำตอบโดย Entan MingMicrosoft, Moderator 25 พฤศจิกายน 2554 1:11
-
3 กุมภาพันธ์ 2555 14:43
Follow up question:
Can you make the format of the information returned using "Choices ,with Comma Delimited" look different in the e-mail?
For example:
Currently info displays in the e-mail:
item1,item2,item3
Desired format in the e-mail:
item1, item2, item3
or
item1
item2
item3Is this possible?
Thanks!
JP -
12 เมษายน 2555 16:05wrong answer...comma delimited causes coercion failed errors. please advise
-
22 มิถุนายน 2555 10:56
Coercion Failed error is caused due to null entries in the choice column.
Either make the choice column as required
Or
Check "if not null" then Assign the choice column to the workflow variable and use that variable in your workflow.
Thanks,
.png)
