web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Issue with formatdatetime

Power Automate

Answered

Issue with formatdatetime

(0) Share

Report

Report

Posted on by astrontelstar

287

I have a flow that produces an HTML table. One of the date fields is throwing errors I believe because of a null value.

The field is currently

formatDateTime(item()?['cr014_scheduledtoship'], 'M')

The flow in this area looks like:

I tried using several variations but can't get the syntax for @empty to work.

Can anyone help me with the correct syntax?

Thanks

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @astrontelstar ,

I'd try it as below:

if(empty(item()?['cr014_scheduledtoship']),'',formatDateTime(item()?['cr014_scheduledtoship'], 'M'))

Was this reply helpful? Yes No

Join the conversation