web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate The datetime string mu...

Power Automate

Unanswered

The datetime string must match ISO 8601 format

(0) Share

Report

Report

Posted on by SM_11

29

I have a column with date and time in excel and there are empty values. I need to export the table into the Sharepoint list. I used an expression:

if(empty(items('Apply_to_each')?['Date']), null, formatDateTime(item()?['Date'], 'yyyy-MM-dd HH:mm tt'))

but got an error. How can I solve this?

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

schwibach 2 Moderator on at

Like (0)

Report

Re: The datetime string must match ISO 8601 format

The string will need to look like this.
2022-01-13T00:00:00.0000000

So, you're almost there. Just concatenate the individual parts to conform with that example.

Was this reply helpful? Yes No
SM_11 29 on at

Like (0)

Report
Re: The datetime string must match ISO 8601 format

Hi, thank you for the reply. Could you help me with expression? I know expression for dd/mm/yyyy:
concat(split(item()?['Date'],'/')[2],'/',split(item()?['Date'],'/')[1],'/',split(item()?['Date'],'/')[0])
but I don't understand how to make formula for date with time. Thank you in advance

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (0)

Report
Re: The datetime string must match ISO 8601 format

Hi @SM_11

You can try this formula:

if(empty(items('Apply_to_each')?['Date']),null,formatDateTime(concat(split(items('Apply_to_each')?['Date'],'/')[1],'/',split(items('Apply_to_each')?['Date'],'/')[0],'/',split(items('Apply_to_each')?['Date'],'/')[2]),'yyyy-MM-dd HH:mm'))

Best Regards,

Levi

Was this reply helpful? Yes No

Join the conversation