SOLVED

Where are Teams in-channel Forms responses stored?

%3CLINGO-SUB%20id%3D%22lingo-sub-2119138%22%20slang%3D%22en-US%22%3EWhere%20are%20Teams%20in-channel%20Forms%20responses%20stored%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119138%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20creating%20a%20Form%20via%20the%20standard%20route%2C%20I%20can%20access%20Forms%20responses%20and%20export%20to%20an%20Excel%20doc.%20When%20creating%20a%20Form%20within%20Teams%2C%20can%20I%20later%20access%20the%20results%20in%20a%20similar%20way%3F%20It%20seems%20I%20can%20just%20see%20a%20card%20that%20displays%20results%2C%20which%20is%20fine%20for%20most%20cases.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2119138%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETeams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2120906%22%20slang%3D%22en-US%22%3ERe%3A%20Where%20are%20Teams%20in-channel%20Forms%20responses%20stored%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120906%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F942392%22%20target%3D%22_blank%22%3E%40CoasterKaty%3C%2FA%3EOh%20wow!%20I%20swear%20I%20didn't%20even%20see%20that%20yesterday%20%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%400277EEB71C55CDE7DB26DB254BF2F52B%2Fimages%2Femoticons%2Flaugh_40x40.gif%22%20alt%3D%22%3Alol%3A%22%20title%3D%22%3Alol%3A%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2120902%22%20slang%3D%22en-US%22%3ERe%3A%20Where%20are%20Teams%20in-channel%20Forms%20responses%20stored%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120902%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960963%22%20target%3D%22_blank%22%3E%40CoreySCallahan%3C%2FA%3E%26nbsp%3BOh%20-%20I%20didn't%20even%20know%20you%20could%20add%20a%20form%20that%20way!%20Just%20had%20a%20go%20and%20the%20form%20itself%20is%20saved%20in%20%22My%20Forms%22%20for%20whoever%20created%20it%2C%20so%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.office.com%2Flaunch%2Fforms%2Fmyforms%3Fauth%3D2%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.office.com%2Flaunch%2Fforms%2Fmyforms%3Fauth%3D2%3C%2FA%3E%26nbsp%3Band%20you%20should%20see%20it%20in%20there%2C%20named%20after%20the%20question%2C%20from%20in%20there%20you%20can%20go%20into%20Responses%20and%20export%20to%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2120704%22%20slang%3D%22en-US%22%3ERe%3A%20Where%20are%20Teams%20in-channel%20Forms%20responses%20stored%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2120704%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F942392%22%20target%3D%22_blank%22%3E%40CoasterKaty%3C%2FA%3EThis%20makes%20sense%20and%20seems%20to%20be%20the%20better%20way%20to%20create%20Forms.%20When%20I%20create%20one%20within%20the%20normal%20messaging%20toolbar%20(pictured)%2C%20it%20seems%20to%20maybe%20be%20a%20slimmed%20down%20Form.%20Pre-making%20the%20Form%20seems%20to%20be%20better%20option.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20appreciate%20your%20help!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-02-10%20at%201.02.22%20PM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F253961i5B718E65A54A3774%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-02-10%20at%201.02.22%20PM.png%22%20alt%3D%22Screen%20Shot%202021-02-10%20at%201.02.22%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2119534%22%20slang%3D%22en-US%22%3ERe%3A%20Where%20are%20Teams%20in-channel%20Forms%20responses%20stored%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119534%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960963%22%20target%3D%22_blank%22%3E%40CoreySCallahan%3C%2FA%3E%26nbsp%3BThey%20don't%20seem%20to%20be%20stored%20anywhere%20that's%20accessible%20from%20SharePoint%2C%20but%20you%20can%20still%20get%20at%20the%20results%20data%20in%20the%20normal%20way%20and%20export%20to%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I've%20just%20tried%20it%20now%20I've%20hit%20the%20%2B%20on%20the%20tabs%20at%20the%20top%2C%20then%20added%20a%20new%20form%20which%20gave%20me%20a%20tab%20called%20%22Edit%20%7C%20Test%20form%22%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CoasterKaty_2-1612906496514.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F253723i46394E4966B82D89%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CoasterKaty_2-1612906496514.png%22%20alt%3D%22CoasterKaty_2-1612906496514.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere's%20three%20different%20types%20of%20form%20tab%20you%20can%20have%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Edit%3A%20edit%20the%20questions%20and%20view%20responses%20with%20the%20%22export%20to%20excel%22%20button%3C%2FP%3E%3CP%3E-%20Results%3A%20Card%20showing%20the%20results%20in%20a%20simpler%20view%20with%20no%20option%20to%20export%3C%2FP%3E%3CP%3E-%20Fill%3A%20Form%20for%20people%20to%20fill%20in%20with%20no%20access%20to%20results%20or%20ability%20to%20edit%20anything%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20add%20extra%20tabs%20for%20an%20existing%20form%20and%20pick%20which%20type%20you%20want%20-%20although%20they%20don't%20have%20the%20same%20name%20in%20this%20screen%20as%20they%20do%20on%20the%20tabs%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CoasterKaty_0-1612906318536.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F253721i84AAADE1BCE6F42A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22CoasterKaty_0-1612906318536.png%22%20alt%3D%22CoasterKaty_0-1612906318536.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHere%2C%20%22Collect%20responses%22%20%3D%20Fill%2C%20%22Show%20results%22%20%3D%20the%20results%20card%20and%20%22Collaborate%22%20%3D%20Edit.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2119145%22%20slang%3D%22en-US%22%3ERe%3A%20Where%20are%20Teams%20in-channel%20Forms%20responses%20stored%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2119145%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F960963%22%20target%3D%22_blank%22%3E%40CoreySCallahan%3C%2FA%3E%26nbsp%3Bjust%20to%20chip%20in%20here%20that%20in%20my%20company%20we%20always%20always%20use%20a%20flow%20in%20Power%20Automate%20to%20save%20form%20responses%20to%20a%20list%20in%20SharePoint%20so%20we%20can%20later%20access%20the%20results%20and%20manipulate%20them%20any%20way%20we%20want.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When creating a Form via the standard route, I can access Forms responses and export to an Excel doc. When creating a Form within Teams, can I later access the results in a similar way? It seems I can just see a card that displays results, which is fine for most cases.

5 Replies

@CoreySCallahan just to chip in here that in my company we always always use a flow in Power Automate to save form responses to a list in SharePoint so we can later access the results and manipulate them any way we want.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@CoreySCallahan They don't seem to be stored anywhere that's accessible from SharePoint, but you can still get at the results data in the normal way and export to Excel.

 

When I've just tried it now I've hit the + on the tabs at the top, then added a new form which gave me a tab called "Edit | Test form"

CoasterKaty_2-1612906496514.png

 

There's three different types of form tab you can have:

 

- Edit: edit the questions and view responses with the "export to excel" button

- Results: Card showing the results in a simpler view with no option to export

- Fill: Form for people to fill in with no access to results or ability to edit anything

 

You can add extra tabs for an existing form and pick which type you want - although they don't have the same name in this screen as they do on the tabs:

CoasterKaty_0-1612906318536.png

Here, "Collect responses" = Fill, "Show results" = the results card and "Collaborate" = Edit.

@CoasterKatyThis makes sense and seems to be the better way to create Forms. When I create one within the normal messaging toolbar (pictured), it seems to maybe be a slimmed down Form. Pre-making the Form seems to be better option.

 

I appreciate your help!

Screen Shot 2021-02-10 at 1.02.22 PM.png

best response confirmed by CoreySCallahan (New Contributor)
Solution

@CoreySCallahan Oh - I didn't even know you could add a form that way! Just had a go and the form itself is saved in "My Forms" for whoever created it, so https://www.office.com/launch/forms/myforms?auth=2 and you should see it in there, named after the question, from in there you can go into Responses and export to Excel.

@CoasterKatyOh wow! I swear I didn't even see that yesterday :lol:

 

Thanks again!