I'm using the "Create an element in another site" action in a Nintex workflow.
I'm trying to copy every field of an element in another list. The problem I have is, with a number field, when I define the value, if the source value is empty, it sets the destination value at 0. Is there a way to do it so it would be empty too.
For a text field, I can set the value as "Value" and insert a reference for a field.
But, for a number field, I need to select "Research in a list", Source : "Current element" and Field : [my field].
So, it worked... BUT!
I had an uneasy feeling while doing it since... a number field should normally be a number field!
After converting all the fields and redoing all my workflows, my users needed to export the SharePoint list in Excel files to produce some charts. Since the fields are text values, they can't produce charts without copying the data from the table to a new excel file and pasting it as value. And then convert the text field to numeric value.
So I'm still screwed here and it complexifies a lot something that should normally be rather simple!
Well the only thing I see you could try is the following (it won't win the workflow design award 2017 though):
It really is not beautiful but maybe it works
The only other options I see are by creating the item using PowerShell or web services that might give you some more control over how to set the item values.