Extract microsoft forms responses data using API

Question

Hi,

I am looking to extract responses data submitted to Microsoft forms using an API based solution. I am using Azure stack - ADF for orchestration.

I am not sure if this is supported by Microsoft using Graph API.

Answer 1

Hi,

Just to say that you can do this easily via the Forms rest API under the scope forms.office.com/.default.

the entra app registration permissions are under "APIs my org users, Microsoft Forms"

you will need to aquire a seperate auth token for the forms scope & switch it back and forth between graph and forms usage.

the forms URI is as follows

JSON

https://forms.office.com/formapi/api/<tenantid>/users/<userid>/light/forms('<formid>')/responses

hope this helps

Answer 2

Dear @Prasad Khedkar,
Thank you for posting your question in the Microsoft Q&A forum.

I understand you're looking to extract response data submitted to Microsoft Forms using an API-based solution, and you're currently orchestrating this process with Azure Data Factory (ADF).

At this time, Microsoft Graph API does not provide a supported endpoint to directly retrieve Microsoft Forms responses. While this feature has been requested by many users, it is not yet available in the official Microsoft Graph API.

I recommend a workaround that using Power Automate to capture each new form response and store it in a SharePoint Online List, Azure SQL Database, or another supported data source. Azure Data Factory can then connect to that location using its built-in connectors to automate further processing.

However, this Q&A forum is dedicated to Microsoft 365 and Office-related topics. And I do not have enough resource and testing environment to test the flow. Since Power Automate is part of the Power Platform, I recommend post your questions about Power Automate flows or connectors in the Power Platform Community forums. There are many experts in Power Automate, who may give you good advice.

Moreover, I want you to know that Microsoft deeply values customer experience and feedback. Every single comment matter, and the product teams actively review what customers share to guide decisions and improvements. Your voice is powerful here, and I encourage you to make it heard through the official feedback channels. Therefore, to ensure your feedback reaches the right teams, I highly recommend submitting your feedback directly to Microsoft Ideas · Community, where our product development team can know your requirements and ideas for product improvements. If enough users raise ticket for the same idea, Microsoft may consider adding this feature in the future.

Note: As Microsoft Community moderators, please note that we are not involved in product design decisions and do not have direct access to the development roadmap, we want to assure you that your feedback has been acknowledged and is valued.

However, you can rest assured that you are not alone, I’ll continue to monitor this case and will reach out to you with any new updates as soon as possible. If any updates or announcements are made regarding this feature, I will make sure to share them with you as soon as possible.

I understand this may not be the outcome you were hoping for. I truly appreciate your patience and understanding. If you have any further questions or need further clarification, please feel free to reach out. I'm looking forward to hearing from you.

Thank you for your cooperation.

---

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.

Answer 3

Microsoft Forms responses can be programmatically extracted, but not directly via a dedicated Microsoft Forms Graph API endpoint.

Supported options from the provided information:

1. Use Microsoft Forms + Excel workbook
   • Each form’s responses can be opened in Excel from the Responses tab by selecting Open in Excel.
   • This creates or updates an Excel workbook stored in OneDrive for work or school or SharePoint Online, depending on whether the form is personal or group-based.
   • From there, Azure Data Factory (ADF) can connect to the Excel file in OneDrive/SharePoint (using supported connectors) and ingest the responses data into downstream systems.
2. Use eDiscovery for compliance/export scenarios
   • Microsoft Forms content (form definitions and responses) is discoverable via Microsoft Purview eDiscovery in supported environments.
   • Forms definitions and responses are stored in Exchange mailboxes (form creator’s mailbox or the associated Microsoft 365 Group mailbox).
   • In eDiscovery, a case and search can be created targeting:
     • The form creator’s Exchange mailbox, or
     • The Microsoft 365 Group mailbox when the form is associated with a Group/Team.
   • Use the Microsoft Forms type in the query builder or KQL with ItemClass="IPM.File.Forms" to find Forms definitions and responses.
   • Search results can then be exported; forms are returned as .json files and responses as .csv files attached to emails. These exports can be further processed by ADF once stored in a supported location.
3. Direct Graph API for Forms responses
   • The provided material does not describe a Microsoft Graph API endpoint that directly returns Microsoft Forms responses.
   • The recommended patterns in the context rely on Excel workbooks (for operational analytics) or eDiscovery exports (for compliance/DSR scenarios), not a Forms-specific Graph API.

For an ADF-based solution today, the supported pattern in the context is:

1. Ensure the form is configured so that responses are written to an Excel workbook in OneDrive/SharePoint (via Open in Excel).
2. Use ADF to connect to that workbook and extract/sync the responses data into the desired data store.

---

References:

• How do I export my form responses?
• Microsoft Forms and Excel workbooks
• Microsoft Forms service description
• GDPR information
• Search and review Microsoft Forms data with eDiscovery