News and Announcements icon

Power Platform CommunityForums Power Automate - General Discussion Date Display formatDat...

Power Automate - General Discussion

Answered

Date Display formatDateTime Issues in Loop for Output

Like (0) Share

Report

Report

Posted on 25 Jun 2020 16:46:46 by saturation

203

I'm trying to format my date field for display (basically chop off the time) from a D365 date to put into an email and I'm getting

"The expression is invalid." when I try to do this in the Expressions window. The xxxx_notificationdate is in a Apply to Each loop.

formatDateTime(@{items('Apply_to_each')?['xxxx_notificationdate']},'yyyy-MM-dd')

What am I doing wrong?

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Hardesh15 7,087 Super User 2024 Season 1 on 25 Jun 2020 at 16:57:18

Like (0)

Report

Re: Date Display formatDateTime Issues in Loop for Output

@saturation

Please use this-
formatDateTime(items('Apply_to_each')?['xxxx_notificationdate'],'yyyy-MM-dd')

Thanks
Hardesh

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Quick Links

Leaderboard > Power Automate

#1

Tomac 986 Moderator

#2

stampcoin 699 Super User 2025 Season 2

#3

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans