cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bapt69
New Member

Extract Time from DateTime

Hey everyone,

I would change DateTime format from [start/DateTime] of my event to Time HH:mm.

 

That's what I got :

2022-10-07_11h27_19.jpg

And that's what I get :

2022-10-07_11h28_00.jpg

 

Other stuff......the flow send me DateTime GMT0. I have to addHours from myself in a formula or the right field exists?

 

PS : my flow -> every day at 8am, I got one notif per event (event from the day that is comin)

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Super User
Super User

Hi @bapt69,

 

I assume you use the Get Events (v4) action to retrieve the event details? And the notification action of your screenshot is within an apply to each loop action?

 

If not, can you share a screenshot of your flow setup?

 

If you are using a Get Events (v4) and an apply to each loop you could use the following expression:

 

 

formatdatetime(item()?['start'], 'HH:mm')

 

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

2 REPLIES 2
Expiscornovus
Super User
Super User

Hi @bapt69,

 

I assume you use the Get Events (v4) action to retrieve the event details? And the notification action of your screenshot is within an apply to each loop action?

 

If not, can you share a screenshot of your flow setup?

 

If you are using a Get Events (v4) and an apply to each loop you could use the following expression:

 

 

formatdatetime(item()?['start'], 'HH:mm')

 

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


bapt69
New Member

Awesome! 😉

That's working...I tried many things and I always forgot the "item()?".

Btw, you're right bout my flow (Schedule -> Get Events -> ApplyEach -> Notification)

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,593)