Formatting Date using Select Value

[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: 

[Mira_Ghaly · Accepted solution]

@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'))

[koneill2020]

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