Sunday, May 6, 2012

How to get currency field formatting which includes comma and $ sign in SharePoint Designer Workflow Email Activity

Problem:
I ran into one issue that by using SharePoint Designer Workflow, when it send email which contains “Currency” field in Email Activity it is not formatting  which shows commas and $ sign. It was irritating.
Solution:
After working on couple of hours, I found out solution (Such a simple) create one calculated column and make that column of String type and put the formula as “=DOLLAR(Amount,2)” and now include that field in Email Activity.
Whoooo!!!!!It is working like charm!!!!
Disha Shah