DannyH
Novice

Save ID field to integer datafield error

I am trying to use the Get Item Reference to get a list item ID from a SharePoint list and then save it to a datafield of type integer but it fails with "Specified cast is not valid".

The ID field is a number field is that not the same as an integer field?

i have even tried using To Integer conversion on the ID field but that does not work. 

 

Any help would be appreciated.

0 Kudos
Reply
3 Replies
AbrahamM
Novice

Re: Save ID field to integer datafield error

Hi Pbear74


I would like to help. Have you tried to set your ID DataType to an #AutoNumber Instead of a #Number?


To answer your question i.e. “The ID field is a number field is that not the same as an integer field?”
-It is not necessarily the same, a #Number ID properties contains integer’s, but Integer properties doesn’t have all #Number ID properties. So if you are getting the type of error that you have mentioned, it is recommendable to alter the DataType as I highlighted above and see if it doesn’t lead you where you want to be.


Let me know what you found out. Cheers…

0 Kudos
Reply
FlinnC
Novice

Re: Save ID field to integer datafield error

Hi, I am having this exact same issue. Were you able to find a solution?

0 Kudos
Reply
khanh1
Novice

Re: Save ID field to integer datafield error

Hi,


 


There was a similar issue in K2 version 4.6.11. Issue seems to be fixed in 4.7. I did a quick test on this, see video link: http://www.screencast.com/t/QbJAM2blGBkJ.


Which K2 version do you guys currently have?

0 Kudos
Reply