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
Super User
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 anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





2 REPLIES 2
Super User
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 anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





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

Microsoft Flow Online Conference

Join us for a FULL day of FREE Microsoft Flow Sessions from some of the best minds in the industry!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 56 members 4,250 guests
Please welcome our newest community members: