Unanswered

Invalid expression - format date time

(0) Share

Report

Posted on by Linn1

Hi,

I have a folder that creates a project folder in SharePoint when a project is added to a project list in SharePoint. I am trying to name the project folder with [Start Date] [Project Title] - but want to format the Start Date with yyyyMM. Trying this expression:

formatDateTime(['triggerOutputs()?['body/Start_x0020_Date']'],'yyyyMM')

But gets that it is invalid. Anyone who can help?

Thanks!!

Categories:

General topics

All responses (3)

Answers (0)

Sort by

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

Couple of things.
1. Can you share the run, with the error, also showing the input and outputs of the action with the error.
2. If your field is a Date (a true date), then you have to wrap it in string() as the first parameter is a string, not a date
formatDateTime(string(['triggerOutputs()?['body/Start_x0020_Date']']),'yyyyMM')

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Linn1 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I tried to wrap the date in a string () but I am still getting the error. I have not tested the run with the expression because it not allows me to save it as the "expression is invalid".
Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I am still not even sure which Action is giving you the issue. Can you please post a picture that clearly shows which one it is.

Please be super clear. Show every value that you are typing in, if its the Compose folder name.
And if you take out the Date part you are trying to add, do you still get the expression error or does it go away?
I am assuming you typed it in the Expression window and then switched to the Dynamic to add the Property?

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey