Hey guys,
I am trying to format the date for my "Select" Action. It displays the year as 2021-11-27 instead of 11/27/2021.
I have tried: formatDateTime('Date_x0020_out_x0020_of_x0020_th', MM/dd/yyyy)
But I end up with the following error message:
"The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{
"Staff Member": "@item()?['Staff_x0020_Name/Value']",
"Date Out of Office": "@formatDateTime('Date_x0020_out_x0020_of_x0020_th', 'MM/dd/yyyy')"
}' failed: 'In function 'formatDateTime', the value provided for date time string 'Date_x0020_out_x0020_of_x0020_th' was not valid. The datetime string must match ISO 8601 format."
The date is converted earlier in the app in the "Get Items" action using the Filter Query and it displays correctly. When it goes to the "Select" action it shows again as 2021-11-27. This is the expression that I used:
"formatdatetime(convertFromUtc(utcnow(),'Central Standard Time'),'MM-dd-yyyy')"
"Staff_x0020_Name": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 3,
"Value": "John Smith"
"Staff_x0020_Name#Id": 3,
"Date_x0020_out_x0020_of_x0020_th": "2021-11-27",
I appreciate any help you can give me.
