Answered

Extract fields from Quiz to SharePoint List

(1) Share

Report

Posted on by VT-10021414-0

Hello,

I have a Form Quiz, and its results are recorded in an XLS file. I am creating a SharePoint List where I populate the data from the Excel file. However, I am unable to read the "Total Points" field from this Excel file in Power Automate. It does not appear at all in Power Automate.

Where am I making a mistake? This field is essential for me to calculate the test success percentage.

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

Please share the actual flow and what you see etc.

Also in Excel is that a calculated column?

If so thats why.

Was this reply helpful? Yes No
VT-10021414-0 6 on at

Like (0)

Report
Copy link

Link copied!

Hi, this is my workflow. The Total points column is calculated automatically, based on the answers from the Form quiz. There are 5 questions in total. Each correct answer to a question carries 10 points.

Was this reply helpful? Yes No
VT-10021414-0 6 on at

Like (0)

Report
Copy link

Link copied!
Actually, my ultimate goal is to calculate the test success percentage for a given user based on the Total Points.

If the score is above 70%, the exam is successfully passed, and a certificate will be generated.

If the score is below 70%, the exam is considered unsuccessful, and the user will receive an email to retake the test.

Was this reply helpful? Yes No
Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @VT-10021414-0,

As far as I am aware currently the Get Response details action does not return the points per question or the total points per respondent.

However, you can interact with the Forms API instead.

I shared this approach on StackOverflow. Only at this point in time you need to use the Invoke an HTTP request (preauthorized) action instead of the Send an HTTP request to SharePoint action.

https://stackoverflow.com/questions/76219107/power-automate-forms-points-total-expression

Below is an example

https://forms.office.com/formapi/api/<tenantid>/users/<userid>/forms('<formid>')/GetAggregateQuizData

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
VT-10021414-0 6 on at

Like (0)

Report
Copy link

Link copied!

Is there no other way than through the API? I don't know exactly how to do it.

Was this reply helpful? Yes No