Unanswered

Struggling with time formats!

(0) Share

Report

Posted on by TheChickening

I'm not a coder, but and Power Automate is just GUI enough for me to get myself in trouble. I've got a flow, hacked from a template that is working for me except for the dang date and time format. The flow grabs an Outlook365 calendar and posts a list of the day's events to a slack channel. But unless people Speak UTC, it ain't pretty. How on earth do I get it to look like "9:00am"?

Here are some expressions I've tried:

formatDateTime(triggerBody()?['Start'],'o'),11,5

formatDateTime('03/15/2018 12:00:00', 'yyyy-MM-ddTHH:mm:ss')

substring(formatDateTime(triggerBody()?['Start'],'o'),11,5)

formatDateTime(convertTimeZone(triggerBody()?['Start'],'GMT Standard Time',triggerBody()?['StartTimeZone']),'yyyy-MM-dd hh:mm')

but all end up throwing an error like this:

Here's my flow in a nutshell:

So I'm suuuure it's something simple, but I've done searching. Any help would be rewarded with a thank you.

-joe

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

eric-cheng 5,171 on at

Like (0)

Report

Hi @TheChickening ,

With date

formatDateTime(utcNow(),'yyyy-MM-dd hh:mm tt')

Without date

formatDateTime(utcNow(),'hh:mm tt')

You can also use the Date Time connector if you dont want to muck around with expressions

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

Was this reply helpful? Yes No
TheChickening 7 on at

Like (0)

Report

That all sounds great, but where in the flow do I put all this?

Was this reply helpful? Yes No
TheChickening 7 on at

Like (0)

Report

Anyone have some basic instruction here they can help me out with?

Was this reply helpful? Yes No
TheChickening 7 on at

Like (0)

Report

Anyone at all know how to simply convert the time format
2021-09-10T15:30:00.0000000
to
8:30am
in the formulas above??

Was this reply helpful? Yes No