Forum Discussion
skhat88
May 04, 2021Copper Contributor
Power Automate Flow Using Forms - Using Condition/Switch Effectively
Hello,
I'm trying to create a power automate flow which branches in two different directions given the response in Forms.
Based on the response to the Availability or Demand field in the forms survey, I want the following to occur: If the answer was availability, then the survey details get incorporated into a table in the excel. If the answer was Requesting Help, then the survey details get incorporated into a different table in the same excel and then there's a mass email. Currently, the downstream portion of the flow is working, the switch function doesn't seem to be capturing the response accurately because all of my responses end up falling into the "Does not fit either case" blank box with no output. What am I doing wrong?
Thank you,
5 Replies
Sort By
- RobElliottSilver Contributor
skhat88 why not just use a condition as you only have 2 outcomes from the Availability or Demand field? You can test what the value is that is being evaluated in the condition/switch by adding a Compose control and that will indicate what the problem is.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- skhat88Copper ContributorSo would the condition be nested within the compose control action?
- RobElliottSilver ContributorYes you just a compose into both the green (yes) and red (no) channels.