Need help formatting date (MM/dd/yyyy) for my Application

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!
Hi!
I would try with the following expression:

formatDateTime(item()?['Date_x0020_out_x0020_of_x0020_th'], 'MM/dd/yyyy')

Hope this helps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank You so much!!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

SO I ran the app with no problem and it worked as expected. I then began to get error messages later on for some reason. Can you please help me?

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous
I would doublecheck if 'Central Standard Time' is between the values allowed by Microsoft. You will find the full list in the following link
Default Time Zones | Microsoft Docs
If the problem persist, my suggestion is to open a new thread following the rule 'one issue, one topic', the reason is unattended, unsolved topics attrack the attention of more superusers, and this one already have several responses.
Thanx for your help making this community great!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

It worked with no problem before I made the change that you suggested. I just re-added the original dynamic value and it did not throw any errors. It has to be some correlation between what you suggested and the filter query code of the "Get Items" action. It obviously does not play well together. I really do appreciate any help you can give me.

Was this reply helpful? Yes No