cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smather
Helper I
Helper I

If Statement - MS Forms

Hi there

 

I'm trying to do an if formula to say, for example, if q1 from the microsoft form is 'yes', then put the number 5 in this box, and if no, put 0. 

 

Does anyone know the best way to do this? 

1 ACCEPTED SOLUTION

Accepted Solutions
RobElliott
Super User
Super User

@smather  One way to do it is to add an integer variable then use a Switch control to set the variable to a number depending on the answer to the question in the form. For example:

0-Form.png

 

 

1-Flow.png

 

2-Flow.png

 

3a-Flow.png

 

3b-Flow.png

 

3c-Flow.png

 

4-Flow.png

 

weighting.gif

 

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

View solution in original post

2 REPLIES 2
RobElliott
Super User
Super User

@smather  One way to do it is to add an integer variable then use a Switch control to set the variable to a number depending on the answer to the question in the form. For example:

0-Form.png

 

 

1-Flow.png

 

2-Flow.png

 

3a-Flow.png

 

3b-Flow.png

 

3c-Flow.png

 

4-Flow.png

 

weighting.gif

 

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

That's perfect @RobElliott  -- sorry to bother again, but do you know how to add up these variables too? 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,352)