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

Get rid of $ from currency field in nintex workflow

Jump to solution

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

0 Kudos
Reply
7 Replies
vijay_kampu
Nintex Newbie

Re: Get rid of $ from currency field in nintex workflow

Jump to solution

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

'Amount' : 'Itemperoperti:applicationamount'

0 Kudos
Reply
Automation Master
Automation Master

Re: Get rid of $ from currency field in nintex workflow

Jump to solution

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'?

0 Kudos
Reply
vijay_kampu
Nintex Newbie

Re: Get rid of $ from currency field in nintex workflow

Jump to solution

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

0 Kudos
Reply
vijay_kampu
Nintex Newbie

Re: Get rid of $ from currency field in nintex workflow

Jump to solution

i am passing below in my workflow

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

'Amount' : {ItemProperty:CounterOfferAmount},

tried both

0 Kudos
Reply
vijay_kampu
Nintex Newbie

Re: Get rid of $ from currency field in nintex workflow

Jump to solution

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.

View solution in original post

Reply
Automation Master
Automation Master

Re: Get rid of $ from currency field in nintex workflow

Jump to solution

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

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

0 Kudos
Reply
vijay_kampu
Nintex Newbie

Re: Get rid of $ from currency field in nintex workflow

Jump to solution

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 '$'

Reply