Announcements
I have six Currency columns that when left empty cause my workflow to crash because variables used for each currency column is expected a value and not a NULL.In the default property of each field I am using the below logic.
Try this
That is good information. So are you saying that I cant modify my formula in my field's default property so that if no value is entered the default value equals "0"?
Some fields do have a 'Default' option... It might work if you put a "0" in there
The default for the field already has a formula but I am trying to use that and account for a null value and then set the default property to zero. The code I have works but as of rignt now, I have to manually place a zero there.
Ok, so this whole fiasco was brought about by someone who created a sharepoint list with currency fields.The patch would run, which chould add the form values to the lists fields and then the workflow would start.The workflow uses a scope and in the scope it defines the type of field "Currency", the format "$1,234.00" and the currency type "en" for English. If the form field that holds the Unit Price is blank the variable will fail because it is looking for a value.
To fix this, I went into the list for each of the Unit Price fields in question and set their defaults to ZERO so when I added a new item and didnt put and dollar values in the form the default value is set to $0.00
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 392 Most Valuable Professional
11manish 136 Super User 2026 Season 2
MS.Ragavendar 109 Super User 2026 Season 2
