Insert link in approval to file uploaded in form

[Anonymous]

Hi

Looking to automate creating planner tasks  

In the approval request notification, I want to include a link to the file uploaded (if any were uploaded).

Unfortunately, it doesn't seem to be as simple as putting the file upload response into the item link field, am I missing something?

 

Any help much appreciated  😀

Thanks

Josie

[PURNA429 · Accepted solution]

Hi @Anonymous ,

Assuming this form is created in My Forms ( not the group forms ), the uploaded file will be stored in to the form owner (creator's) one drive .

When you extract the FileUpload field in flow, its output will be like this ( in JSON ) and which contains "link" as one of its nodes.

So we have to parse this JSON to get the link node's value.

For that, after Get Response details add a action called Parse JSON and add your "fileupload" field name in content

and add below code in to the schema field. ( Got this code from already existing thread )

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

Once this is done, add a action called set variable ( initialize it start of the flow ) to store the link of the file upload link as below :

If I answered your question, please mark this question as answered and if you liked my response, please give a thumbs up .

Thanks

Purna

Blog 

[KallyTeoKT]

To tag onto this post,

May I ask what are the additional steps if there are more than 1 file? (For example there are 3)

Thank you in advance

[swgsit]

hi, thank you for your help and i have followed the same uid but when i received the link to an email where one drive file folder path (hyperlink). unfortunatly when i click the link that folder path it is again opening email with seperate tab. any point of this regard 

[swgsit]

Do you want to know how to store more than 1 files in one drive or you want to get more file(s) path send via an email ??