Forum Discussion
Is 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 User