Power Platform Community Forum Thread Details

I hope someone can help me with something that maybe is really easy, but I'm a newbie at Power Automate. I have a flow that get a list of items from sharepoint and send an email with that items in an HTML table. The problem is, that 2 of these items are dates, and when the email arrives the dates are displaying differently on completion time. Can someone tell me in detail how can i fix it in the current flow itself. Really appreciated.

I saw a post someone advising to use Convert to UTC now but as sharepoint always shows in UTC however how do I use the expression in the select tool map itself in completion time to reflect exactly what the sharepoint is showing. Thanks

If you can post the exact expression that would be really helpfull thanks again.

Categories:

Building flows

Hello @CU04061946-0,

the time is different because SharePoint:

1. stores the date in the UTC time zone (7:29)

2. displays in SharePoint using conversion based on your regional settings (+2 hours, 9:29)

3. Power Automate takes the time as it is stored, in the UTC time zone (7:29)

To change the date you need to convert the date, the expression depends on your time zone, for Prague it would be:

convertFromUtc(<theDateDynamicContent>, 'Central Europe Standard Time', 'yyyy-MM-dd HH:mm')

replace the <theDateDynamicContent> with your date column

If you'd like to learn more about conversions and the time zones I wrote an article on this topic.

----------------------------------------------------------------------------------
Did the answer solve your problem? Please click "Does this answer your question" to help others find the solution too!

You can find more of my solutions on my blog https://tomriha.com