Forum Discussion

mgtaylor_11's avatar
mgtaylor_11
Copper Contributor
Feb 19, 2025

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 choice...
Flow
forms
Forms Responses
microsoft forms
power automate
Rob_Elliott's avatar
Rob_Elliott
Bronze Contributor
Feb 20, 2025

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)

  • mgtaylor_11's avatar
    mgtaylor_11
    Copper Contributor
    Feb 20, 2025

    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?

    • Rob_Elliott's avatar
      Rob_Elliott
      Bronze Contributor
      Feb 22, 2025

      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)

Resources