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 🙂
Solved! Go to Solution.
Hi @MAW ,
You could use Filter array to filter out eligible events.
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,
Hi @MAW ,
You could use Filter array to filter out eligible events.
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,
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
42 | |
37 | |
36 | |
23 |
User | Count |
---|---|
41 | |
39 | |
30 | |
29 | |
29 |