May 04 2021 07:30 AM
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,
May 05 2021 01:20 AM
@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
May 05 2021 04:55 AM
May 05 2021 07:18 AM
May 06 2021 03:20 PM
@RobElliott So something like this?
I'm not entirely sure what the compose function does, but I added it under the excel actions in both the yes and no conditions.
Regards,
Samir
May 09 2021 01:52 AM