Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 0N+/hAfURyy+clEDrOBytM
Power Automate - Building Flows
Answered

MS Forms file uploads directly to the SharePoint without OneDrive involved

Like (0) ShareShare
ReportReport
Posted on 27 May 2021 20:09:30 by 36

Hello Everyone,

I'd like to get quick reference how I can manage with uploads from the MS Forms directly to SharePoint document library? Currently the flow that tackles the Uploads in this manner:

 

Form with uploaded file -> Uploaded file on OneDrive -> Copy to particular Document Library on SharePoint -> Delete the file on OneDrive

 

I was thinking about

 

Form with uploaded file -> Temporary folder on SharePoint -> Copy to particular Document Library on SharePoint -> Delete the file in temp folder on SharePoint

 

 

The point is to remove OneDrive from the picture, I don't want to use it anymore as temporary buffer for incoming files. I heard something about different MS Form mode, like public or something, but I can't find the answer anywhere. Any help appreciated. 

 

Thank you in advance

  • RemkoN Profile Picture
    2 on 25 Apr 2024 at 12:29:43
    Re: MS Forms file uploads directly to the SharePoint without OneDrive involved

    That is not correct - by changing the Group where the Form is assigned to -> the location of the files are stored in a folder within that group (not a OneDrive anymore)

  • Polymer3 Profile Picture
    35 on 21 Aug 2023 at 16:30:40
    Re: MS Forms file uploads directly to the SharePoint without OneDrive involved

    @cnovotny here is an expanded set of steps that we use 

     

    Polymer3_0-1692635507198.pngPolymer3_1-1692635527297.png

    Polymer3_2-1692635548279.png

    (attachments are the same as the above pics in case they are not clear enough)

     

    In the example the attachment is in an 'IF' condition so that it only process this part if there is actually an attachment (used for when attachment question is optional)

     

    I have redacted a lot of the information for our own privacy. The best think to get the upload path is to complete the form once and hunt down the path.

     

    The form Id should be the same one as in the trigger (when a new response is submitted) and not Response Id as you have

     

    The JSON should have the content set as the form attachment question and the JSON schema is as follows

     

    {
     "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"
     ]
     }
    }

     

     

    Please let me know if you need further guidance

  • cnovotny Profile Picture
    7 on 21 Aug 2023 at 16:11:50
    Re: MS Forms file uploads directly to the SharePoint without OneDrive involved

    @Polymer3 Wow - thank you! Here's what I'm looking at... I'm lost with all four steps (and should probably just take a Power Automate class already because clearly this isn't clicking for me). 

    Screenshot 2023-08-21 120906.jpg

  • Polymer3 Profile Picture
    35 on 21 Aug 2023 at 16:05:09
    Re: MS Forms file uploads directly to the SharePoint without OneDrive involved

    @cnovotny sure!

     

    What step do you need guidance on?

  • cnovotny Profile Picture
    7 on 21 Aug 2023 at 15:49:38
    Re: MS Forms file uploads directly to the SharePoint without OneDrive involved

    @Polymer3 Novice here! Could you show how you set up all of the steps? I'm a bit stuck...

  • espan88 Profile Picture
    36 on 29 May 2021 at 04:17:56
    Re: MS Forms file uploads directly to the SharePoint without OneDrive involved

    @Polymer3 thank you, I'll definitely try it!

    Cheers!

     

  • Verified answer
    Polymer3 Profile Picture
    35 on 28 May 2021 at 13:41:10
    Re: MS Forms file uploads directly to the SharePoint without OneDrive involved

    There is a way to use MS Forms directly with SharePoint without touching OneDrive

     

    You create a form directly to a SharePoint group.

     

    On the forms main page at the bottom it will have a list of your SharePoint groups (called 'My Groups')

    If you create a form there (called a group form) then it will upload directly to that SharePoint.

     

    Screenshot 2021-05-28 143858.png

     

    Only thing to be aware of, is that the group form will not show up on the flow builder - you need to enter the Form ID which can be found on the form by pressing share and taking the last bit of the URL (after the ID=)

     

    Below is an example flow we use - you can see the Form ID copied from the share link, and the sort of path that the form uses to upload to SharePoint. To get this path, easiest way is to complete the form once, then build the form as it can be a challenge to get the path before its created

     

    Screenshot 2021-05-28 143523.png

     

  • espan88 Profile Picture
    36 on 28 May 2021 at 12:06:33
    Re: MS Forms file uploads directly to the SharePoint without OneDrive involved

    Thank you @Pstork1  and @Paulie78 . I was facing some error messages during uploading process and I was just curious if there is any other way to do it. Good to know that we have some alternative way, but MS Forms is the only way to go. I hope that we will be able to change directory for those uploaded files in near future. It would help me a lot. 

  • Paulie78 Profile Picture
    8,407 Super User 2025 Season 1 on 28 May 2021 at 00:22:36
    Re: MS Forms file uploads directly to the SharePoint without OneDrive involved

    You could use a different forms system, most handle file uploads quite easily. I have also written a really simple file upload facility with Power Automate, I am going to write it up next week. Check this video I did out:

    https://www.youtube.com/watch?v=c4aLEJaORYo

    This form can upload files directly without writing them anywhere first.

  • Pstork1 Profile Picture
    66,164 Most Valuable Professional on 27 May 2021 at 20:14:30
    Re: MS Forms file uploads directly to the SharePoint without OneDrive involved

    There is no way to get them to load directly to SharePoint.  Saving the files to OneDrive is what MS Forms does.  The flow just retrieves it from there to create it in SharePoint.  There is no way to change where MS Forms will upload the file.  It will always go to OneDrive.

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 97

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard