Power Automate Flow Using Forms - Using Condition/Switch Effectively

%3CLINGO-SUB%20id%3D%22lingo-sub-2322060%22%20slang%3D%22en-US%22%3EPower%20Automate%20Flow%20Using%20Forms%20-%20Using%20Condition%2FSwitch%20Effectively%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2322060%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI'm%20trying%20to%20create%20a%20power%20automate%20flow%20which%20branches%20in%20two%20different%20directions%20given%20the%20response%20in%20Forms.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Top.PNG%22%20style%3D%22width%3A%20469px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277876iF040173399B39C81%2Fimage-dimensions%2F469x311%3Fv%3Dv2%22%20width%3D%22469%22%20height%3D%22311%22%20role%3D%22button%22%20title%3D%22Top.PNG%22%20alt%3D%22Top.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBased%20on%20the%20response%20to%20the%20Availability%20or%20Demand%20field%20in%20the%20forms%20survey%2C%20I%20want%20the%20following%20to%20occur%3A%20If%20the%20answer%20was%20availability%2C%20then%20the%20survey%20details%20get%20incorporated%20into%20a%20table%20in%20the%20excel.%20If%20the%20answer%20was%20Requesting%20Help%2C%20then%20the%20survey%20details%20get%20incorporated%20into%20a%20different%20table%20in%20the%20same%20excel%20and%20then%20there's%20a%20mass%20email.%20Currently%2C%20the%20downstream%20portion%20of%20the%20flow%20is%20working%2C%20the%20switch%20function%20doesn't%20seem%20to%20be%20capturing%20the%20response%20accurately%20because%20all%20of%20my%20responses%20end%20up%20falling%20into%20the%20%22Does%20not%20fit%20either%20case%22%20blank%20box%20with%20no%20output.%20What%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bottom.PNG%22%20style%3D%22width%3A%20451px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277879iDF942CAEF65087B9%2Fimage-dimensions%2F451x192%3Fv%3Dv2%22%20width%3D%22451%22%20height%3D%22192%22%20role%3D%22button%22%20title%3D%22Bottom.PNG%22%20alt%3D%22Bottom.PNG%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2322060%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2325231%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20Flow%20Using%20Forms%20-%20Using%20Condition%2FSwitch%20Effectively%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2325231%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1044755%22%20target%3D%22_blank%22%3E%40skhat88%3C%2FA%3E%26nbsp%3Bwhy%20not%20just%20use%20a%20condition%20as%20you%20only%20have%202%20outcomes%20from%20the%20Availability%20or%20Demand%20field%3F%20You%20can%20test%20what%20the%20value%20is%20that%20is%20being%20evaluated%20in%20the%20condition%2Fswitch%20by%20adding%20a%20Compose%20control%20and%20that%20will%20indicate%20what%20the%20problem%20is.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2326018%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Automate%20Flow%20Using%20Forms%20-%20Using%20Condition%2FSwitch%20Effectively%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2326018%22%20slang%3D%22en-US%22%3ESo%20would%20the%20condition%20be%20nested%20within%20the%20compose%20control%20action%3F%3C%2FLINGO-BODY%3E
New Contributor

Hello,


I'm trying to create a power automate flow which branches in two different directions given the response in Forms. 

 

Top.PNG

 

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?

 

Bottom.PNG 

 

Thank you,

 

4 Replies

@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

So would the condition be nested within the compose control action?
Yes you just a compose into both the green (yes) and red (no) channels.

@RobElliott So something like this?

 

skhat88_0-1620339577130.png

 

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