Forum Discussion
MicrosoftIs there an API to read Microsoft forms data
Until the long awaited API is released, a short term workaround could be to use Power Automate (formerly Microsoft Flow) to trigger when a new form is submitted, and to save the results into a SharePoint list, or Excel file, etc and to manipulate the data from there.
Power Automate puts some pretty cool options for not only extracting the Forms data but to also initiate other actions that can benefit you (e.g. put the results into a Word doc template and email to someone, etc).
Well worth a look!
Cheers
Damien
Damien_Rosario I wouldn't call using Power Automate a workaround; it's designed for the job! And the integrations, as you've pointed out, with Email, SharePoint, Forms, Excel etc etc work beautifully.
Rob
Los Gallardos
Microsoft Power Automate Community Super UserHi RobElliott
Very true, the capability is there with some extra steps to capture the initial submission, but I reckon my suggestion is a workaround until the API comes out as there'll be more direct ways to get data out of Forms with its release.
Cheers
Damien
RobElliottYou can't do everything with Power Automate. For example, I want to create a single webpage where one can enter multiple names and email addresses. They all should get send a link to a form. At the moment you have to create an excel file with the names and email addresses? That's IT from the 90s
helfensdoerfer I never said you could do everything with it and I am often telling people in my company that it can't do this or we need a premium connector for that. But seeing if it can do what you want for a particular task is a reasonable place to start.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- There now appears to be an API for getting some information from Microsoft Forms at https://forms.office.com/formapi/api. I'm not sure when it was released, and I'm having trouble finding documentation on it, but I can at least pull some information in my browser this way. After going to https://forms.office.com/ to login (which sets a token in the browser), I can then browse to https://forms.office.com/formapi/api to get a list of operations or to a specific operation like https://forms.office.com/formapi/api/forms to get a list of my Forms.
ProtivitiDan Any more information about this? I can get JSON responses as you did, but was not successful getting form responses. Wondering if any documentation has appeared anywhere.
waltksfc I abandoned my attempts at the time, but looking at it again now I see that I can get info on a specific form with:
https://forms.office.com/formapi/api/forms/{formid}Then I can get the questions or responses on that form with these:
https://forms.office.com/formapi/api/forms/{formid}/questions https://forms.office.com/formapi/api/forms/{formid}/responsesGet the {formid} from the /forms API call.
