cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Create Item in another list formatting incorrect

Jump to solution

I have a list that creates an item in another list. I want to pull some information from list 1 into list 2. Most of the fields are working just fine, but when I added a currency field, it is saying "type "Currency" is not in a correct format". The field is a currency field in both list 1 and 2. In the workflow action, I have the field type set as currency. When I added the value, I made sure to change the formatting to currency. I was having similar issues with date fields as well. I have no idea what I'm missing. 

Labels: (1)
0 Kudos
Reply
6 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Create Item in another list formatting incorrect

Jump to solution
Hi,
Are the lists in the same site?
Are you able to provide screen shots of the issue?
Are you displaying the list items in a Nintex Form?
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Create Item in another list formatting incorrect

Jump to solution

Hi Simon,

Yes, they are in the same site.

Yes, the results are in a form that is also formatted as currency.

I'm trying to attach some screen shots.

0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Create Item in another list formatting incorrect

Jump to solution
How is the amount entered into the currency field? Are users entering $50.00 or 50.00?
The reason I ask is because the error is stating that the currency is in the wrong format and it has a dollar sign which should not be there as the column is a currency field the metadata does not need to include the currency symbol. I could be wrong as I havent tested this theory.
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Create Item in another list formatting incorrect

Jump to solution

The user is just entering 50. No dollar sign. The form won't let you enter the symbol.

0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Create Item in another list formatting incorrect

Jump to solution
Ok,

Instead of Type Currency use Type Text and it will work.

View solution in original post

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Create Item in another list formatting incorrect

Jump to solution

Strangely enough, the currency formatting started to work after I deleted it and added it back in again. I did also test out formatting it as a string like you suggested and that worked as well. I think in the future I will use your solution. Thanks!

0 Kudos
Reply