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
I am trying to save currency field value from one list to another using 'web request' rest api, its throwing error
'Amount' : 'Itemperoperti:applicationamount'
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'?
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
i am passing below in my workflow
'Amount' : '{ItemProperty:CounterOfferAmount}',
'Amount' : {ItemProperty:CounterOfferAmount},
tried both
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.
I'm just curious why it might not work...
do you have different currencies and/or locales configured on two sites?
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.