Forms Pro to Power Automate for multiple answers

%3CLINGO-SUB%20id%3D%22lingo-sub-1219480%22%20slang%3D%22en-US%22%3EForms%20Pro%20to%20Power%20Automate%20for%20multiple%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1219480%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20are%20well...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EI%20currently%20have%20been%20using%20Forms%20Pro%20and%20Power%20Automate%20to%20create%2F%20update%20records%20bases%20on%20responses%20which%20works%20fine%20for%20all%20questions%20in%20Drop%20downs%2F%20text%20etc%20were%20there%20is%20only%20one%20answer.%20However%20when%20I%20use%20a%20multi%20checkbox%20option%20were%20a%20responded%20can%20have%20multiple%20answers%20this%20does%20come%20through%20in%20forms%20pro%20but%20any%20of%20my%20conditions%20in%20Power%20Automate%20do%20not%20pick%20it%20up!%3C%2FP%3E%3CP%3EI%20have%20a%20switch%20control%20which%20never%20runs%20because%20the%20data%20comes%20back%20with%20%5B%22under%2011%22%5D%20and%20the%20switch%20never%20picks%20it%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20Question%3A'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.dynamics.com%2Fresized-image%2F__size%2F640x480%2F__key%2Fcommunityserver-discussions-components-files%2F763%2Fpastedimage1583753939556v1.png%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcommunity.dynamics.com%2Fresized-image%2F__size%2F640x480%2F__key%2Fcommunityserver-discussions-components-files%2F763%2Fpastedimage1583753939556v1.png%3C%2FA%3E%3C%2FP%3E%3CP%3EExpression%20in%20Power%20Automate%3A%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%22pastedimage1583754075414v2.png-640x480.png%22%20style%3D%22width%3A%20639px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176136i879A760739BA3128%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22pastedimage1583754075414v2.png-640x480.png%22%20alt%3D%22pastedimage1583754075414v2.png-640x480.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22pastedimage1583754108543v3.png-640x480.png%22%20style%3D%22width%3A%20640px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176137i58FE53292843A864%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22pastedimage1583754108543v3.png-640x480.png%22%20alt%3D%22pastedimage1583754108543v3.png-640x480.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20have%20tried%20putting%20in%20the%20following%20around%20%3A%20'%20and%20%22.%20Does%20anyone%20have%20any%20advice%20on%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJustin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1219480%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1219783%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20Pro%20to%20Power%20Automate%20for%20multiple%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1219783%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Justin%20(%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F526754%22%20target%3D%22_blank%22%3E%40Moodycrmguy%3C%2FA%3E)%26nbsp%3B%20a%3CSPAN%3Es%20it's%20a%20Forms%20question%20that%20allows%20multiple%20answers%20we%20need%20to%20split%20out%20each%20answer%20and%20add%20it%20into%20a%20string%20variable.%20In%20my%20example%20below%20the%20user%20can%20select%201%20or%20more%20sessions%20to%20attend%20and%20we're%20then%20creating%20a%20Planner%20task.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%220-Form.png%22%20style%3D%22width%3A%20637px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176158iA5C5E5D1138F2CB6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%220-Form.png%22%20alt%3D%220-Form.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EAfter%20the%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CEM%3EWhen%20a%20new%20response%20is%20submitted%3C%2FEM%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Etrigger%20and%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CEM%3EGet%20response%20details%3C%2FEM%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Eaction%20we%20need%20to%20add%20an%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CEM%3EInitialize%20string%20variable%3C%2FEM%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Ewhich%20I've%20called%20varSession.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20next%20action%20is%20a%20Parse%20JSON%20action%20and%20the%20syntax%20you%20need%20to%20add%20is%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%7B%0A%20%20%20%20%22type%22%3A%20%22array%22%2C%0A%20%20%20%20%22items%22%3A%20%7B%0A%20%20%20%20%20%20%20%20%22type%22%3A%20%22string%22%0A%20%20%20%20%7D%0A%7D%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-Trigger-InitVar-Parse.png%22%20style%3D%22width%3A%20577px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176159i20184F40066655FD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%221-Trigger-InitVar-Parse.png%22%20alt%3D%221-Trigger-InitVar-Parse.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENext%20add%20an%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CEM%3EApply%20to%20each%3C%2FEM%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Econtrol%20and%20select%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EBody%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efrom%20the%20dynamic%20content.%26nbsp%3BInside%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CEM%3EApply%20to%20each%3C%2FEM%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eadd%20an%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CEM%3EAppend%20to%20string%20variable%3C%2FEM%3E%2C%20select%20the%20name%20and%20for%20the%20value%20select%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EItem%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efrom%20the%20dynamic%20content.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20next%20action%20is%20to%20add%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CEM%3ESwitch%3C%2FEM%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Econtrol%20and%20select%20the%20string%20variable%20from%20the%20dynamic%20content.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-Apply-Append-Switch.png%22%20style%3D%22width%3A%20985px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176160i59C2E512A44B103E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222-Apply-Append-Switch.png%22%20alt%3D%222-Apply-Append-Switch.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20each%20switch%20case%20I've%20then%20added%20the%20Planner%26nbsp%3B%3C%2FSPAN%3E%3CEM%3ECreate%20a%20task%3C%2FEM%3E%3CSPAN%3E%26nbsp%3Baction%20but%20your%20flow%20will%20have%20a%20different%20action.%20However%20you%20do%20need%20to%20reset%20the%20variable%20back%20to%20null%20before%20the%20next%20multi-choice%20answer%20is%20looked%20at%2C%20so%20add%20a%26nbsp%3B%3C%2FSPAN%3E%3CEM%3ESet%20variable%3C%2FEM%3E%3CSPAN%3E%2C%20select%20it%20and%20in%20the%20value%20field%20add%20the%20expression%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Enull%3C%2FSTRONG%3E%3CSPAN%3E.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223-SwitchCase-CreateTask-SetVariable.png%22%20style%3D%22width%3A%20959px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176161i45BF9340AED876E8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%223-SwitchCase-CreateTask-SetVariable.png%22%20alt%3D%223-SwitchCase-CreateTask-SetVariable.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20my%20form%20I%20selected%20both%20SharePoint%20and%20Power%20Automate%20as%20the%20sessions%20to%20attend%20and%20this%20is%20the%20result%20of%20the%20SharePoint%20answer.%20The%20Power%20Automate%20answer%20went%20down%20its%20switch%20case%20channel%20correctly%20as%20well.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%224-Result.png%22%20style%3D%22width%3A%20897px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176162iD5A9F17C00A7E73A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%224-Result.png%22%20alt%3D%224-Result.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps.%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%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1220134%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20Pro%20to%20Power%20Automate%20for%20multiple%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1220134%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Rob%2C%20thank%20you%20so%20much%20for%20this%20very%20useful%20-%20I%20have%20followed%20your%20steps%20and%20using%20the%20following%20Question%20answers%3A%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%22Moodycrmguy_0-1583854276412.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176193iCDFFD176DD85D1C5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Moodycrmguy_0-1583854276412.png%22%20alt%3D%22Moodycrmguy_0-1583854276412.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20it%20still%20does%20not%20trigger%20any%20outcomes%20and%20it%20seems%20to%20connect%20the%20two%20answers%20together%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Moodycrmguy_1-1583854397642.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176194iE4AF89C363B00E1D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Moodycrmguy_1-1583854397642.png%22%20alt%3D%22Moodycrmguy_1-1583854397642.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJustin%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1220518%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20Pro%20to%20Power%20Automate%20for%20multiple%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1220518%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F526754%22%20target%3D%22_blank%22%3E%40Moodycrmguy%3C%2FA%3E%26nbsp%3Bwithout%20seeing%20the%20steps%20in%20your%20flow%20I%20can't%20be%20sure%20but%20it%20looks%20like%20you're%20not%20adding%20the%20set%20variable%20action%20(see%20the%205th%20screenshot%20in%20my%20earlier%20post)%20in%20each%20case%20channel%20to%20re-set%20it%20to%20null%26nbsp%3B%20which%20is%20why%20it's%20combining%20the%20outputs.%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%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1222295%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20Pro%20to%20Power%20Automate%20for%20multiple%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1222295%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%20Thank%20you%20for%20coming%20back%20to%20me%20and%20all%20your%20support.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Moodycrmguy_0-1583936918118.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176367i9631E0CA0823066D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Moodycrmguy_0-1583936918118.png%22%20alt%3D%22Moodycrmguy_0-1583936918118.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20done%20that%20step%20and%20still%20I%20get%20the%20same%20outcome.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20also%20might%20be%20useful%20in%20terms%20of%20seeing%20what%20is%20going%20on%20in%20the%20entire%20flow%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Moodycrmguy_2-1583937036271.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176369iF6CBC86DED842CBC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Moodycrmguy_2-1583937036271.png%22%20alt%3D%22Moodycrmguy_2-1583937036271.png%22%20%2F%3E%3C%2FSPAN%3E%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%22Moodycrmguy_1-1583936995656.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176368i1301E3F3C27B5189%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Moodycrmguy_1-1583936995656.png%22%20alt%3D%22Moodycrmguy_1-1583936995656.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Moodycrmguy_3-1583937188391.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176370i0F3C6BB44CB0B7A5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Moodycrmguy_3-1583937188391.png%22%20alt%3D%22Moodycrmguy_3-1583937188391.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Moodycrmguy_4-1583937264553.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176371iEC2FB7A665CE1674%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Moodycrmguy_4-1583937264553.png%22%20alt%3D%22Moodycrmguy_4-1583937264553.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1222307%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20Pro%20to%20Power%20Automate%20for%20multiple%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1222307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%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%22Moodycrmguy_0-1583937356050.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F176373i3F0FEB7723663EF6%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Moodycrmguy_0-1583937356050.png%22%20alt%3D%22Moodycrmguy_0-1583937356050.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20advice%3F%20it%20is%20when%20I%20get%20to%20my%20target%20audience%20switch%20that%20this%20falls%20off.%20it%20looks%20like%20the%20string%20works%20but%20it%20does%20not%20seem%20to%20pick%20up%20the%20spacing%20strangely%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1222398%22%20slang%3D%22en-US%22%3ERe%3A%20Forms%20Pro%20to%20Power%20Automate%20for%20multiple%20answers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1222398%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F526754%22%20target%3D%22_blank%22%3E%40Moodycrmguy%3C%2FA%3E%26nbsp%3Bwhen%20I%20mentioned%20seeing%20the%20steps%20in%20the%20flow%20I%20meant%20screenshots%20of%20the%20edit%20page%2C%20not%20the%20results%20page.%20You%20can%20blur%20out%20site%20names%20and%20any%20sensitive%20info%20but%20it's%20that%20way%20that%20we%20can%20see%20more%20easily%20what%20the%20logic%20is%20and%20what%20the%20problem%20might%20be.%20So%20if%20you%20can%20do%20that%20I'l%20have%20another%20look.%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%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi all,

 

I hope you are well...

 

I currently have been using Forms Pro and Power Automate to create/ update records bases on responses which works fine for all questions in Drop downs/ text etc were there is only one answer. However when I use a multi checkbox option were a responded can have multiple answers this does come through in forms pro but any of my conditions in Power Automate do not pick it up!

I have a switch control which never runs because the data comes back with ["under 11"] and the switch never picks it up.

 

Example Question:'

 

https://community.dynamics.com/resized-image/__size/640x480/__key/communityserver-discussions-compon...

Expression in Power Automate:

 

pastedimage1583754075414v2.png-640x480.png

 

 

pastedimage1583754108543v3.png-640x480.png

I have tried putting in the following around : ' and ". Does anyone have any advice on this?

 

Thanks

 

Justin

6 Replies
Highlighted

Hi Justin ( @Moodycrmguy)  as it's a Forms question that allows multiple answers we need to split out each answer and add it into a string variable. In my example below the user can select 1 or more sessions to attend and we're then creating a Planner task.

 

0-Form.png

 

After the When a new response is submitted trigger and Get response details action we need to add an Initialize string variable which I've called varSession.

 

The next action is a Parse JSON action and the syntax you need to add is

 

{
    "type": "array",
    "items": {
        "type": "string"
    }
}

 

1-Trigger-InitVar-Parse.png

 

Next add an Apply to each control and select Body from the dynamic content. Inside the Apply to each add an Append to string variable, select the name and for the value select Item from the dynamic content.

 

The next action is to add the Switch control and select the string variable from the dynamic content.

 

2-Apply-Append-Switch.png

 

In each switch case I've then added the Planner Create a task action but your flow will have a different action. However you do need to reset the variable back to null before the next multi-choice answer is looked at, so add a Set variable, select it and in the value field add the expression null

 

3-SwitchCase-CreateTask-SetVariable.png

 

In my form I selected both SharePoint and Power Automate as the sessions to attend and this is the result of the SharePoint answer. The Power Automate answer went down its switch case channel correctly as well.

 

4-Result.png

 

Hope that helps.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott 

 

Hi Rob, thank you so much for this very useful - I have followed your steps and using the following Question answers:

 

Moodycrmguy_0-1583854276412.png

 

However it still does not trigger any outcomes and it seems to connect the two answers together?

Moodycrmguy_1-1583854397642.png

Thanks

 

Justin

 

 

 

Highlighted

@Moodycrmguy without seeing the steps in your flow I can't be sure but it looks like you're not adding the set variable action (see the 5th screenshot in my earlier post) in each case channel to re-set it to null  which is why it's combining the outputs.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott  Thank you for coming back to me and all your support. 

Moodycrmguy_0-1583936918118.png

 

I have done that step and still I get the same outcome. 

 

This also might be useful in terms of seeing what is going on in the entire flow:

Moodycrmguy_2-1583937036271.png

 

Moodycrmguy_1-1583936995656.png

Moodycrmguy_3-1583937188391.png

Moodycrmguy_4-1583937264553.png

 

 

Highlighted

@Rob Elliott 

 

Moodycrmguy_0-1583937356050.png

 

any advice? it is when I get to my target audience switch that this falls off. it looks like the string works but it does not seem to pick up the spacing strangely

 

Highlighted

@Moodycrmguy when I mentioned seeing the steps in the flow I meant screenshots of the edit page, not the results page. You can blur out site names and any sensitive info but it's that way that we can see more easily what the logic is and what the problem might be. So if you can do that I'l have another look.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User