cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoeCOP
Level: Powered On

Initialize variable with a property of a dynamic content from MS Forms File Upload

I have a MS form with a file upload question. I am creating a flow that when a new response is submitted, I would like to grab the name of that uploaded file and the link to the file of where i was uploaded(on my OneDrive). The properties of the file would be initialized or set as variable such as var_filename or var_filelocation.

 

I will then use these variable for various uses such as sending the filenames to the team via email and adding it to a spreadsheet. So how would I go about grabbing those properties of the file upload submission?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Initialize variable with a property of a dynamic content from MS Forms File Upload

Hi @JoeCOP ,

 

How many files would be uploaded in the response?

Please refer to screenshot below to create the flow to get the file name and the link:

1.png

The schema for the Parse JSON as below:

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

 

 The flow would run successfully as below:

2.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Initialize variable with a property of a dynamic content from MS Forms File Upload

Hi @JoeCOP ,

 

How many files would be uploaded in the response?

Please refer to screenshot below to create the flow to get the file name and the link:

1.png

The schema for the Parse JSON as below:

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

 

 The flow would run successfully as below:

2.png

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

JoeCOP
Level: Powered On

Re: Initialize variable with a property of a dynamic content from MS Forms File Upload

@v-alzhan-msft Thank you for the help. After some digging around I found a similar solution to your, although yours is more cleaner.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Coming Soon: T-shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors
Users online (6,413)