When 'if condition is false' with If Empty condition 'if (empty(triggeroutputs)'

(0) Share

Report

Posted on by Community Power Pla...

Hi,

When using If Empty function under Select, it still gives Null (blank) value even IF condition is false.

if(empty(triggeroutputs()?['Next Due']),null, formatdatetime(triggeroutputs()?['Next Due'], 'yyyy-MM-dd'))

Please advise how I can fix.

I have the same question (0)

All responses (19)

Answers (0)

fchopo 8,001 Moderator on at

Like (0)

Report
Re: When 'if condition is false' with If Empty condition 'if (empty(triggeroutputs)'

Hi @Anonymous

Could you try the following expression?

if(equals(triggeroutputs()?['Next Due'],null),null, formatdatetime(triggeroutputs()?['Next Due'], 'yyyy-MM-dd'))

Regards,

Ferran

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: When 'if condition is false' with If Empty condition 'if (empty(triggeroutputs)'

Thanks @fchopo
but it still gave me the same result.

Was this reply helpful? Yes No
VictorIvanidze 12,839 on at

Like (0)

Report
Re: When 'if condition is false' with If Empty condition 'if (empty(triggeroutputs)'

Try to initialize a string variable with
triggeroutputs()?['Next Due']
Will you see any errors?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: When 'if condition is false' with If Empty condition 'if (empty(triggeroutputs)'

Hi @VictorIvanidze

Is this what you mean?
Under 'Select'
if(equals(variables('NextDue'),null),null, formatdatetime(variables('NextDue'), 'yyyy-MM-dd'))

Then, I get below error

Was this reply helpful? Yes No
VictorIvanidze 12,839 on at

Like (0)

Report

Re: When 'if condition is false' with If Empty condition 'if (empty(triggeroutputs)'

OK it means the variable is successfully initialized. Now please show the value of NextDue variable after executing the flow.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: When 'if condition is false' with If Empty condition 'if (empty(triggeroutputs)'

please see below

Was this reply helpful? Yes No
VictorIvanidze 12,839 on at

Like (0)

Report

Re: When 'if condition is false' with If Empty condition 'if (empty(triggeroutputs)'

Aha.
Use this in Select:
if(empty(variables('NextDue'),'empty', formatdatetime(variables('NextDue'), 'yyyy-MM-dd'))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: When 'if condition is false' with If Empty condition 'if (empty(triggeroutputs)'

It says, the expression is invalid

Was this reply helpful? Yes No
VictorIvanidze 12,839 on at

Like (0)

Report

Re: When 'if condition is false' with If Empty condition 'if (empty(triggeroutputs)'

My bad, sorry. Use this:
if(empty(variables('NextDue')),'empty', formatdatetime(variables('NextDue'), 'yyyy-MM-dd'))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: When 'if condition is false' with If Empty condition 'if (empty(triggeroutputs)'

it shows as empty

Was this reply helpful? Yes No