Forum Discussion
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/...
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.
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.
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................