web

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

Power Platform CommunityForums Power Automate date format issue to I...

Power Automate

Unanswered

date format issue to ISO 8601

(0) Share

Report

Report

Posted on by nick9one1

297

I have a flow that collects data from a completed docusign document. Part f the data is a dat in UK format

  "Employers Liability Insurance Expiry": "04/10/2024",

I need to add this to a sharepoint list date column. I understand it needs to be in ISO 8601 format for this to work.

I have tried the following

formatDateTime(body('Parse_JSON')?['Public Liability Expiry'], 'yyyy-MM-ddTHH:mm:ssZ')

but it outputs the date as

2024-04-10T00:00:00Z

(month and day are reversed)

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

date format issue to ISO 8601

Hi,

Try like this

formatDateTime(parseDateTime(body('Parse_JSON')?['Public Liability Expiry'],'','dd/MM/yyyy'),'yyyy-MM-ddTHH:mm:ssZ')

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,678 Most Valuable Professional on at

Like (1)

Report
date format issue to ISO 8601

Instead of FormatDateTime() you should be using ParseDateTime() so you can specify the locale of the input date. Try this

parseDateTime('04/10/2024', 'en-GB')

Was this reply helpful? Yes No
nick9one1 297 on at

Like (0)

Report

date format issue to ISO 8601

thanks

Was this reply helpful? Yes No
David_MA 12,908 Super User 2025 Season 2 on at

Like (0)

Report

date format issue to ISO 8601

What Pstork1 suggested below should work for you.

Was this reply helpful? Yes No

Join the conversation