Forum Discussion

Appy01's avatar
Appy01
Copper Contributor
Nov 05, 2019

Storing attachments from Form in the relevant submission folder in Sharepoint

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

  • Damien_Rosario's avatar
    Damien_Rosario
    Silver Contributor

    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

    • Appy01's avatar
      Appy01
      Copper Contributor

      Damien_Rosario 

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

      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. 

       

       

      Does it make sense ? 😐 

      • Damien_Rosario's avatar
        Damien_Rosario
        Silver Contributor

        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

Resources