OData filters on O365 Events

[MAW]

Hi MVP's and other Flow experts,

I am starting out with Microsoft Flow and would like help creating a flow that gets upcoming events (in Office 365) and email that asks for them to provide input to agenda items.

The piece I am struggling with is how I filter the 'get Events' action to filter on 1) events I host, 2) within the date range e.g. 7 days ahead. And then, how I handle cases where I have multiple events that meet this criteria.

I'm grateful for any help you can offer - 

M 🙂

[v-bacao-msft · Accepted solution]

Hi @MAW ,

You could use Filter array to filter out eligible events.

• Determine if the email address of Organizer is the same as yours.
• Use addDays() function to add the current date to 7 days and format the event startTime using formatDateTime() function, then compare the two dates for equality.
• Use and() function to combine these two conditions.

Image reference:

Expression reference:

@and(equals(formatDateTime(item()['Start'], 'yyyy-MM-dd'), addDays(utcNow(), 7, 'yyyy-MM-dd')),equals(item()?['Organizer'], 'Test@org.com'))

Please take a try.

Best Regards,