SOLVED

Create a Quiz when starting from OneDrive or Excel Online?

%3CLINGO-SUB%20id%3D%22lingo-sub-332570%22%20slang%3D%22en-US%22%3ECreate%20a%20Quiz%20when%20starting%20from%20OneDrive%20or%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332570%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20create%20a%20Quiz%20when%20starting%20from%20OneDrive%20for%20Business%20or%20Excel%20Online%3F%26nbsp%3B%20If%20so%2C%20how%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20starting%20from%20both%20OneDrive%20and%20Excel%20Online%20and%20it%20seems%20like%20I%20can%20only%20create%20a%20Form%2C%20not%20a%20Quiz.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20ultimate%20goal%20is%20to%20capture%20the%20total%20points%20earned%20value%20(and%20user%20info)%20from%20a%20completed%20quiz%20so%20I%20can%20put%20it%20into%20a%20SharePoint%20List%20(using%20Flow).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I'm%20thinking%20%3CEM%3Eif%3C%2FEM%3EI%20can%3A%3C%2FP%3E%3CP%3E1.%20Create%20a%20Quiz%20when%20starting%20from%20OneDrive%20or%20Excel%20Online%2C%20%3CSTRONG%3Eand%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E2.%20The%20form%20info%20that%20is%20automatically%20pushed%20to%20Excel%20includes%20the%20points%20earned%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethen%20I%20could%20use%20Flow%20to%20put%20the%20points%20info%20(and%20the%20user%20info)%20into%20a%20SharePoint%20List.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20total%20points%20info%20appears%20in%20the%20spreadsheet%20when%20I%20click%20on%20%22Open%20in%20Excel%22%20when%20on%20the%20Form's%20Responses%20tab.%26nbsp%3B%20Unfortunately%2C%20it%20does%20not%20appear%20that%20the%20points%20info%20is%20available%20when%20I%20use%20the%20%22Get%20response%20details%22%20step%20in%20Flow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-332570%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuiz%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-333948%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Quiz%20when%20starting%20from%20OneDrive%20or%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-333948%22%20slang%3D%22en-US%22%3E%3CP%3EHappy%20to%20help%20and%20best%20wishes%20to%20you.%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-333015%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Quiz%20when%20starting%20from%20OneDrive%20or%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-333015%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%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%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20time%2C%20the%20quick%20reply%20and%20information.%26nbsp%3B%20I've%20added%20my%20voice%20to%20the%20request%20for%20this%20feature.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20a%20great%20day!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Erobertg%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332732%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Quiz%20when%20starting%20from%20OneDrive%20or%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332732%22%20slang%3D%22en-US%22%3E%3CP%3EHere's%20another%20one%20too!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F32638084-in-onedrive-new-forms-quiz-for-excel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F32638084-in-onedrive-new-forms-quiz-for-excel%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332730%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Quiz%20when%20starting%20from%20OneDrive%20or%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332730%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%2F280166%22%20target%3D%22_blank%22%3E%40rgentile%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere's%20no%20way%20to%20create%20a%20Quiz%20from%20OD%2FSP%20at%20this%20time%20nor%20am%20I%20aware%20of%20any%20way%20to%20extract%20the%20score%20from%20the%20Excel%20doc%20as%20it's%20hosted%20by%20Microsoft%20rather%20than%20your%20own%20OD%2FSP.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20advocate%20for%20this%20feature%20on%20UserVoice%20on%20this%20existing%20request%20I%20have%20found!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F31243432-quiz-score-available-to-ms-flow%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftforms.uservoice.com%2Fforums%2F386451-welcome-to-microsoft-forms-suggestion-box%2Fsuggestions%2F31243432-quiz-score-available-to-ms-flow%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1599991%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Quiz%20when%20starting%20from%20OneDrive%20or%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1599991%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%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280166%22%20target%3D%22_blank%22%3E%40rgentile%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20are%20you%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20year%20later%20after%20your%20post%2C%20I%20have%20the%20same%20need%2C%20so%20I%20wonder%20if%20now%20is%20already%20available.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20more%20because%20even%20thoug%20the%20feature%20seems%20to%20be%20avilable%20in%20the%20New%20Menu%20edit%26nbsp%3B%20function%20(Encuesta%20para%20Excel)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22andresposadaf_0-1597874278689.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213377i8752F8AB79DBEB77%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22andresposadaf_0-1597874278689.png%22%20alt%3D%22andresposadaf_0-1597874278689.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20I%20try%20to%20create%20it%2C%20it%20doesn't%20appears%20(Just%20Forms%20for%20Excel)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22andresposadaf_1-1597874401472.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213378i12D18C12D726F489%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22andresposadaf_1-1597874401472.png%22%20alt%3D%22andresposadaf_1-1597874401472.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3BThanks%20for%20your%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAndr%C3%A9s%20Posada%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1600121%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Quiz%20when%20starting%20from%20OneDrive%20or%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1600121%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%2F730030%22%20target%3D%22_blank%22%3E%40andresposadaf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20as%20I%20know%2C%20there's%20been%20nothing%20happening%20on%20this%20front%20just%20yet%20for%20either%20creating%20a%20Quiz%20from%20OneDrive%20nor%20the%20ability%20to%20extract%20the%20quiz%20results%20using%20something%20like%20Power%20Automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%20with%20your%20Quizzes!%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-1971310%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20Quiz%20when%20starting%20from%20OneDrive%20or%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1971310%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730030%22%20target%3D%22_blank%22%3E%40andresposadaf%3C%2FA%3E%26nbsp%3BI%20was%20hopeful%20when%20I%20saw%20your%20post%2C%20but%20that%20menu%20for%20Excel%20Survey%20is%20not%20related%20to%20Forms.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2Fimages%2Femoticons%2Fsad_40x40_1.gif%22%20alt%3D%22%3Asad%3A%22%20title%3D%22%3Asad%3A%22%20%2F%3E%3C%2FP%3E%3CP%3EIt%20seems%20that%20the%20Excel%20Survey%20option%20is%20for%20input%20from%20external%20users%20in%20your%20Sharepoint%20and%20it's%20only%20available%20if%20external%20sharing%20is%20activated%20in%20Sharepoint.%20That's%20why%20the%20option%20doesn't%20show%20up%20for%20you%20(or%20for%20me).%3C%2FP%3E%3CP%3ESadly%2C%20that%20means%20that%20we%20have%20no%20solution%20for%20extracting%20Quiz%20points%20into%20Excel%20automatically.%3C%2FP%3E%3CP%3ESource%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fkalmstrom.com%2Ftips%2Fsharepoint-online-course%2FExcel-Survey.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fkalmstrom.com%2Ftips%2Fsharepoint-online-course%2FExcel-Survey.htm%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Is it possible to create a Quiz when starting from OneDrive for Business or Excel Online?  If so, how?

 

I've tried starting from both OneDrive and Excel Online and it seems like I can only create a Form, not a Quiz.

 

My ultimate goal is to capture the total points earned value (and user info) from a completed quiz so I can put it into a SharePoint List (using Flow).

 

So I'm thinking if I can:

1. Create a Quiz when starting from OneDrive or Excel Online, and

2. The form info that is automatically pushed to Excel includes the points earned

 

then I could use Flow to put the points info (and the user info) into a SharePoint List.

 

The total points info appears in the spreadsheet when I click on "Open in Excel" when on the Form's Responses tab.  Unfortunately, it does not appear that the points info is available when I use the "Get response details" step in Flow.

 

Thanks!

 

 

7 Replies
best response confirmed by rgentile (Occasional Contributor)
Solution

Hi @rgentile 

 

There's no way to create a Quiz from OD/SP at this time nor am I aware of any way to extract the score from the Excel doc as it's hosted by Microsoft rather than your own OD/SP.

 

You can advocate for this feature on UserVoice on this existing request I have found!

 

https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggest...

 

Best wishes

Damien

Hello @Damien Rosario 

 

Thanks for your time, the quick reply and information.  I've added my voice to the request for this feature.

 

Have a great day!

 

robertg

Happy to help and best wishes to you.

 

Cheers

Damien

Hi @Damien Rosario and  @rgentile ,

 

How are you?

 

One year later after your post, I have the same need, so I wonder if now is already available.

 

And more because even thoug the feature seems to be avilable in the New Menu edit  function (Encuesta para Excel):

andresposadaf_0-1597874278689.png

 

But when I try to create it, it doesn't appears (Just Forms for Excel):

 

andresposadaf_1-1597874401472.png

 Thanks for your help

 

Best Regards!

 

Andrés Posada 

 

 

Hi @andresposadaf 

 

As far as I know, there's been nothing happening on this front just yet for either creating a Quiz from OneDrive nor the ability to extract the quiz results using something like Power Automate.

 

Best wishes with your Quizzes!

 

Cheers

Damien

@andresposadaf I was hopeful when I saw your post, but that menu for Excel Survey is not related to Forms. :sad:

It seems that the Excel Survey option is for input from external users in your Sharepoint and it's only available if external sharing is activated in Sharepoint. That's why the option doesn't show up for you (or for me).

Sadly, that means that we have no solution for extracting Quiz points into Excel automatically.

Source: https://kalmstrom.com/tips/sharepoint-online-course/Excel-Survey.htm