Send Form response with only branched answered questions

%3CLINGO-SUB%20id%3D%22lingo-sub-2348477%22%20slang%3D%22en-US%22%3ESend%20Form%20response%20with%20only%20branched%20answered%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348477%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20HR%20department%20have%20created%20a%20MS%20Form%20with%20Circa%2040%20questions%20however%20there%20are%20a%20lot%20of%20branches%20so%20only%205%20or%206%20responses%20are%20required%20to%20complete%20the%20form.%20So%2C%20I%20can't%20simply%20add%20every%20single%20possible%20answer%20on%20the%20approval%20I%20need%20to%20only%20send%20to%20the%20responder's%20line%20manager%20ones%20which%20were%20answered%3C%2FP%3E%3CP%3EI%20used%20this%26nbsp%3B%3CA%20title%3D%22Attach%20Microsoft%20forms%20response%20in%20email%22%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fmicrosoft-forms%2Fattach-microsoft-forms-response-in-email%2Fm-p%2F680349%22%20target%3D%22_self%22%3Eattach-microsoft-forms-response-in-email%3C%2FA%3E%26nbsp%3B%20to%20get%20started%20but%20as%20a%20lot%20of%20response%20show%20that%20ALL%20answers%20inc%20blank%20should%20be%20included%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20open%20to%20all%20suggestions%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKindest%20Regards%3C%2FP%3E%3CP%3ESimon%20Richardson%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2348477%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2348583%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20Form%20response%20with%20only%20branched%20answered%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348583%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72412%22%20target%3D%22_blank%22%3E%40Simon%20Richardson%3C%2FA%3E%26nbsp%3Bit%20would%20in%20theory%20be%20possible%20with%20a%20mass%20of%20conditions%20-%20at%20least%2040%20-%20to%20check%20whether%20the%20question%20had%20an%20answer%20or%20was%20blank%20and%20then%20append%20the%20answer%20to%20one%20of%2040%20variables.%20Life%20is%20too%20short%20for%20that%20sort%20of%20complexity.%26nbsp%3B%20So%20in%20the%20email%20include%20all%20the%20questions%20but%20if%20they%20haven't%20answered%20answered%20a%20question%20it%20will%20just%20be%20blank.%20No%20problem%2C%20the%20recipients%20will%20understand%20that%20and%20it%20will%20save%20you%20a%20truckload%20of%20work%20and%20a%20flow%20with%20a%20huge%20propensity%20to%20fail.%20Don't%20give%20in%20to%20HR%20just%20because%20they've%20asked%20for%20something!%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%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2350714%22%20slang%3D%22en-US%22%3ERe%3A%20Send%20Form%20response%20with%20only%20branched%20answered%20questions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2350714%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20feedback%20Rob%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20currently%20of%20that%20thinking%20and%20have%20not%20promised%20them%20anything%2C%20I%20just%20hoped%20as%20you%20can%20view%20and%20print%20a%20forms%20responses%20by%20individual%20respondent's%20I%20was%20hoping%20that%20maybe%20there%20was%20a%20way%20to%20use%20that%20functionality%20in%20the%20flow.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%20Again%3CBR%20%2F%3ESimon%20R%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

My HR department have created a MS Form with Circa 40 questions however there are a lot of branches so only 5 or 6 responses are required to complete the form. So, I can't simply add every single possible answer on the approval I need to only send to the responder's line manager ones which were answered

I used this attach-microsoft-forms-response-in-email  to get started but as a lot of response show that ALL answers inc blank should be included

 

I am open to all suggestions

 

Kindest Regards

Simon Richardson

3 Replies

@Simon Richardson it would in theory be possible with a mass of conditions - at least 40 - to check whether the question had an answer or was blank and then append the answer to one of 40 variables. Life is too short for that sort of complexity.  So in the email include all the questions but if they haven't answered answered a question it will just be blank. No problem, the recipients will understand that and it will save you a truckload of work and a flow with a huge propensity to fail. Don't give in to HR just because they've asked for something!

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

 

 

Thanks for the feedback Rob,

I am currently of that thinking and have not promised them anything, I just hoped as you can view and print a forms responses by individual respondent's I was hoping that maybe there was a way to use that functionality in the flow.

Thanks Again
Simon R
I wish I had a good answer. I feel your pain. ugh!