Forum Discussion

Copper Contributor

Oct 25, 2021

Help - Can you calculate how many points in total someone has given on all questions in a form?

Hi I'm trying to make an assessment/quiz/form/surway... There will be multiple questions On each question the responder will choose a point from 0 - 4 At the end - when all questions are an...

Copper Contributor

Apr 25, 2022

RobElliott hi Rob, could you send a picture of what your Excel sheet would look like? And could this be done using just Excel with incremental values and applying an initialize variable and Switch?

KentW1650

Copper Contributor

Mar 29, 2024

I made it to this step however I am not seeing the fields to select the Outputs.

Next, we want to add the answers to the item in the SharePoint list. So add a SharePoint "create item" action, click in each field and select the appropriate item from the dynamic content box. You'll see that there is an "output" for each of the compose actions you created earlier.

This is what i see on my Create Item. There are none of the Sharepoint Column Names / Fields available.

Any idea what is wrong. I am trying to create a form to SP list that i can then use to calculate an overall score.

Thanks

Rob_Elliott
Bronze Contributor
Mar 30, 2024
KentW1650 what happens when you switch to the classic designer, do you see the columns and are able to select previous outputs from the dynamic content box?

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)