Unanswered

Attachment and Screenshots from Microsoft Teams in Planner

(0) Share

Report

Posted on by 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

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-LilyW-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
User25 20 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-LilyW-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No
User25 20 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
User25 20 on at

Like (0)

Report

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?

Was this reply helpful? Yes No