News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Issue with formatdatetime

Power Automate - Building Flows

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

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

tom_riha 10,127 Most Valuable Professional on at

Like (0)

Report
Re: Issue with formatdatetime

Hello @astrontelstar ,

I'd try it as below:

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

Helpful resources

News and Announcements

Upwork and Microsoft Power Platform Partnership

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 566 Super User 2025 Season 1

#2

David_MA 516 Super User 2025 Season 1

#3

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans