How to convert string dd/mm/yyyy hh:mm to datetime with format dd/mm/yyyy hh:mm

Like (0) Share

Report

Posted on 14 Feb 2021 13:03:27 by Community Power Pla...

Dear Experts

I have been practising with datetime conversion from string to datetime format and I am really struggling

Below the flow

Formatdatetime(variables('DateTime'),'dd/mm/yyyy HH:MM')

but when I run it , I get the following error

Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2437': 'In function 'formatdatetime', the value provided for date time string '14/02/2021 15:32' was not valid. The datetime string must match ISO 8601 format.'.

Any help please?

I have the same question (0)

All responses (6)

Answers (1)

Hardesh15 7,087 Super User 2024 Season 1 on 14 Feb 2021 at 14:59:45

Like (0)

Report

Re: How to convert string dd/mm/yyyy hh:mm to datetime with format dd/mm/yyyy hh:mm

@Anonymous As clear from error message your date is not in ISO 8601 format. you may need to break it apart and rearrange it to the correct formatting to use it as a DateTime string. Make you date in this format- 2021-02-14T11:59:00
2021-02-14T11:59:00Z
20210214T115900Z

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Was this reply helpful? Yes No
Community Power Pla... on 14 Feb 2021 at 15:09:02

Like (0)

Report

Re: How to convert string dd/mm/yyyy hh:mm to datetime with format dd/mm/yyyy hh:mm

That is the error I am getting .. my question is how do I do that ?

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on 14 Feb 2021 at 17:08:55

Like (0)

Report

Re: How to convert string dd/mm/yyyy hh:mm to datetime with format dd/mm/yyyy hh:mm

@Anonymous You need to use split expression here.

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh

Was this reply helpful? Yes No
Verified answer

jinivthakkar 4,181 on 14 Feb 2021 at 17:14:59

Like (2)

Report
Re: How to convert string dd/mm/yyyy hh:mm to datetime with format dd/mm/yyyy hh:mm

@Anonymous

Expressions used
split(variables('Datetime'),' ') split(outputs('Compose_2')[0],'/') formatDateTime(concat(outputs('Compose_4')[2],'-',outputs('Compose_4')[1],'-',outputs('Compose_4')[0],' ',outputs('Compose_2')[1],':00'),'yyyy-MM-dd HH:mm')

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on 14 Feb 2021 at 19:12:15

Like (1)

Report

Re: How to convert string dd/mm/yyyy hh:mm to datetime with format dd/mm/yyyy hh:mm

Thank you Sir, you are a star

Was this reply helpful? Yes No
diegocruzb96 22 on 21 Jul 2023 at 22:10:54

Like (0)

Report

Re: How to convert string dd/mm/yyyy hh:mm to datetime with format dd/mm/yyyy hh:mm

Thanks man !!

Was this reply helpful? Yes No