web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to create a Flow w...
Power Automate
Answered

How to create a Flow which stores Microsoft Forms answers in a common/separate folder

(0) ShareShare
ReportReport
Posted on by 31

Hi all,

 

I've created a Microsoft Forms with some upload questions. The answers should be accessible for other colleagues within the organization. The default setting, which is not adjustable, will store the data on my personal OneDrive.

I want to create a flow that stores the answers and attachments, in OneDrive in a folder that is generally available by the organization instead of my personal folder. It should create a folder per respondent included the answers/attachments.

 

Regards,

Djarano

Categories:
I have the same question (0)
  • Jcook Profile Picture
    7,781 Most Valuable Professional on at
    Hello,

    May I ask why you are using OneDrive,
    SharePoint might be a lot easier.
    OneDrive will be linked to your account unless you can use a service account that will be used for storing the files on OneDrive.

    The reason I think SharePoint is better for this, is because you can allow all users in org to be able to access and not have to worry about anything being tied directly to your account

    —Josh
    If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
  • Djarano Profile Picture
    31 on at

    Hi,

     

    The reason why I use OneDrive is because it is mandatory by the organization. I think it is a organizational policy, which forced us that the respondents are automatically stored in my personal OneDrive. What is the solution to use SharePoint?

     

    Other option is to keep it like this and give the specific people access to the folders where the answers are stored. Important thing here is that the Folder name should have the same name as the answer of the first question in Forms. It should store the answers per question and the attachments.

     

  • Jcook Profile Picture
    7,781 Most Valuable Professional on at
    Hi,

    Well if you organization wants you to use OneDrive. Than yes you can have a main folder on your OneDrive that is shared to everyone and just have the flow create sub folders for the questions.

    For SharePoint. All office365 groups should have a SharePoint site. Again though if you organization wants you to use a specific connector or process due to policies. I would follow them, unless you can persuade otherwise.

    —Josh
    If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
  • Djarano Profile Picture
    31 on at

    Alright, so I will create a main folder: Customer, and by using Power Automate it automatically should create sub folders with a specific name. And a summary of the answers + attachments should be saved in the sub folder. 

    In example:

    • Customer
      • Customer 1 - Project x
        • Answers + attachment(s)
      • Customer 2 - Project y
        • Answers + attachment(s)
      • Customer 3 - Project z
        • Answers + attachment(s)

    So it shoud look like the structure as showed above.

     

    Could you help me building the flow in Power Automate?

  • Verified answer
    Jcook Profile Picture
    7,781 Most Valuable Professional on at

    Hi @Djarano 

     

    Here is a POC I built for you:

     

    My sample formMy sample form

    This is a sample form that I have created, to simulate what you described 

     

     

     My Flows Overview of all the actions - As normal you will want to use When a new response is submitted followed by a Get response details .

    Flow OverviewFlow Overview

     

     

     

     

    Step 1 - Use a Create file action

     

    Folder Path - Use the Folder Icon to navigate to the Share Folder Customer.

    Add the rest of the path manually. (This will create the folder structure for you if the path does not exist already)

    File Name - Whatever you want the answers to be in

    File Content - The answers from the Form (Not the attachments)

    Step 1Step 1

     

     

    Step 2 - Add a Parse JSON action

    Content - Use the dynamic content for the Attachment question in the Form

    Schema - {I Have pasted the Schema that you can use at the end of the steps}

     

    Add a Apply to each loop

    Output from previous step - Use the dynamic content from the Parse JSON

    Step 2Step 2

     

     

     

     

    Step 3 - Add a Get file content action

    File - Use the id from the parse JSON dynamic content

    Step 3Step 3

     

     

    Step 4 - Add a Create file action

    Folder Path - Do the same as Step 1, this time the flow will not create the folder structure because it already exists, we just want to add the Attachments here. NOTE: make sure the Folder Path is the EXACT same as Step 1   

    File Name - use name from Parse JSON dynamic content

    File Content - use the File content from Get file content dynamic content

    Step 4Step 4

     

     

    The Results is: 

    Final OutputFinal Output

     

    Here is the Schema to use for Parse JSON action:

    {
     "type": "array",
     "items": {
     "type": "object",
     "properties": {
     "name": {
     "type": "string"
     },
     "link": {
     "type": "string"
     },
     "id": {
     "type": "string"
     },
     "type": {},
     "size": {
     "type": "integer"
     },
     "referenceId": {
     "type": "string"
     },
     "driveId": {
     "type": "string"
     },
     "status": {
     "type": "integer"
     },
     "uploadSessionUrl": {}
     },
     "required": [
     "name",
     "link",
     "id",
     "type",
     "size",
     "referenceId",
     "driveId",
     "status",
     "uploadSessionUrl"
     ]
     }
    }

     

    If you have any questions let me know.

     

    —Josh
    If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others

     

  • Djarano Profile Picture
    31 on at

    Thank you

    I can open the file, but the structure of the answers is not adequate. And i just see the answers, not the question anymore.

    I prefer to see it like:

    - Question 1 - Answer 1

    - Question 2 - Answer 2

     

    Possible to have a view where I can see the questions and the answers?

    https://ibb.co/1r9whxN 

  • Djarano Profile Picture
    31 on at

    Hi,

     

    Other issue i'm facing with is that it will upload only 1 file to OneDrive. For now i've two questions with the possibility to upload documents. So what i did, is that I add both questions (where you can upload documents) to the 'Content' rule on Parse JSON. See link: https://ibb.co/gdk2t7N 

     

     

  • Jcook Profile Picture
    7,781 Most Valuable Professional on at
    Hi,

    So for the SharePoint file. You will want to add the extension to the end of the file name when creating the file.

    For multiple files different questions you will have to follow steps again for each question that has a attachment.

    —Josh
    If you like my post please hit the "Thumbs Up" -- If my post solved your issue please "Mark as a Solution" to help others
  • Djarano Profile Picture
    31 on at

    Hi,

     

    1) So from which step/flow do you need to copy the flow for each attachment? so I can create a parallel branch

     

    2) And how to structure the answers, I prefer to see it something like:

    - Question 1 - Answer 1

    - Question 2 - Answer 2

  • Djarano Profile Picture
    31 on at

    Hi @Jcook ,

     

    i've created the second parallel flow for the 2nd attachment, so that's done! Thank you again.

     

    Last thing is that i want to structure the way how the answers are presented. The file that now is created is not structured and the Questions are not visible, only the answers. Do you know if this is even possible?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard