Storing attachments from Form in the relevant submission folder in Sharepoint

%3CLINGO-SUB%20id%3D%22lingo-sub-984823%22%20slang%3D%22en-US%22%3EStoring%20attachments%20from%20Form%20in%20the%20relevant%20submission%20folder%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-984823%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20connect%20a%20form%20that%20I%20created%20to%20SharePoint.%20My%20form%20accepts%20attachments%20for%203%20questions.%20These%20attachments%20unfortunately%20get%20stored%20in%20SharePoint%20under%20respective%20question%20folder%20that%20it%20creates%20in%20Sharepoint.%20However%2C%20I%20would%20prefer%20to%20have%20the%20folders%20for%20each%20submission%20as%20o%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-984823%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-985829%22%20slang%3D%22en-US%22%3ERe%3A%20Storing%20attachments%20from%20Form%20in%20the%20relevant%20submission%20folder%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-985829%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%2F425951%22%20target%3D%22_blank%22%3E%40Appy01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20I%20follow%20your%20scenario.%20Could%20you%20please%20provide%20some%20screen%20shots%20to%20demonstrate%20the%20form%20and%20issue%3F%20Redact%20any%20sensitive%20info.%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-1045067%22%20slang%3D%22en-US%22%3ERe%3A%20Storing%20attachments%20from%20Form%20in%20the%20relevant%20submission%20folder%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1045067%22%20slang%3D%22en-US%22%3E%3CP%3E%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%3EStep%201%3A%20Would%20be%20to%20submit%20the%20form%20that%20requests%20three%20attachments%20under%20three%20questions.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159865i9F890D94614837FF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EStep%202%3A%20The%20attachments%20get%20stored%20in%20SharePoint%20to%20their%20respective%20folder%20based%20on%20question%20number%20instead%20of%20a%20folder%20for%20each%20form%20submission.%20Meaning%20SharePoint%20creates%20a%20folder%20called%20Q14%20for%20attachment%201%20(for%20all%20form%20submissions)%20and%20Q15%20for%20attachment%202%20(for%20all%20submissions)%20and%20Q15%20for%20attachment%203.%20I%20would%20rather%20have%20folders%20as%20submission%201%20with%20files%20for%20Q14%2CQ15%2CQ16%20and%20submission%202%20with%20files%20for%20Q14%2CQ15%2CQ16%20and%20so%20on.%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%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F159866i37E3445AB74A093A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20it%20make%20sense%20%3F%20%3A%7C%3C%2Fimg%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1045832%22%20slang%3D%22en-US%22%3ERe%3A%20Storing%20attachments%20from%20Form%20in%20the%20relevant%20submission%20folder%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1045832%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%2F425951%22%20target%3D%22_blank%22%3E%40Appy01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYeah%20that%20upload%20thing%20per%20question%20rather%20than%20within%20a%20submission%20is%20certainly%20annoying%20(I%20experience%20the%20same%20annoyance).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20aware%20of%20anyway%20to%20change%20that%20behavior%20at%20present%20short%20of%20a%20probable%20workaround%20using%20Power%20Automate%20(formerly%20Microsoft%20Flow)%20to%20move%20the%20files%20to%20where%20I%20want%20them%20to%20be.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternatively%2C%20the%20experts%20at%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community%2Fct-p%2FPowerApps1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community%2Fct-p%2FPowerApps1%3C%2FA%3E%20may%20have%20some%20other%20ideas%20on%20how%20to%20resolve%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck!%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1047205%22%20slang%3D%22en-US%22%3ERe%3A%20Storing%20attachments%20from%20Form%20in%20the%20relevant%20submission%20folder%20in%20Sharepoint%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1047205%22%20slang%3D%22en-US%22%3E%3CP%3EAh%20thanks.%20I%20will%20check%20that%20out%20too.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

 

I am trying to connect a form that I created to SharePoint. My form accepts attachments for 3 questions. These attachments unfortunately get stored in SharePoint under respective question folder that it creates in Sharepoint. However, I would prefer to have the folders for each submission as o

4 Replies
Highlighted

Hi @Appy01 

 

I'm not sure I follow your scenario. Could you please provide some screen shots to demonstrate the form and issue? Redact any sensitive info.

 

Cheers

Damien

Highlighted

@Damien Rosario 

Step 1: Would be to submit the form that requests three attachments under three questions.

clipboard_image_0.png

Step 2: The attachments get stored in SharePoint to their respective folder based on question number instead of a folder for each form submission. Meaning SharePoint creates a folder called Q14 for attachment 1 (for all form submissions) and Q15 for attachment 2 (for all submissions) and Q15 for attachment 3. I would rather have folders as submission 1 with files for Q14,Q15,Q16 and submission 2 with files for Q14,Q15,Q16 and so on. 

 

clipboard_image_1.png

 

Does it make sense ? :| 

Highlighted

Hi @Appy01 

 

Yeah that upload thing per question rather than within a submission is certainly annoying (I experience the same annoyance).

 

I'm not aware of anyway to change that behavior at present short of a probable workaround using Power Automate (formerly Microsoft Flow) to move the files to where I want them to be.

 

Alternatively, the experts at https://powerusers.microsoft.com/t5/PowerApps-Community/ct-p/PowerApps1 may have some other ideas on how to resolve this?

 

Good luck!

Damien

Highlighted

Ah thanks. I will check that out too.