If variable empty then write null otherwise the variable

[Schroeter]

if(empty(variables('VariDouble7')),0,variables('VariDouble7'))

Hello everyone

once again I need your help with my import into a SharePoint list from Excel.
I have numerical values these I have now set a variable.

Now this value should be transferred to the SharePoint list.
First he always shows me an error

The 'inputs.parameters' of workflow operation 'Element_erstellen' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Duration_x0020__x0028_Days_x0029' is required to be of type 'Number/double'. The runtime value '""' to be converted doesn't have the expected format 'Number/double'.

There are about 10 such columns

Now I wanted to tinker in an if condition.

if(empty(variables('VariDouble3')),0,variables('VariDouble3'))

But now he puts zero everywhere. Have checked an example against. Where there is a number in it, it writes a 0.

I hope for your support.

Best regards,

[Expiscornovus]

Hi @Schroeter,

Double is a floating point number/decimal. So, it seems your field expects that.

I see you are using a string in your variable (zeichenfolge). You could turn it into a float with a float function.

Try something like:

if(empty(variables('VariDouble3')),0.0,float(variables('VariDouble3')))

[Schroeter]

Hello Thanks for the method. Works perfectly.

But I keep getting an error, but I can't find the column.

Unable to process template language expressions in action 'Element_erstellen' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Can you tell me how to locate this error?

[okeks]

I think the error might be in one of your other inputs to the action.

I fear you need to show us all the functions you used in that action.

[Schroeter]

Okay..

addDays('1899-12-30',int(first(split(variables('varDate1'), '.'))),'yyyy-MM-dd')

this is complete Script

The process also runs through but simply stops in between.

[Schroeter]

Okay..

addDays('1899-12-30',int(first(split(variables('varDate1'), '.'))),'yyyy-MM-dd')

this is complete Script

The process also runs through but simply stops in between.

[okeks]

If you look at the run log, which value does varDate1 have before the problematic action?

[Schroeter]

Hello,

Good:

Not Good:

thank you

[Schroeter]

Maybe it's because I have date with time and some date without time.
That the formula hangs on it?

addDays('1899-12-30',int(first(split(variables('varDate1'), '.'))),'yyyy-MM-dd')

best regards