SOLVED

Interaction with Forms

%3CLINGO-SUB%20id%3D%22lingo-sub-841134%22%20slang%3D%22en-US%22%3EInteraction%20with%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-841134%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20I%20have%20a%20Microsoft%20Form%20which%20is%20shared%20with%20an%20O365%20group%2C%20my%20service%20account%20is%20in%20the%20group.%26nbsp%3B%20I%20need%20to%20trigger%20an%20email%20to%20an%20external%20email%20address%20to%20alert%20when%20a%20form%20is%20completed.%26nbsp%3B%20This%20works%20fine%20for%20a%20Form%20created%20by%20an%20individual%2C%20but%20when%20a%20Group%20Form%20is%20used%20it%20cannot%20be%20found%20in%20the%20trigger%20lookup.%26nbsp%3B%20The%20service%20account%20was%20used%20to%20create%20the%20Flow%2C%20and%20the%20Form%20is%20visible%20by%20logging%20on%20to%20Forms%20as%20the%20service%20account.%26nbsp%3B%3CBR%20%2F%3EIs%20this%20expected%20behaviour%20that%20Flow%20cannot%20locate%20a%20shared%20group%20Form%3F%26nbsp%3B%20I%20don't%20really%20want%20the%20Form%20tied%20to%20an%20individual%20person%2C%20it's%20not%20good%20practice.%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20710px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130468iD6723CAF4C1BBC01%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Forms.PNG%22%20title%3D%22Forms.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-841134%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-843050%22%20slang%3D%22en-US%22%3ERe%3A%20Interaction%20with%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-843050%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F291480%22%20target%3D%22_blank%22%3E%40mjsvr4%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20easiest%20way%20to%20work%20this%20is%20just%20to%20click%20onto%20%3CSTRONG%3EEnter%20custom%20value%3C%2FSTRONG%3Eand%20then%20add%20%3CSTRONG%3EFormId%3C%2FSTRONG%3Ewhich%20is%20at%20the%20end%20of%20the%20%3CSTRONG%3EURL%3C%2FSTRONG%3Ewhen%20viewing%20the%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOf%20course%2C%20make%20sure%20that%20your%20account%20has%20access%20to%20the%20form%20because%20if%20you%20lose%20access%20to%20the%20SharePoint%20group%2C%20you'll%20lose%20access%20to%20the%20form%20and%20flow%20will%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-843557%22%20slang%3D%22en-US%22%3ERe%3A%20Interaction%20with%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-843557%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20Thanks%20for%20the%20response.%26nbsp%3B%20I%20was%20not%20aware%20of%20that%20possibility%2C%20so%20have%20used%20that%20method%20which%20is%20working.%26nbsp%3B%20However%20because%20it%20doesn't%20read%20in%20the%20form%20I%20can't%20pipe%20the%20responses%20into%20the%20e-mail%2C%20there%20is%20no%20Dynamic%20Content%20available.%26nbsp%3B%20Do%20you%20know%20if%20this%20can%20be%20achieved%3F%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-846094%22%20slang%3D%22en-US%22%3ERe%3A%20Interaction%20with%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-846094%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F291480%22%20target%3D%22_blank%22%3E%40mjsvr4%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20should%20be%20able%20to%20get%20responses%20out%20of%20it%20by%20doing%20the%20following.%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%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130857i1D166334FAFD6B87%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221.png%22%20title%3D%221.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20doing%20that%20you'll%20see%20it%20in%20Dynamic%20content.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20use%20this%20method%20for%20most%20of%20my%20flows%20so%20I%20know%20it%20will%20work%20for%20you%2C%20however%2C%20if%20it%20doesn't%2C%20please%20attach%20a%20redacted%20screen%20shot%20of%20your%20flow%20and%20I'll%20have%20a%20squiz.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-846204%22%20slang%3D%22en-US%22%3ERe%3A%20Interaction%20with%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-846204%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3BThat%20works%20just%20how%20I%20wanted.%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Fhtml%2Fimages%2Femoticons%2Fsmile_40x40.gif%22%20alt%3D%22%3Asmile%3A%22%20title%3D%22%3Asmile%3A%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-846554%22%20slang%3D%22en-US%22%3ERe%3A%20Interaction%20with%20Forms%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-846554%22%20slang%3D%22en-US%22%3E%3CP%3EFantastic%20to%20hear%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F291480%22%20target%3D%22_blank%22%3E%40mjsvr4%3C%2FA%3E!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%20with%20your%20Forms%20and%20Flows!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

 

  I have a Microsoft Form which is shared with an O365 group, my service account is in the group.  I need to trigger an email to an external email address to alert when a form is completed.  This works fine for a Form created by an individual, but when a Group Form is used it cannot be found in the trigger lookup.  The service account was used to create the Flow, and the Form is visible by logging on to Forms as the service account. 
Is this expected behaviour that Flow cannot locate a shared group Form?  I don't really want the Form tied to an individual person, it's not good practice.

Thanks Forms.PNG

5 Replies

Hi @mjsvr4 

 

The easiest way to work this is just to click onto Enter custom value and then add FormId which is at the end of the URL when viewing the form.

 

Of course, make sure that your account has access to the form because if you lose access to the SharePoint group, you'll lose access to the form and flow will not work.

 

Best wishes

Damien

Hi @Damien Rosario 

 

  Thanks for the response.  I was not aware of that possibility, so have used that method which is working.  However because it doesn't read in the form I can't pipe the responses into the e-mail, there is no Dynamic Content available.  Do you know if this can be achieved?

Thank you

best response confirmed by mjsvr4 (New Contributor)
Solution

Hi @mjsvr4 

 

You should be able to get responses out of it by doing the following.

 

1.png

 

After doing that you'll see it in Dynamic content.

 

I use this method for most of my flows so I know it will work for you, however, if it doesn't, please attach a redacted screen shot of your flow and I'll have a squiz.

 

Cheers

Damien

Thanks @Damien Rosario That works just how I wanted. :smile:

Fantastic to hear @mjsvr4!

 

Best wishes with your Forms and Flows!

 

Cheers

Damien