Is there an API to read Microsoft forms data

%3CLINGO-SUB%20id%3D%22lingo-sub-292045%22%20slang%3D%22en-US%22%3EIs%20there%20an%20API%20to%20read%20Microsoft%20forms%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292045%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3Eis%20it%20possible%20to%20read%20Microsoft%20forms%20submitted%20data%20.%20we%20are%20exploring%20concepts%20and%20would%20like%20to%20get%20data%20of%20submitted%20forms%20using%20API.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-292045%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-292633%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20API%20to%20read%20Microsoft%20forms%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292633%22%20slang%3D%22en-US%22%3E%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2010.5pt%3B%22%3EThank%20you%20very%20much%20for%20your%20ask.%20This%20API%26nbsp%3B%20feature%20is%20in%20Microsoft%20Forms%20feature%20backlog%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-819413%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20API%20to%20read%20Microsoft%20forms%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-819413%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20microsoft%20teams%20api%20now%20available%20to%20read%20form%20or%20is%20it%20still%20in%20progress.%3C%2FP%3E%3CP%3EI%20can%20see%20some%20links%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fkaizala%2Factions%2Fkasclient%2Fform_response%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fkaizala%2Factions%2Fkasclient%2Fform_response%3C%2FA%3E%3C%2FP%3E%3CP%3Ewill%20it%20be%20of%20any%20healp%20to%20get%20data%20from%20teams%20forms.%3C%2FP%3E%3CP%3EKindly%20let%20me%20know%20as%20soon%20as%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ESuresh%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1047832%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20API%20to%20read%20Microsoft%20forms%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1047832%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F181367%22%20target%3D%22_blank%22%3E%40Yong%20Qiu%3C%2FA%3E%26nbsp%3BIs%20there%20any%20news%20on%20the%20Forms%20API%2C%20yet%3F%20Or%20is%20there%20an%20estimated%20schedule%2C%20like%20H2%2F2020%20or%20so%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1047959%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20API%20to%20read%20Microsoft%20forms%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1047959%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F397203%22%20target%3D%22_blank%22%3E%40SureshC997%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20your%20link%20is%20for%20Kaizala%20and%20not%20for%20Forms%20or%20Forms%20Pro.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers.%3C%2FP%3E%3CP%3EKyaw%20Kyaw%20Tun%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1048218%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20API%20to%20read%20Microsoft%20forms%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1048218%22%20slang%3D%22en-US%22%3E%3CP%3EUntil%20the%20long%20awaited%20API%20is%20released%2C%20a%20short%20term%20workaround%20could%20be%20to%20use%20Power%20Automate%20(formerly%20Microsoft%20Flow)%20to%20trigger%20when%20a%20new%20form%20is%20submitted%2C%20and%20to%20save%20the%20results%20into%20a%20SharePoint%20list%2C%20or%20Excel%20file%2C%20etc%20and%20to%20manipulate%20the%20data%20from%20there.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPower%20Automate%20puts%20some%20pretty%20cool%20options%20for%20not%20only%20extracting%20the%20Forms%20data%20but%20to%20also%20initiate%20other%20actions%20that%20can%20benefit%20you%20(e.g.%20put%20the%20results%20into%20a%20Word%20doc%20template%20and%20email%20to%20someone%2C%20etc).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWell%20worth%20a%20look!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1049318%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20API%20to%20read%20Microsoft%20forms%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1049318%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%20I%20wouldn't%20call%20using%20Power%20Automate%20a%20workaround%3B%20it's%20designed%20for%20the%20job!%26nbsp%3B%20And%20the%20integrations%2C%20as%20you've%20pointed%20out%2C%20with%20Email%2C%20SharePoint%2C%20Forms%2C%20Excel%20etc%20etc%20work%20beautifully.%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1049391%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20API%20to%20read%20Microsoft%20forms%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1049391%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVery%20true%2C%20the%20capability%20is%20there%20with%20some%20extra%20steps%20to%20capture%20the%20initial%20submission%2C%20but%20I%20reckon%20my%20suggestion%20is%20a%20workaround%20until%20the%20API%20comes%20out%20as%20there'll%20be%20more%20direct%20ways%20to%20get%20data%20out%20of%20Forms%20with%20its%20release.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1524234%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20an%20API%20to%20read%20Microsoft%20forms%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1524234%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F181367%22%20target%3D%22_blank%22%3E%40Yong%20Qiu%3C%2FA%3E%26nbsp%3BIs%20Graph%20able%20to%20pull%20in%20Forms%20APIs%20at%20this%20time%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Microsoft

is it possible to read Microsoft forms submitted data . we are exploring concepts and would like to get data of submitted forms using API.

8 Replies
Highlighted

Thank you very much for your ask. This API  feature is in Microsoft Forms feature backlog

Highlighted

Hi 

Is microsoft teams api now available to read form or is it still in progress.

I can see some links 

https://docs.microsoft.com/en-us/kaizala/actions/kasclient/form_response

will it be of any healp to get data from teams forms.

Kindly let me know as soon as possible.

 

Thanks

Suresh

 

Highlighted

@Yong Qiu Is there any news on the Forms API, yet? Or is there an estimated schedule, like H2/2020 or so?

Highlighted

Hi @SureshC997

 

I think your link is for Kaizala and not for Forms or Forms Pro.

 

Cheers.

Kyaw Kyaw Tun

Highlighted

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  

Highlighted

@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

Highlighted

Hi @Rob Elliott 

 

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

Highlighted

@Yong Qiu Is Graph able to pull in Forms APIs at this time?