web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Average of Dynamic val...

Power Automate

Answered

Average of Dynamic values coming from MS forms

(0) Share

Report

Report

Posted on by ArunBethi

2

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-mengmli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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:

Was this reply helpful? Yes No

Join the conversation