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

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
efialttes
Super User III
Super User III

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

2 REPLIES 2
efialttes
Super User III
Super User III

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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Youre a hero!

Thank you. the latter option worked perfectly. 

Have a great day

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,900)