Save ID field to integer datafield error

  • 4 January 2017
  • 3 replies
  • 3 views

Badge +4

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.


3 replies

Badge +5

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…

Badge +2

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

Userlevel 6
Badge +16

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?

Reply