Unanswered

Date format from email not working

(1) Share

Report

Posted on by SO-23071509-0

I have set up a PA to copy an email to a sharepoint site the name of the file needs to include the received datetime in a set format as it links from another system with URL.

formatDateTime(triggerOutputs()?['body/receivedDateTime'],'yyyy-MM-dd_hh:mm:ss')

However the format the file name is saving is using _ not : within the time section

What am i doing wrong?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Pstork1 69,037 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

To the best of my knowledge you can't use a colon ':' in a filename. I suspect that is why its replacing it with an underscore '_'

Was this reply helpful? Yes No
David_MA 13,923 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

While the list of invalid characters in filenames in SharePoint has gotten smaller, asPstork pointed out, the colon is still one of them as you can see at https://support.microsoft.com/en-us/office/restrictions-and-limitations-in-onedrive-and-sharepoint-64883a5d-228e-48f5-b3d2-eb39e07630fa#invalidcharacters

Was this reply helpful? Yes No
leonwatson 2 on at

Like (0)

Report
Copy link

Link copied!
Could you provide more details about the issue with the date format in the email? For example:

What is the current format of the date in the email?

What format do you need it to be in?

Was this reply helpful? Yes No