Dates in the sharepoint list are off by a day when generated in an email via flow

(0) Share

Report

Posted on by oaghaei

173

Issue: Some (not all) dates are piped into an email from a sharepoint list are incorrect (off by a day)

Here is my flow:

Here is what I have for the deadline:

formatDateTime(item()?['Deadline'],'MM/dd/yyyy')

This flow creates a list that I get in my email that looks like this:

However, some dates are imported from Sharepoint correctly, while others are off by a day (one day later than they actually are). In the same example, the highlighted dates are behind one day.

I wonder if this is because I need to convert the time? If so, is there a formula someone can help me figure out how to write it to ensure dates are all coming in correctly?

Thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Hello @oaghaei ,
please try to use the "Convert time zone" action:

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
oaghaei 173 on at

Like (0)

Report

Hello @MarconettiMarco thank you for your reply. I did try that in the past, but I ran into this error. Once I convert the time then i cant seem to be able to use "current item" that contains the converted time in the select function.

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Hello @oaghaei, you should put the output form the previous action instead of the current item.

BR,
Marco

Was this reply helpful? Yes No
oaghaei 173 on at

Like (0)

Report

@MarconettiMarco When I move all subsequent outputs into the previous action under "Apply to each", I end up with multiple emails (one per each line item), instead of in a table in one email.

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (0)

Report
Hi @oaghaei ,

Maybe you could try to convert time zone using expression instead of Action.

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#convertfromutc

I have made a simple test for your reference.

1. Here is my SharePoint list.

2. Here is my flow.

formatDateTime(item()?['Deadline'],'MM/dd/yyyy')
convertFromUtc(item()?['Deadline'],'Pacific Standard Time','MM/dd/yyyy')
convertTimeZone(item()?['Deadline'],'UTC','Pacific Standard Time','MM/dd/yyyy')
addHours(item()?['Deadline'],-7,'MM/dd/yyyy')

Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
oaghaei 173 on at

Like (0)

Report

@v-yujincui-msft Charlie, you are awesome! The expression is what I needed. I used the expression for Deadline 1. Now, can you tell me what is the purpose of the Deadline 2 and 3 expressions since they all produce the same outcome? Or are they all different ways of getting to the same result? I wonder if you have a preference.
Again, thank you so much!!

Was this reply helpful? Yes No
v-yujincui-msft on at

Like (0)

Report

Hi @oaghaei ,

I just want to give you more options, all three expressions are available. I prefer to use the first, followed by the second.

Best Regards,

Charlie Choi

Was this reply helpful? Yes No
oaghaei 173 on at

Like (0)

Report

@v-yujincui-msft - got it, makes sense. Thanks so much again!! I appreciate it.

Was this reply helpful? Yes No