cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Multiply response in MS Forms by value in sharepoint list

Hello automate experts!

 

I have a survey in Microsoft Forms and a flow connected such that when a new response is submitted, a new row is added to a sharepoint list. These answers are all worded and converted into numeric values during the 'create item' action of my flow using if statements.

 

However some questions are weighted differently to others. These weights per question are stored in a different sharepoint list in the same sharepoint site.

 

I was wondering is there a way to multiply the numeric forms response by the weight value corresponding to that question.

 

e.g.

 

The weight sharepoint list looks like this

 

Ref1.11.2
Weight23

 

Ideally I want to do something like this with the MS Forms response in the 'create item' action of my flow:

 

  • 1.1:   if(equals(1.1,'yes'),6, if(equals(1.1,'no'),3,0)) * 2
  • 1.2:   if(equals(1.2,'yes'),6, if(equals(1.2,'no'),3,0)) * 3

 

The highlighted numbers above correspond to the weight from the weight table.

 

e.g. If the user answered 'yes' for question 1.1, then a score of 12 would be pushed to column 1.1 of the response sharepoint list.

 

The response sharepoint list would then look something like this

 

RespondentID1.11.2
abc12

9

 

Is there a way to do this?

Thank you in advance!

1 REPLY 1
abm
Super User
Super User

Hi @Anonymous 

 

Can't you use an IF condition to check whether 1.1 response is Yes or No? If you want to multiple two values in PowerAutomate you can use mul() expression.

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,629)