MS Forms file uploads directly to the SharePoint without OneDrive involved

[espan88]

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

[Pstork1]

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.

[Paulie78]

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.

[espan88]

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. 

[Polymer3 · Accepted solution]

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.

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

[espan88]

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

Cheers!

[cnovotny]

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

[Polymer3]

@cnovotny sure!

What step do you need guidance on?

[cnovotny]

@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). 

[Polymer3]

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

(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

[RemkoN]

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)