Forum Discussion

Clint Lechner's avatar
Clint Lechner
Steel Contributor
Aug 18, 2017

Is there any way to programmatically get the excel file?

I already asked if there was a way to get the final score and that went nowhere, but perhaps there's a way to get the excel file or even the score of individual answers?  I'm trying to automate pass/fail on quizes and it's a big roadblock for me right now, unfortunately.  I have to say, I love Forms right now, even though it's clearly in the infant stages, as it shows massive promise.  

  • Alan Marshall's avatar
    Alan Marshall
    Steel Contributor
    Have you tried using Flow to capture each completion of a form. I know it doesn't provide you with a score but you could write this to a SharePoint list and add some calculated columns to figure out scores for right answers. It does mean having to maintain the scoring in 2 places.
    The link to the spreadsheet is always persistent so you could use that as a data source for another spreadsheet with scoring and lookups. PowerBI might be an option but haven't tried linking that to the spreadsheet yet.
    • Clint Lechner's avatar
      Clint Lechner
      Steel Contributor

      Alan Marshall -- I thought of writing the answers to a list but man that's a pain.  Hmmm.... I guess I don't know how it writes the answers, if it just gives the number or the full answer.  That's not a bad idea actually, thinking it through.  In my head I was thinking it write the full answers but if it puts the letter/number/score, then that's a LOT more doable (or at least less of a pain).  

       

      And if the excel sheet is persistent then that gives some flexibility too, but I didn't think it was.  Yeah, there are more options than I originally thought.  Whew................

  • Jamie Barton's avatar
    Jamie Barton
    Copper Contributor
    I personally use Flow - use the 'When Form is completed / Submitted' (Not sure what the name of it was) and then do my work on that, normally is a database dump or add to an existing excel file.

Resources