How to Create Dynamic OneDrive Folders from Microsoft Forms Uploads
Question details
The user wants to collect data (like subject or course name) via Microsoft Forms, automatically create a matching OneDrive folder, generate specific subfolders for file-upload questions, and store the uploaded files in those appropriate subfolders.

- Product
- Microsoft Forms, OneDrive, Power Automate
- Device & OS
- not provided
- Scenario
- Automating file storage and organizing submitted documents dynamically based on form responses.
- Observed behavior
- Files need to be dynamically routed to newly created custom folders based on form input, rather than falling into the default Microsoft Forms upload directory.
Ensure you have an active Microsoft 365 subscription with access to Microsoft Forms, OneDrive for Business, and Microsoft Power Automate to build the necessary workflow.
Use Power Automate to Route Form Uploads to Dynamic Folders
Microsoft Forms alone cannot create dynamic folders. You must use a Power Automate flow to parse the form data, create the necessary OneDrive folders, and move the uploaded files.
By default, files uploaded to Microsoft Forms go into a static default folder in the creator's OneDrive (Apps > Microsoft Forms). To dynamically create folders based on user input (like a course name) and sort files accordingly, you need to set up an automated cloud flow in Microsoft Power Automate.
Log in to Microsoft Power Automate, create an 'Automated cloud flow', and select the trigger 'When a new response is submitted' under Microsoft Forms. Select your specific form from the Form ID dropdown.
Add a new action called 'Get response details'. Select your Form ID again and insert the 'Response Id' from the dynamic content menu into the Response Id field.
Add the 'Create folder' action for OneDrive for Business. In the 'Folder Path' field, select your base directory, then use dynamic content (e.g., the answer to the 'Subject/Course Name' question) to name the new folder. Repeat this for any question-specific subfolders.
Because file uploads in Forms are returned as a stringified JSON array, add a 'Parse JSON' action. Pass the file upload question's response into the Content field, and generate the schema from a sample payload to extract the file metadata.
Add an 'Apply to each' loop using the output from your Parse JSON action. Inside the loop, use the 'Get file content' action with the file identifier, and then use the 'Create file' action in OneDrive to save the file directly into your newly generated dynamic folder.

Boost Your Productivity with WPS Office
While Power Automate and Microsoft Forms are excellent for complex automated workflows, WPS Office provides a lightweight, highly compatible alternative for your everyday document creation, editing, and sharing needs without expensive subscriptions.
- 1. Download the Installer: Visit the official WPS Office website and click on the 'Free Download' button.
- 2. Install WPS Office: Run the downloaded executable file and follow the straightforward on-screen installation prompts.
- 3. Open Your Documents: Launch WPS Office and instantly open, edit, and save any documents downloaded from your OneDrive directly within the app.

Frequently Asked Questions
Where do Microsoft Forms file uploads go by default?
By default, files uploaded via a personal Microsoft Form are stored in the form creator's OneDrive under Apps > Microsoft Forms. For Group or Team forms, they are stored in the default SharePoint document library.
Can I create dynamic folders using only Microsoft Forms?
No, Microsoft Forms does not natively support creating dynamic folders based on form responses. You must integrate it with Power Automate to handle custom file routing and folder generation.
Why is my Power Automate flow failing to move the uploaded file?
This usually happens if the JSON parsing step fails or if the flow cannot locate the original file ID. Ensure your 'Parse JSON' schema exactly matches the Forms file output array format, and verify you are using the correct OneDrive account connection.




