If variable empty then write null otherwise the variable

(0) Share

Report

Posted on by 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,

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Expiscornovus 33,472 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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')))

Was this reply helpful? Yes No
Schroeter 35 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
okeks 802 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Schroeter 35 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Schroeter 35 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
okeks 802 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Schroeter 35 on at

Like (0)

Report
Copy link

Link copied!

Hello,
Good:

Not Good:

thank you

Was this reply helpful? Yes No
Schroeter 35 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No