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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

@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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

@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 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No