Date/Time from Response Summary in wrong time zone

[TK30]

Hello,

I have a flow that is updating an item within a sharepoint list with Response Summary from approval, but the time displayed is the wrong timezone. Is this a sharepoint/approval setting or do I have do edit the time in the flow?  If I have to edit the time please let me know how.

Thanks

[Anonymous]

Can you please upload the flow picture? SharePoint List Item should be updated with UTC timezone so that it displays your local timezone correctly.

[PrasadAthalye]

Can you please upload the flow picture? SharePoint List Item should be updated with UTC timezone so that it displays your local timezone correctly.

[v-yiwenxie-msft · Accepted solution]

Hi @TK30 

The date/time stored in Response Summary is shown as UTC.

If you want the date/time to show as your time zone, you'll need to use function convertFromUtc() as below:

convertFromUtc(items('Apply_to_each')?['requestDate'],'Pacific Standard Time')

convertFromUtc(items('Apply_to_each')?['responseDate'],'Pacific Standard Time')

For more info about convertFromUtc() and Microsoft supported time zone:

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

Microsoft Time Zone Index Values | Microsoft Docs

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[qaifung_lee]

Hi @v-yiwenxie-msft ,

Can you further explain on this?

I am having the same requirement but do not how can we update the response summary into sharepoint list with correct timezone.

My Flow design:
1. Use "Create and approval-Create an approval- wait for all responses" and "Wiating for an approval".
2. Multiple approvers in this approval flow.
3. After all approvers response, put the response summary into sharepoint list.

Time Zone in Response summary (default timezone):

How to change the timezone and reference in sharepoint.

Note: There are multiple approvers in this flow, we expect insert all approvers response into single field as approver comments.

[almapete21]

I have tried this and it still did not convert the response date and request date. Is there a way to have this fixed? 

Here are the codes I inputted for Compose 4 & 5:

Compose 4: convertFromUtc(items('Apply_to_each_6')?['requestDate'],'Taipei Standard Time')
Compose 5: convertFromUtc(items('Apply_to_each_6')?['responseDate'],'Taipei Standard Time')

[Power_Flow_Your]

Did you every find a solution as same thing is happening to me now

[Anonymous]

I need help on this topic too. Not sure where to insert the step to convert the time. My response summary not showing local time. Hope to get help from the expert in this forum. Thanks in advance

My Flow:

[Blue_Cat82]

I am having this issue also, but it only started recently (like last 1 month). The time and date display correctly in the sharepoint list, but in the Approval App it shows as the wrong time. I feel like some master setting changed for this to all of a sudden change. Also the time in the approval app shows at 2022-05-25T23:30:00Z which is not very user friendly. Is there a better way to format it? TIA

[almapete21]

I did find a solution by putting the Compose action within the Apply to Each where the output is Response (similar to the solution). It should not be in a separated Apply to Each where you will use it (e.g. putting the converted time in Update Items or sending an email notification)

Here's the pic for reference