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

ODATA query

Hello and thanks in advance for any insight. 

Newb here. 

Tring to create a recurrent flow that reads all calendar events in a particular calendar and then sends out emails. My issue is with quering only today's events. More specifically, i am having a hard time filtering for only todays events on outlook 365 (v2) action and i do not know how to proceed. I trying using the utcNow() expression but it doesn't do anything. 

Any help would be appreciated. 

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: ODATA query

Hi

Can you use an Array Filter action block instead of ODATA expressions?

If so you can try with the following expression inside the Array Filter. It was described in a post more than one year ago, taking into account the huge number of features improved in Microsoft Flow since then, I'm not 100% sure it still works.

 

@equals(substring(item()?['Start'], 0, 10),utcnow('yyyy-MM-dd'))

 

You can also try with "Get calendar view of Events" instead of "Get Events", as described in this Flow Official Blog post

https://flow.microsoft.com/es-es/blog/publishing-and-custom-connectors/

 

If both suggestions match your needs, I would recommend you the last option

Hope this helps





If anyone is trying to help you with an issue, the fastest way to say thanks is by kudoing. Be grateful, Thumbs up!

Proud to be a Flownaut!





View solution in original post

2 REPLIES 2
Dual Super User
Dual Super User

Re: ODATA query

Hi

Can you use an Array Filter action block instead of ODATA expressions?

If so you can try with the following expression inside the Array Filter. It was described in a post more than one year ago, taking into account the huge number of features improved in Microsoft Flow since then, I'm not 100% sure it still works.

 

@equals(substring(item()?['Start'], 0, 10),utcnow('yyyy-MM-dd'))

 

You can also try with "Get calendar view of Events" instead of "Get Events", as described in this Flow Official Blog post

https://flow.microsoft.com/es-es/blog/publishing-and-custom-connectors/

 

If both suggestions match your needs, I would recommend you the last option

Hope this helps





If anyone is trying to help you with an issue, the fastest way to say thanks is by kudoing. Be grateful, Thumbs up!

Proud to be a Flownaut!





View solution in original post

avis
Level: Power Up

Re: ODATA query

Youre a hero!

Thank you. the latter option worked perfectly. 

Have a great day

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

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 Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,680)