Unanswered

date format issues - iso 8601

(0) Share

Report

Posted on by ahhollan

576

I have an excel list that i'm taking and creating a sharepoint item for each row. The problem is that the dates for Start and End are in format '9/26/2023 10:00 AM Eastern' and I can't figure out how to convert it to ISO 8601 so that i can create a teams meeting in the flow. I appreciate any help you can give.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
I assume "Eastern" is EST

convertToUtc( parseDateTime( replace('9/26/2023 10:00 AM Eastern', ' Eastern', ''), 'us-en', 'M/d/yyyy hh:mm tt' ), 'Eastern Standard Time' )

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report
What if I want to replace below with the actual column name so that all rows and values are processed?
'9/26/2023 10:00 AM Eastern'

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report
Maybe better without using replace but "Eastern" in the format string

convertToUtc( parseDateTime( '9/26/2023 10:00 AM Eastern', 'us-en', 'M/d/yyyy hh:mm tt "Eastern"' ), 'Eastern Standard Time' )

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

What is your column name? Are you processing this in a loop? In a Select?

Maybe you should show some of your flow.

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report

Column name is 'Start' for start date. I'm processing in a loop for each item.
Spreadsheet columns look like this:

Was this reply helpful? Yes No
Verified answer

Chriddle 8,436 Super User 2025 Season 2 on at

Like (1)

Report
Here it should be items('Apply_to_each')['Start']

So the expression would be

convertToUtc( parseDateTime( items('Apply_to_each')['Start'], 'us-en', 'M/d/yyyy hh:mm tt "Eastern"' ), 'Eastern Standard Time' )

In general:

Put the cursor to the input where you want to place the reformatted date

Switch to expression

Paste my expression

Delete the date string from this expression (pay attention to the cursor position)

Switch to Dynamic Content

Click the value from the Dynamic Content

Was this reply helpful? Yes No
ahhollan 576 on at

Like (0)

Report

I'm getting the following error now - Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Create_item' at line '1 and column '5109' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Create_item' to be referenced by 'repeatItems' or 'items' functions.'.'.
When I paste the formula in the expression box, I don't see 'Start' as available dynamic content when I go to that tab.

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Have you renamed the Apply to each action?

In the screenshot above "Start" is present 😉

Also the fact that the error message says "Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Create_item'" implies, that you have changed somthing.

Was this reply helpful? Yes No