Forms uploaded file to library, based on answers to questions

[DD2020]

Hi, I would like to take a file, uploaded via Forms, and put it in a folder structure, defined by the Forms answer.

If folder does not exist, create one, if it does exist, add in existing.
E.g.:
Form_Q1: folder archive level 1
Form_A1: Comp A
Form_Q2: folder archive level 2
Form_Q2: Doc type 1
File upload: entry.pdf

Results in entry.pdf being archived in:
Site\Library\Comp A\Doc type 1\entry.pdf

Thanking you in advance for helping,

[ChristianAbata · Accepted solution]

hi @DD2020  please follow this example

json

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

[DD2020]

Thank you @ChristianAbata 

I have copy/paste the syntax for "parse JSON", as in your message.

Get the following error (xxxxxxx replaces real names):

InvalidJSON. The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value 'file u[{"name":"12345_xxxxxxx.pdf","link":"https://xxxxxxx/xxxxxxx/xxxxxxx/Documents/Apps/Microsoft%20Forms/xxxxxxx/Question/12345_xxxxxxx.pdf","id":"01C5SL7SHKAW2S6GOSBZGKYI5UNORZFLP3","type":null,"size":52007,"referenceId":"01C5SL7SCSKTFAQD2GJRD2JFDJ6ZHJTHLS","driveId":"b!7eD4K1I0Pk2sbq3M3b0N0ZWTag5ZinFAqWfQ1Kzpfqy2R39XMKJHRpG8SSSY1kmn","status":1,"uploadSessionUrl":null}]' cannot be parsed: 'Error parsing boolean value. Path '', line 1, position 1.'.

???

[ChristianAbata]

you can generete your schema follow this example please 😉

[DD2020]

Thank you @ChristianAbata !