Skip to main content
Nintex Community Menu Bar

Get rid of $ from currency field in nintex workflow

  • March 13, 2018
  • 7 replies
  • 28 views

Forum|alt.badge.img+3

Can someone pls help me , how to covert curreny filed value i.e $1234 to number or text in Nitext workflow . Atleast how to get rid of '$' from the value

7 replies

Forum|alt.badge.img+3
  • Author
  • March 13, 2018

I am trying to save currency field value from one list to another using 'web request' rest api, its throwing error

'Amount' : 'Itemperoperti:applicationamount'


Forum|alt.badge.img+14
  • Scholar
  • March 14, 2018

if fields in both lists are of Currency type, they should be able to handle the value.

you 'error' rather seems to me to be a typo problem - shouldn't you have to supply somewhere {ItemProperties:applicationamount} instead of 'Itemperoperti:applicationamount'?


Forum|alt.badge.img+3
  • Author
  • March 14, 2018

No in this post its typo mistake, but while in the workflow i selected the correct one. Both are of same currency type, even then its not taking.

'Amount' : '123'  - It works.

'Amount' : '$123' - it fails.  atleast i am trying to get rid of '$' thats not happening. i tried regual expresion also


Forum|alt.badge.img+3
  • Author
  • March 14, 2018

i am passing below in my workflow

'Amount' : '{ItemProperty:CounterOfferAmount}',

'Amount' : {ItemProperty:CounterOfferAmount},

tried both


Forum|alt.badge.img+3
  • Author
  • March 14, 2018

I got a solution

1) I took the value into text variable and converted to string

2) Then use regular expression to get rid of '$'

3) then use the numeric value it worked.


Forum|alt.badge.img+14
  • Scholar
  • March 14, 2018

I'm just curious why it might not work...

do you have different currencies and/or locales configured on two sites?


Forum|alt.badge.img+3
  • Author
  • March 14, 2018

Nope, infact both the lists use the same content type. Rest api was not taking the value as it is , it takes without $. However through SharePoint UI it allows '$'