Forum Discussion

ravipokala

Copper Contributor

Jun 15, 2020

API to access MS forms

Looking for an API to access MS forms and pull the survey results on a weekly basis.

microsoft forms

Survey

ssahal

Copper Contributor

Nov 30, 2020

Leandro_Abade could you please highlight on how did you obtain the token? Did you have to register in app in Azure portal or by some other way. I am implementing something similar and stuck with the first pre-requisite of obtaining token.

Leandro_Abade

Copper Contributor

Nov 30, 2020

Hi ssahal ! You just need access the URL “https://forms.office.com/Pages/DesignPage.aspx”, then in same section you calls "https://forms.office.com/formapi/DownloadExcelFile.ashx?formid=" + [put your form ID Here] + "&timezoneOffset=180&minResponseId=1&maxResponseId=1000"

The token is automatically generated in the site section.

So, unfortunately, you need to use a browser to use the API. I tried everything to get files using code and nothing worked.

If you find out how to generate the token by code, please share it with us! Tks

ssahal
Copper Contributor
Nov 30, 2020
Sure thing. I am trying to generate the code so I could further process the forms data in an internal workflow. Once I have the full picture will share it with community 🙂
- JimmyStewart
  Brass Contributor
  Dec 07, 2020
  Looking forward to seeing what you come up with. Power Automate is often just to picking up that a form was submitted. So I'm looking at alternatives. Thanks.
  - JTAPPS-1
    Copper Contributor
    Dec 11, 2020
    JimmyStewart
    
    I need a Microsoft Forms API so that I can programmatically create new forms/polls and add them to every Microsoft Teams meeting/invite or click a button during Teams meeting to send form out to all attendees. Each meeting should be able to use a same/similar forms template but generate a new form so that CEO can poll attendees and graph responses. It seems this capability should be here already. Would be nice to be able to generate the form from a forms template on the fly and provide a Microsoft Forms bot to deliver the poll to the user in an interactive format.