tag:blogger.com,1999:blog-3893582346020662759.post3107873795691256643..comments2024-03-02T10:24:11.056+05:30Comments on SharePoint, ASP.Net, JQuery, SQL Solutions: SharePoint Exception: Coercion Failed: Input cannot be null for this coercionAnonymoushttp://www.blogger.com/profile/11277148819153438060noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-3893582346020662759.post-90604391489246941362015-04-09T03:38:02.183+05:302015-04-09T03:38:02.183+05:30If you create a workflow STRING variable then crea...If you create a workflow STRING variable then create a condition that only updates the variable if the value of the field is NOT EMPTY then you can set the variable to the value of the field (comma delimited) and use that variable in an email (as string - not comma delimited). You should not get a coercion-failed error if it's empty because SP is only checking a string value, not a comma-delimited value.<br /><br />You can use this trick for any SP field type. It seems best to only use string and number values when crafting the email template. Anonymoushttps://www.blogger.com/profile/16127833602345136914noreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-20249987855543228042015-02-20T01:35:12.878+05:302015-02-20T01:35:12.878+05:30Thank you! I don't think I would have figured ...Thank you! I don't think I would have figured this out if you didn't post this message here.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-8269052539845602562014-08-25T20:00:00.736+05:302014-08-25T20:00:00.736+05:30I am trying to do the same thing. It is not sendin...I am trying to do the same thing. It is not sending the email when I set it as a String. Not sure if there is a solution other then having to enter in Email To and Email CCAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-69029841349252410202013-04-17T01:19:59.314+05:302013-04-17T01:19:59.314+05:30if I am using in a CC variable with email, semi-co...if I am using in a CC variable with email, semi-colon delimited will it still send the email normally when changed back to As String?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-39775812450478767072013-03-14T04:38:07.061+05:302013-03-14T04:38:07.061+05:30This also happens when email, semi-colon delimited...This also happens when email, semi-colon delimited is selected, and the user leaves the field blank.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-85290099064280898802012-02-11T01:18:46.855+05:302012-02-11T01:18:46.855+05:30Thank you for putting this out here! This saved me...Thank you for putting this out here! This saved me hours today. I'm not a SPD workflow wizard, and I don't have access to one.Anonymousnoreply@blogger.com