Forum Discussion
Weighted Answers in 2 Survey Pages adding up to a end value.
Hello there, new to MS Form and Power Automate so bear with me on this one:
Part of an Ideas Survey, requires a user to complete a 'Survey Page' where there are 7 Questions with 4 possible choices. 1 Choice per Question, each Choice is weighted
Option 1= 0
Option 2= 1
Option 3 = 2
Option 4 = 5
Once answered, should give a value of the sum of weighted answers... so 3 Question have option 3, 2 questions were answered option 2 and 2 were answered option 4. totaling 18
A second survey page very similar weighted options to the questions.
What these values I would need to utilise to find a reference based on a Grid of Values.
1 to 35 along and 1 to 21 Up, the values in the survey would be used to gauge 18 cells along and , lets say 15 rows up.
In that specific Cell would be a Reference. something like H15
a Formula would be something Like if Survey1 Value >15 then H, <=15 and >=10 then M, >=0 to <10 then L
Then it would be to concat the value of the of that plus the Survey 2 Value.
How, would I go about doing that?
Just from messing about, it would have to be a triggered Power Automate to then add to a variable, then after that no idea.
Anyone able to do this and to help with a step by step? Much appreciated. Mike.
It looks like you want to do a calculation in Power Automate based on both surveys. This isn't possible you can't have 2 triggers in a flow so the flow can only get the response from 1 form. So you'd need to have 2 flows, each saving the response into the same SharePoint list. Then in that list you could probably do the calculation with a calculated column.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)Hi Rob, thanks for your reply, 2 flows I don"t mind, the trigger though, is there only a trigger on the submit button? Can't get a trigger on a next button at all?
You can't add a trigger on the next button because at that point nothing has happened, i.e the form has not been submitted. A flow can only run after the form has been submitted. If you didit with Power Apps instead of Forms then a lot more options are open to you as to when flows trigger etc.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
