web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate FormatDateTime - null

Power Automate

Unanswered

FormatDateTime - null

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sundeep_Malik 6,499 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

Join the conversation