Answered

Retrieving Events from a Group calendar

(0) Share

Report

Posted on by LJ-20021816-0

My end-goal is to retrieve a list of events on our group calendar every Monday. This list of events would include any in the time of "Current Time" to "7 Days in the Future". I have been able to successfully test a flow that has a recurrence, current time, get future time, and Send an HTTP request V2; however, I cannot get past this point. Copilot hasn't been very helpful.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report
I do it this way:

Trigger scheduled flow as you outline in your post.

Use two compose actions to create the dates for the start and end time frame.

Start expression: startOfDay(utcNow(),'yyyy-MM-dd')

Compose action named Compose Start

End expression: addDays(startOfDay(utcNow()),31,'yyyy-MM-dd')

Update 31 to 7 or your desired timeframe.

Compose action named Compose End

Send an HTTP request to the Graph API using the Groups HTTPs action.

Use this in the URI: https://graph.microsoft.com/v1.0/users/emailaddressofcalendar@company.com/calendar/events?$filter=(start/dateTime ge '@{outputs('Compose_Start')}T00:00:00' AND start/dateTime lt '@{outputs('Compose_End')}T00:00:00')&$orderby=start/dateTime

Update the highlighted portion to the e-mail address of the group calendar.

Add a parse JSON action so you can get the values from the HTTP request. I have attached the scheme to a text file. If this doesn't work, you'll need to generate the scheme from sample data.

Add a condition to see if there were any events found.

Use this expression on the left side of the condition: length(body('Parse_JSON')?['value'])

Set the logic to is greater than 0

Add a Select action on the yes side of the condition and use the body value from the Parse JSON action.

I then map it this way, but you can set it up to meet your needs:

Add a Create HTML table action from the output of the select action.

To e-mail this, put the e-mail action into HTML mode and use this expression to insert the table into the e-mail: replace(replace(replace(body('Create_HTML_table'),'<','<'),'>','>'),'"','"')

You may need to add some custom CSS to format the table depending on your needs.

Your flow will look like this:

The crossed-out actions are specific to my process.

jsonscheme.txt

Was this reply helpful? Yes No
LJ-20021816-0 12 on at

Like (0)

Report

Thank you, David! I followed your steps, but ran into this error message at the "Send an HTTP request V2" step:

"Invalid filter clause: A binary operator with incompatible types was detected. Found operand types 'Edm.String' and 'Edm.Date' for operator kind 'GreaterThanOrEqual'."

This was the input of my expression (calendar ID hidden for privacy):

https://graph.microsoft.com/v1.0/groups/calendar ID/calendar/events?$filter=(start/dateTime ge 2025-02-20 AND start/dateTime lt 2025-02-27)&$orderby=start/dateTime

This is the URI:

https://graph.microsoft.com/v1.0/groups/calendar ID/calendar/events?$filter=(start/dateTime ge @{outputs('Compose_Start')} AND start/dateTime lt @{outputs('Compose_End')})&$orderby=start/dateTime

What did I miss?

Was this reply helpful? Yes No
Verified answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

Look closely at the URI in my post:

https://graph.microsoft.com/v1.0/users/emailaddressofcalendar@company.com/calendar/events?$filter=(start/dateTime ge '@{outputs('Compose_Start')}T00:00:00' AND start/dateTime lt '@{outputs('Compose_End')}T00:00:00')&$orderby=start/dateTime

The filter values are in single quotes and you are missing the time portion. This is important and they appear to be missing based on your post. If you still have trouble after adjusting for this, you'll need to include screen shots of how you configured your actions as that is the only way I can see what you may have done incorrectly.

If you configure the two compose actions as I listed below with the same names, you should be able to copy and paste my expressions into Power Automate and avoid this problem.

Was this reply helpful? Yes No
LJ-20021816-0 12 on at

Like (0)

Report

That fixed it! Now, for the "If Yes" section. It will let me add the Select feature, but as soon as I put the Body of the ParseJSON into the From field, it moves it to an "Apply to Each". Is that a problem?

The tests are successful, but it isn't pulling in any events (when I know there should be at least 1 in the next 7 days). On my Condition New Events Found step, this is my expression. The results from the test say that it is false.

Thank you so much for all of your help! This has been a lifesaver. I've struggled with this project off and on for almost 3 months.

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (0)

Report

Delete the apply to each action and note the value used in the Parse JSON action in the apply to each. You want to put that value (Body) into the select action and not value.

Was this reply helpful? Yes No
LJ-20021816-0 12 on at

Like (0)

Report

I thought a screen recording might help. What am I missing?

Recording-2025022...

Was this reply helpful? Yes No