Weekly Report Showing Outlook Calendar Meeting Responses

Question

I’m new to PowerAutomate but I’ve managed to create a flow which sends me an automated report showing all meetings for the following week, start/end time, Required Attendee and Response Type. I want to use this to Attendees that have not ‘Accepted’ or have ‘Declined’. The problem is that the Response Type is showing ‘Organizer’ instead. I understand this is because the GetEvent extraction only able to report on the Primary Calendar. Is there any way to get the report to deliver all attendees and their respective responses. I’ve seen something about Microsoft Graph but I don’t have access to this. Please help! It seems like a basic reporting requirement but not so easy to produce.

Answer 1

Hi @SufiaVB, 

Welcome to the Microsoft Q&A forum. 

Thank you for sharing the details. You’re generating a weekly report of next week’s meetings with start/end times and attendees, and the “Response Type” is returning “Organizer” instead of each attendee’s Accept/Tentative/Decline status. I truly appreciate the time you’ve spent building your first flow and documenting the behavior. 

This occurs because the Outlook connector’s Get event action reads the organizer’s primary calendar and does not expose per‑attendee response status in its dynamic content. Attendee responses are stored on the meeting item and are best surfaced by Outlook tracking or the Microsoft Graph APIs rather than the basic connector output. 

Outlined below are practical workarounds for your situation: 

1/ Use outlook tracking (no Graph):  

• Open the meeting in Outlook for Windows or Outlook on the web, go to Tracking, then Copy attendee list to capture names with their current response status.  
• Paste into Excel or a SharePoint list; in Power Automate, add Create table or Create CSV table and include this data in your weekly email. 

2/ Use Graph for a complete report:  

• Ask your Microsoft 365 admin to grant Graph access and register an app with Calendars.Read. 
• In Power Automate, use HTTP with Azure AD to call GET /me/events?$select=subject,start,end,attendees for the upcoming week, parse attendees[].status.response, and build your HTML table for the report. 

3/ If meetings are in shared/secondary calendars:  

• Connect the flow using that mailbox/calendar directly, or query it via Graph as above; primary‑calendar‑only calls won’t return full attendee responses. 

Moreover, if you want to try the Power Automate method, you can consider to visit Microsoft Power Platform Community Forum Thread, Power Automate can help you:   

• Sends an email notification to one or more users with the relevant details  
• Make a weekly report through Outlook calender meeting. 

This is a specific channel related to Power Automate. You'll get the most qualified group of respondents, and other partners who read the forums regularly can share their knowledge or learn from your interaction.   

Apologies for redirecting you to a different community as the members of the posted category focus on users with Microsoft 365 concern and have limited knowledge about Power Automate, so to get a quick and better assistance, let me redirect you in the correct way.   

As community moderators, we appreciate your understanding that our access to internal development details is limited. Our primary role is to guide users toward the appropriate resources and support channels. While we may not have visibility into deeper backend analysis, we’ll continue doing our best to support you within the scope of our responsibilities.    

I hope this information is helpful. Please follow these steps and let me know if it works for you. If you have any updates regarding the issue, please feel free to share them with me.      

Thank you for your patience and your understanding. I look forward to continuing the conversation. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.    

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.