Answered

Average of Dynamic values coming from MS forms

(0) Share

Report

Posted on by ArunBethi

Greetings Professionals,

I kindly seek your assistance in outlining a sequential process for the following issue: I aim to compute the average of all numerical MS Form outputs using Power Automate.

Here's the progress I've achieved so far: I intend to display the average of the form responses within the compose field. As a novice in Power Automate, your guidance would be greatly appreciated.

Thank you in advance for your help.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-mengmli-msft on at

Like (1)

Report
Hi @ArunBethi ,

Do you mean that there are several questions in your form that need to be filled in with numbers, and you get those numbers in the flow and figure out the average?
My form:
Get the average value in compose:
1.Use int to convert text to a number.
2.Sum and divide the result by the total number of questions.
div(add(int(DynamicContent1),int(DynamicContent2)),2)

Best regards,
Rimmon

Was this reply helpful? Yes No
ArunBethi 2 on at

Like (0)

Report

Thank you very much for your response and your willingness to help. However, I have implemented the same steps you provided, but I am encountering the following error:

Error.png

Was this reply helpful? Yes No