Formatting Date And time in MS Flow and a SharePoint list

(0) Share

Report

Posted on by smorley

546

I have a SharePoint list with a date field called "Activity Start Date and Time".

My tenant is Atlantic Standard Time. Historically in SPD, I've had to MacGyver things to add 3 hours, or 4, depending on the time of year.

Now with Flow, it looks like I can send reminder emails with using the convert to UTC logic. Only I'm stumbling on the formatting of the dynamic content.

I just want to send an email to the person in charge of the activity reminding them of the date and time.

Please help.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

HI @smorley

Can you please share screenshot of the flow? That way we might be assit you better. You can convert to/from UTC and then use the formatDateTime function to format the date time in any other formatting.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
v-zhos-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @smorley ,

For more information about 'Date and time functions', please take a reference to:

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

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
smorley 546 on at

Like (0)

Report
Copy link

Link copied!

Hi @yashag2255
Here you go:

Was this reply helpful? Yes No
Verified answer

smorley 546 on at

Like (0)

Report
Copy link

Link copied!

I fixed my problem thanks to everyone here and to Dr. Bing. Date/Time Functions help, because our Tenant thinks that we are in the Pacific Time Zone, and we are Atlantic. This blog post helped:
https://worktogether.tech/2018/03/04/working-with-dates-in-microsoft-flow/

A screen shot of my Flow looks like this:

Was this reply helpful? Yes No