Unanswered

FormatDateTime - null

(0) Share

Report

Posted on by joel914823

557

I have a Format Date Time below but the Complete Date sometimes may be blank so I'm getitng error that it can't accept a null value. I'd still like the record to paste into excel even though it's blank. How can I get around this?

FormatDateTime(outputs('Get_item')?['body/Complete_x0020_Date'],'M/dd/yyyy h:mm tt')

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like (0)

Report
Copy link

Link copied!

Hey @joel914823

You can write the following similar expression for this:

1)

if(equals(outputs('Get_item')?['body/Complete_x0020_Date'],''),null,formatDateTime(outputs('Get_item')?['body/Complete_x0020_Date'],'M/dd/yyyy h:mm tt'))

2)

if(equals(outputs('Get_item')?['body/Complete_x0020_Date'],null),null,formatDateTime(outputs('Get_item')?['body/Complete_x0020_Date'],'M/dd/yyyy h:mm tt'))

What this will do is if the date is empty then it will add null in the excel sheet. If it has some value it will put according to how you have formatted the date above. Let me know if it works, if not I will give you another expression.

I hope this helps 🙂

Was this reply helpful? Yes No
eliotcole 4,390 Moderator on at

Like (0)

Report
Copy link

Link copied!
Yo, @joel914823 , perhaps place an if() statement in there. 🙂

if( equals(outputs('Get_item')?['body/Complete_x0020_Date'], null), ' ', FormatDateTime( outputs('Get_item')?['body/Complete_x0020_Date'], 'M/dd/yyyy h:mm tt' ) )

Or, if it is potentially having 'blank' values, then you can get a bit more creative with:

if( equals(outputs('Get_item')?['body/Complete_x0020_Date'], null), ' ', if( or( equals(outputs('Get_item')?['body/Complete_x0020_Date'], ''), empty(outputs('Get_item')?['body/Complete_x0020_Date']) ), ' ', FormatDateTime( outputs('Get_item')?['body/Complete_x0020_Date'], 'M/dd/yyyy h:mm tt' ) ) )

Also, not for nothing, mate ... but I don't usually say this ... but it looks like you've taken my advice in the other thread ... if you can mark my (or whomever's!) answer there as the answer then it helps others that turn up to find answers quickly to the same issue. 👍

Was this reply helpful? Yes No