If null return value, If not null return formatdatetime

[kcg633755]

Hello,

I am scratching my head trying to find an expression to return a null value as TBC but if the value is not null return a date with date formatting.

Any suggestions?

I want to avoid using a condition if possible.

Many thanks in advance.

[kcg633755]

This is the expression I am using at the moment, it is causing the flow to crash...

if(equals(coalesce(triggerOutputs()?['body/12 - Date of Event:'],null),null),'00/00/0000',formatdatetime(triggerOutputs()?['body/12 - Date of Event:'],'dd/MM/yyyy'))

Any ideas?

---

@kcg633755 wrote:

Hello,

I am scratching my head trying to find an expression to return a null value as TBC but if the value is not null return a date with date formatting.

Any suggestions?

I want to avoid using a condition if possible.

Many thanks in advance.

---

[kcg633755]

This is the message I get 

[v-alzhan-msft · Accepted solution]

Hi @kcg633755 ,

I have made a test on my side to create a "DueDateW" column, you could refer to my flow with expression as below:

The expression in the Compose as below:

if(empty(triggerBody()?['DueDateW']),'TBC',formatdatetime(triggerBody()?['DueDateW'],'dd/MM/yyyy'))

When I create a item in the list and the "DueDateW" column's value is null, the flow would run successfully as below:

When I create a item in the list and have value in the "DueDateW" column, the flow would run successfully as below:

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.