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.
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…
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?