Unanswered

Power Automate shows a wrong date that differs

(0) Share

Report

Posted on by JoeBloggs

I'm using the flow shown on April Dunnam's channel for "Power Automate SharePoint Get Column Changes", everything is working almost except I'm getting a negative one day variation between the previous and current dates on the fields where a date appears.

In the SharePoint list, the date is displaying as 30/09/2024 (dd/MM/yyyy) which is correct.

In the flow under "Send HTTP request to SharePoint the output of the field after running is "Approval": "2024-09-29T16:00:00Z". I presume this is the server date.

Question, how do I correct the output date to be the same as the SharePoint list date?

_api/web/lists/getByTitle('Approvals Register')/items(@{triggerOutputs()?['body/ID']})/versions(@{outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionID']})

body('Send_an_HTTP_request_to_SharePoint')['d']['Approval']

thanks

Categories:

Building flows

2024-01-02_11-38-...

I have the same question (0)

All responses (3)

Answers (0)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @JoeBloggs

SharePoint stores dates internally in UTC format so when you retrieve it from API or action, it gives timestamp in UTC format. You need to change the time zone as per your need. For that, you could use "Convert time zone" action:

Set the destination time zone as per the need.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
JoeBloggs 13 on at

Like (0)

Report

Hi @ManishSolanki, thank you for the reply.

I have 5 date fields, do I do this at the start of the flow?

Was this reply helpful? Yes No
ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report

Hi @JoeBloggs

You could convert the output datetime value from send an http request to required time zone as per the need. Check the regional settings of the SharePoint site & get the time zone information. Set the same as destination time zone in "Convert time zone" action to get the same value in SharePoint list view. You could add separate actions for converting different datetime value in required time zone.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No