Attachment and Screenshots from Microsoft Teams in Planner

[User25]

Within a Microsoft Form, I have a question to upload and attachment. This same question was then added to the description of a planner task however when I view the description within the task, it is a broken link. The only way I can find the attachment was via One Drive > Apps > Microsoft Forms > Team Channel > Attachment Question 

[v-LilyW-msft · Accepted solution]

Hi @User25 

Do you want to attach files from Microsoft Forms into a Planner Task?

I set up a Flow and can attach files from Microsoft Forms into a Planner Task.

You can refer to:

This is my test From

Flow in details

The schema used in the Parse 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"

        ]

    }

}

When I submit a Form with files like this:

The files will be added into the task.

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

[User25]

Hi, 

How can this JSON be tweaked in instances where there are no attachments uploaded? There are cases in which attachments are optional which leads to the flow failing.

[v-LilyW-msft]

Hi @User25 

You can add a judgment condition, if the uploaded file is not empty, create a task and update the task, if it is empty, just create a task.

Best Regards.

[User25]

Hi, 

If I add this to my flow, it will get significantly larger due to how I set up my flow. 

For some background, the Microsoft Form is used to break out different request types. Each request type has its own bucket ID within Planner. My current flow is :

When a new response is submitted -> Get Response Details -> Initialize variable -> Parse JSON -> Apply to each 

-> Append to array variable -> Condition for request type 1 -> If yes Create a task -> Update task details -> If no -> Condition for request type 2 -> If yes Create a task -> Update task details 

Is there a dynamic expression I can use so that it can determine the bucket ID instead of me breaking each request type out to its own bucket id?

[User25]

Thank you for your help.

It looks like it did work for my flow. However I have a question about the attachment. It appears that the attachment within a create task is named as "file name_user." Is there any way I can extract the user component from the attachment name or possibly match that back to the email associated with that user?