I have a Flow that recorded Quiz Form results into a SharePoint List that worked great when the sync to Excel was working.
There doesn't seem to be any way to use power automate to get the Score from the Quiz Form so the answers I've read on other posts talking about they sync issue aren't helping me.
I was using a Flow that got the responses from the Form, used an Excel Get a Row step to grab the data from the synced excel spreadsheet and then Create item into the SharePoint list using the Get a Row dynamic content which would allow me to get the Total Points from the spreadsheet.
Using the Record Form Responses template works for every other type of flow from Forms to SharePoint but with this particular detail of needing the Total Points response I relied upon that Synced form.
Can anyone help with a simple solution?
I don't know advanced scripts.
The flow that worked with forms automatically syncing to excel:
Share
Report
All responses (
Answers (
821
