Convert Date String "25 Sep 2021" to Date

(0) Share

Report

Posted on by Amapola188

296

Good Morning

I'm trying to parse information from the body of an email to create a SharePoint entry. The email contains a date that formatted "d mmm yyyy", so today would be "25 Sep 2021".

How can I convert that to a date that SharePoint can receive? All questions and answers on this topic I can find seem to deal with dates in 25/9/2021 format and my month is not a number so I don't know how to deal with that.

Thanks,

Christine

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Amapola188

Please see this post

Solved: Convert string (01 Sep 2006) to Date - Power Platform Community (microsoft.com)

Thanks

Was this reply helpful? Yes No
Amapola188 296 on at

Like (1)

Report

@abm I hadn't even considered that it could be so easy!

Thank you!

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report

Hi @Amapola188

What is the date format you are looking for?

The formatDateTime function can give you just that

Example: 1
Are you taking small case m instead of M

If expression is
formatDateTime(triggerBody()['text'],'dd/M/yyyy')

Output is

Example 2:
If expression is
formatDateTime(triggerBody()['text'],'dd/MM/yyyy hh:mm:ss')

Output is

Example 3:
If expressions is
concat(formatDateTime(triggerBody()['text'],'dd-MM-yyyy'),'T',formatDateTime(triggerBody()['text'],'hh:mm:ss'),'Z')

Output is

Example 4:
You can add the T within the Input box itself

-------------------------------------------
Help fellow beings find relevant posts.
Upvote to a supporting response.
Mark as solution to an answer.

Was this reply helpful? Yes No
Amapola188 296 on at

Like (0)

Report

Thanks, @VJR. Convert Time Zone did whatever was needed. To be honest, not sure what was needed. Sharepoint needed to accept the date ..

Was this reply helpful? Yes No