web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Formatting Date using ...

Power Automate

Answered

Formatting Date using Select Value

(0) Share

Report

Report

Posted on by koneill2020

All,

In the below - I am trying to use the formatDate command to show the dates formatted in the general format (example: 3/29/2021 1:45 PM) as when I have the SharePoint fields Start Date and End Date in the Select it shows them formatted as such for example: 2022-03-29T17:00:00Z and I'm trying to format them nicely - therefore what is the syntax for this that is best to accomplish what I'm trying to do:

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Mira Ghaly 11,415 Moderator on at

Like (2)

Report
Copy link

Link copied!
@koneill2020

This is the expression that you should be using, replace the format with whatever your format is and start date with the correct column names in sharepoint.

if(equals(item()?['StartDate'],null),'',formatDateTime(item()?['StartDate'],'dd-MM-yyyy'))

Was this reply helpful? Yes No
koneill2020 on at

Like (0)

Report
Copy link

Link copied!

@Mira_Ghaly Many thanks! These logic aspects like that - I always struggle with.

Was this reply helpful? Yes No

Join the conversation