General

Re: SharePoint Desginer formatting issues with email

warrtalon — Thu, 17 Dec 2009 15:01:28 GMT

Yeah, you didn't mention InfoPath, so I'm not sure why you posted it here, but I'll be glad to help. When using the email builder of SPD, you can't expect any special formatting. The best you can do is HTML formatting, but it's not going to be able to format like InfoPath - it's not a full design tool like that. All it can do is display the RAW XML data, which is what you're seeing. Setting a field to Date Only doesn't mean the XML is date only. That's just what the browser is configured to show the user. What you're seeing in the SPD emails is the real data.

So, there are a few things you can do. Since this is an InfoPath forum, I assume this data is coming from an InfoPath form. You can either use the Submit to Email data connection to send the form as-is straight to someone's Outlook where it will render just like it does in InfoPath. Or, if you must use the SPD workflow, then in your InfoPath form, create text fields that use concatenate formulas to make your raw data look how you want it to. For example:

- For the Date field, create a text field and set its default value to be substring-before(Date,"T") or something like that. This will strip off the letter "T" and the time stamp at the end while leaving you with only the date.
- For the Currency field, simply create a text field and set its default value to substring-before((concat("$",Currency)),"."), although that won't add comma delimiters to the number, but it will cut off the numbers after the decimal.

Re: SharePoint Desginer formatting issues with email

Qazi Anis — Thu, 17 Dec 2009 07:58:51 GMT

i think you are barking at the wrong tree, this forum is for infopath, not for sharepoint designer, you better ask this question in some sharepoint designer forum

SharePoint Desginer formatting issues with email

prajesh1 — Thu, 10 Dec 2009 15:39:40 GMT

Hi,

I am working in SharePoint Desginer and to set up an email in a workflow. It is working fine but I am having issues with the formatting of Currency and also Date. I am not able to get a field to format as a Currency and although when I created the field as Date Only in the email it picks up Date time not just the Date.

Can any body please suggest are there any in built functions at the email builder part of the work flow. I tried to use simple VB script functions like FormatCurrency and FormatDateTime but it is not working.

Thank You,