Date from power automate to sharepoint list

(0) Share

Report

Posted on by Lameyzep

Hi all,

I already read several articles but don't find exactly the answer. Or if I have already read it then I have not understood it 😁

I have a Power Automate flow that, among other things, also needs to write a date to a SharePoint list.

The problem is that my date keeps getting reversed. Eg: from Powwer Automate I pass 5 May 2023 (12/5/2023). In Sharepoint, it becomes 5 December 2023 (5/12/2023). Must have something to do with the regional settings ). I have already tried different settings in the browser. Without success

Who can help me.

All responses (3)

Answers (1)

Lameyzep 5 on at

Like (0)

Report

Re: Date from power automate to sharepoint list

This does the trick, thx
lbendlin 7,799 Super User 2025 Season 1 on at

Like (0)

Report

Re: Date from power automate to sharepoint list

Pass the dates in ISO8601 format to avoid this ambiguity.
Verified answer

David_MA 10,664 Super User 2025 Season 1 on at

Like (1)

Report

Re: Date from power automate to sharepoint list

You need to pass the date to SharePoint in ISO8601 format: yyyy-MM-dd. If you do that, the dates should show correctly for you.