cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Livearus
Helper III
Helper III

Get Calendar View of events from the past

Hello, everyone,

 

how to set the "Start Time" for "Get calendar view of events" to the last 7 days. I would like to see all events of the past 2 weeks.

 

In addition, only events that have been canceled should be output.

 

I know about the query for the current events, but I can't get any further.

 

Screenshot_PA_CalendarEventsCancel.png

4 REPLIES 4
Expiscornovus
Super User
Super User

Hi @Livearus,

 

You can use expressions for the Startzeit und endzeit fields and use the adddays function to calculate a date in the past.

 

Use something like below and add them via the expression tab.

 

In my example I am looking back 14 days.

 

Startzeit

 

addDays(utcNow(), -14, 'yyyy-MM-ddTHH:mm:ss')

 

 

Endzeit

 

utcNow('yyyy-MM-ddTHH:mm:ss')

 

 

expression_startenddate.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Livearus
Helper III
Helper III

Okay many thanks. It was somehow obvious. Can you also tell me what the correct filter query looks like for me? As I said, I would only like to have appointments issued that have been cancelled. So I think I need to filter by "Cancelled" in the subject? However, I only get error messages:

 

Example: subject eq 'Cancelled' or subject eq 'Cancel' - Subject does not exist
Example: subject contains 'Cancelled' - Subject does not exist
Example: contains(subject,'Cancelled')Is not allowed here

 

Expiscornovus
Super User
Super User

Hi @Livearus,

 

Did you cancel the appointments (as an organiser) or did somebody else cancel them?

 

In the first scenario the appointment would not be part of the view anymore and I think the events would not be part of the view of listed events.



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Livearus
Helper III
Helper III

Scenario 2 applies. Someone else canceled the events. I'm not an organizer.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,043)