cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nick_v
Level: Power Up

Trigger an event if a meeting occurs before or after a specific time of day

I'm a little unsure how to use the available logic to create a filter for the time of day of the beginning or end time of an Event created in an Office365 calendar.

 

For example, I would like flow to create an event on my personal calendar (Outlook.com) if an event is created on my work calendar that starts before or after business hours (if event is before 9am, add it to my personal calendar, if after 5pm, add it to my personal calendar, else do nothing).

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Trigger an event if a meeting occurs before or after a specific time of day

Hi @nick_v,

 

From the workflow definition language site, you could see that the less/greater function only support for integer, float, or string.

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

 

So you need to first using the formatDateTime function to format the dynamic content to only time pattern, and then use the less/greater function to compare.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Trigger an event if a meeting occurs before or after a specific time of day

Hi @nick_v,

 

From the workflow definition language site, you could see that the less/greater function only support for integer, float, or string.

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

 

So you need to first using the formatDateTime function to format the dynamic content to only time pattern, and then use the less/greater function to compare.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,014)