Please Help! Having issues with Compose formula when tabulating test scores

[PLUMPZ]

Hello all, 

I tried creating a flow to export test results automatically using Power Automate. 

Currently the flow fails at the compose function and I do not understand why it does so. 

Any help would be greatly appreciated! I have attached the setup below for your reference. 

As this is also a learning process for me, do let me know if you have any tips for improving this flow. 

The compose function looks like this: 

add(add(add(add(add(add(add(add(add(add(add(variables('answer1')),variables('answer2')),variables('answer3')),variables('answer4')),variables('answer5')),variables('answer6')),variables('answer7')),variables('answer8')),variables('answer9')),variables('answer10')),variables('answer11'))

[v-xiaochen-msft]

Hi @PLUMPZ ,

Actually, all you need is one variable of type number.

Please try to use action 'Increment variable'.

Best Regards,

Wearsky

[PLUMPZ]

Hi @v-xiaochen-msft , 

Would like to ask how I would go about setting the increment if I were to use the 'increment variable' action?

Would I still need to use a compose function at the end to tabulate all the scores and if so, is there a reason why the compose function continues failing?

Thank you!

[v-xiaochen-msft · Accepted solution]

Hi @PLUMPZ ,

If you want to collect the score of each question, please try this:

add(add(add(add(add(add(add(add(add(add(variables('answer1'),variables('answer2')),variables('answer3')),variables('answer4')),variables('answer5')),variables('answer6')),variables('answer7')),variables('answer8')),variables('answer9')),variables('answer10')),variables('answer11'))

Best Regards,

Wearsky

[PLUMPZ]

Hi @v-xiaochen-msft ,

While this has solved the issue for the compose section error, I am facing another issue where the condition function is not working as intended.

In the snapshot, the condition should show true as the answer is correct, however in the flow the answer is marked false. Not sure if this is an issue on my end as to how the variable is set up or if this is another issue entirely. 

With regards to using the 'increment variable' function, how would I set it up as there are multiple questions? Do I set a condition per question? and if so how would the action determine the points in doing so?