Add Attachments from MS Form to a Sharepoint Document Library

Hi @Oliver Allsworth,

Thanks for taking the time to explain your scenario so clearly. I understand what you’re trying to achieve here, and in principle, this can be done using an automated cloud flow in Power Automate.

That said, I’d like to gently clarify that this community focuses on Microsoft 365 products, especially the out‑of‑the‑box functionality of Microsoft Forms, the request you’re working on is much more closely related to Power Automate. In order to make sure you receive accurate guidance and avoid any confusion or incomplete information from our side, it would be best to raise this question directly in the Microsoft Power Automate Community

The reason for this suggestion is that our resources and hands‑on expertise with Power Automate are quite limited in this category. Over in the Power Platform Community, you’ll find the most experienced and knowledgeable members, including Microsoft partners and users who work with complex flows on a regular basis. They’ll be in a much better position to walk you through the logic and help fine‑tune the solution you’re aiming to build.

I apologize for needing to redirect you to a different community, and I really appreciate your patience and understanding. This is just to ensure you get the quickest and most reliable support possible.

Thanks again for your time, and I hope you’re able to implement the flow successfully.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

Use Power Automate with the SharePoint connector to automate this end to end.

1. Trigger on new Forms response
   • Create a cloud flow with the Microsoft Forms – When a new response is submitted trigger.
   • Add Get response details to read all answers, including:
     • The field that will define the folder name.
     • The file upload question(s).
     • The URL attachment question(s).
2. Determine the target folder path
   • From Get response details, take the answer that should be used as the folder name (for example, a “Project Name” or “Request ID” field).
   • Build a folder path string, for example:
     Shared Documents/<LibraryName>/<DynamicFolderName>
3. Create the folder if it does not exist
   • Add a SharePoint Create new folder action (from the SharePoint connector actions).
   • Site Address: your SharePoint site.
   • List or Library: your document library.
   • Folder Path: the parent folder (if any).
   • Name: the dynamic folder name from the Forms field.
     This action will create the folder or folder path as needed.
4. Move uploaded files (File Upload questions)
   Forms file-upload answers are stored in a backing SharePoint/OneDrive location. In the flow:
   • Use the file metadata from the Forms response (ID/path) as input to SharePoint Copy file or Copy folder actions, which work like the Copy to command in a document library.
   • Destination: the folder path created in step 3.
   • Optionally, use Delete file after copying if the files must be moved rather than copied.
5. Create links for URL answers (URL attachment questions)
   For URL-type answers in the form:
   • Add a SharePoint Create file action to create a small text/URL file in the target folder, or
   • Use Create item in a SharePoint list that stores metadata and the URL, or
   • Use Create sharing link for a file or folder if the URL refers to an existing SharePoint file and a shareable link is needed.
     The key is to store the URL value from the Forms response as a file or list item inside the same dynamically created folder.
6. Result in SharePoint
   • The flow creates a folder named from the chosen Forms field.
   • All uploaded files are copied/moved into that folder.
   • URL answers are represented as link files or list items in the same folder.

This uses the SharePoint connector’s Create new folder, Copy file, Copy folder, Create file, and Create sharing link for a file or folder actions to mirror the manual Copy to behavior in document libraries.

References:

• Microsoft SharePoint Connector in Power Automate
• Work with files in a document library
• Create a folder in a document library