News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Query Calendar ExpandC...

Customer experience | Sales, Customer Insights,...

Suggested answer

Query Calendar ExpandCalendar function via Power Automate

(0) Share

Report

Report

Posted on by ___Pool___

2

There'a Queue Calendar where our user can define the Operating Hours of a group of users, talking about this:

I found that with the following odata query

https://[...]/api/data/v9.0/calendars(08d3aaa7-9453-ed11-bba2-000d3adf73bc)/Microsoft.Dynamics.CRM.ExpandCalendar(Start=@d1,End=@d2)?@d1=2022-11-03T00:00:00.000Z&@d2=2022-11-03T23:59:59.999Z

I can get the working hours, breaks for a given date range [d1,d2] using the following function

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/reference/expandcalendar?view=dataverse-latest

is it possible to query this endpoint in Power Automate?

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

a33ik 84,325 Most Valuable Professional on at

Like (1)

Report

RE: Query Calendar ExpandCalendar function via Power Automate

Hello,

If OOB connector doesn't allow you to call that function you can try to use HTTP request with Azure AD Auth. Check this article - www.itaintboring.com/.../

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard

#1

André Arnaud de Cal... 292,907 Super User 2025 Season 1

#2

Martin Dráb 231,777 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans