web

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

Power Platform CommunityForums Power Automate - Building Flows Calculate Ms Forms Res...

Power Automate - Building Flows

Answered

Calculate Ms Forms Response

(0) Share

Report

Report

Posted on by Zrl

3

Hi all,

i have set up a form with many question which the question will be depend on previous question(branching). most of the question answer will be "yes", "no" answer.

Is there a way for me to build a flow that will assist to calculate how many question with "yes" answer and put it on a column in sharepoint list?

i already try expression sum(if(response="yes",1,0),if(response2="yes",1,0).........) but it failed.

is there a way?

Thanks

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Expiscornovus 32,910 Most Valuable Professional on at

Like (0)

Report
Re: Calculate Ms Forms Response

Hi @Zrl,

I believe you can achieve this by using an add function and also including an equals operator.

Try this example. Replace the question ids by your question ids.
add(if(equals(outputs('Get_response_details')?['body/rc44b58908ce2400ea83023abedc7b24e'], 'Yes'), 1, 0), if(equals(outputs('Get_response_details')?['body/r9944752806574d43b8529d99ab9e51fe'], 'Yes'), 1, 0))

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 614 Super User 2025 Season 2

#2

Tomac 401 Moderator

#3

chiaraalina 282

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans