Convert string yyyymmdd to a date time stamp

[Oliver_McErlane]

Hi,

I want to convert a string passed to my flow and convert it to a date eg. Monday 12th July

The string is passed in the format yyyymmdd

How can I do this?

Thanks for your help,

Ollie

[ChristianAbata]

hi @Oliver_McErlane  you could use Convert Time Zone

[Oliver_McErlane]

InvalidTemplate. Unable to process template language expressions for action 'Convert_time_zone' at line '1' and column '2871': 'In function 'converttimezone', the value provided for date time string '20200731' was not valid. The datetime string must match ISO 8601 format.'.

[ChristianAbata]

oohh I see youe string is 20200731 so what you need to use is split your date to add a -  to separate your date

[Oliver_McErlane]

What would be the easiest way to convert 20200731 to 2020-07-31?

[ChristianAbata · Accepted solution]

@Oliver_McErlane Here you have my friend

A tutorial https://www.christianabata.com/2020/07/convert-invalid-date-format-into-valid.html

And the flow exported https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Convert-this-date-20200731-into-a-valid-...

I hope this can help

[Oliver_McErlane]

Brilliant!

Thank you! 😀

[ChristianAbata]

@Oliver_McErlane  you are welcome you could like every post if you want jejeje