Unanswered

How can I convert long-format datetime strings?

(0) Share

Report

Posted on by toyg_onestream

I receive a string like this:

Saturday, July 31, 2021 1:35 AM | (UTC+01:00) Dublin, Edinburgh, Lisbon, London

I need to convert it to the format Sharepoint expects, i.e. a ISO 8601 for UTC:

YYYY-MM-DDTHH:MM:SS

I painfully built a flow that does most of the work, rearranging everything before the pipe to the expected format; however, at the thought of having to manually manage the timezone offset my heart finally gave out.

So my question is: what's the easiest way to parse this datetime correctly in PA/Flow...?

Categories:

Building flows

All responses (4)

Answers (0)

Sort by

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @toyg_onestream,

I gave this a shot with a couple of split functions.

Can you try this expression and test if it works properly?

formatDateTime(formatDateTime(concat(split('Saturday, July 31, 2021 1:35 AM | (UTC+01:00) Dublin, Edinburgh, Lisbon, London', ' | ' )[0], split(split('Saturday, July 31, 2021 1:35 AM | (UTC+01:00) Dublin, Edinburgh, Lisbon, London', 'UTC' )[1], ')')[0]), 'dddd, dd MMMM yyyy HH:mm'), 's')
Powerplatform01 386 on at

Like
a
(0)

Report
Copy link

Link copied!

@toyg_onestream
You can take reference from this Video.Also request you to please subscribe this channel.

https://youtu.be/NLEMPn-T3ns
Let me know in case of further help
toyg_onestream 2 on at

Like
a
(0)

Report
Copy link

Link copied!
So what you're saying it basically that the string
Saturday, July 31, 2021 1:35 AM +01:00
will be correctly interpreted as a UTC-based datetime by formatDateTime, which I can then reformat it as I see fit...?
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @toyg_onestream,

I haven't tested it with all the date time format patterns, but with the sortable format (s) it should work:

https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings

You can even test it with this expression:

formatDateTime('Saturday, July 31, 2021 1:35 AM +01:00', 's')