cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
User25
Regular Visitor

Attachment and Screenshots from Microsoft Teams in Planner

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 

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

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

vLilyWmsft_6-1629438635837.png

Flow in details

vLilyWmsft_0-1629438322287.png

vLilyWmsft_1-1629438340612.png

vLilyWmsft_2-1629438388817.png
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"
        ]
    }
}
vLilyWmsft_3-1629438474338.png
vLilyWmsft_5-1629438568479.png
When I submit a Form with files like this:
vLilyWmsft_7-1629438665457.png

 

The files will be added into the task.

vLilyWmsft_8-1629438860028.png

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.

View solution in original post

5 REPLIES 5
v-LilyW-msft
Community Support
Community Support

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

vLilyWmsft_6-1629438635837.png

Flow in details

vLilyWmsft_0-1629438322287.png

vLilyWmsft_1-1629438340612.png

vLilyWmsft_2-1629438388817.png
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"
        ]
    }
}
vLilyWmsft_3-1629438474338.png
vLilyWmsft_5-1629438568479.png
When I submit a Form with files like this:
vLilyWmsft_7-1629438665457.png

 

The files will be added into the task.

vLilyWmsft_8-1629438860028.png

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.

View solution in original post

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.

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.

vLilyWmsft_0-1629856958406.png

Best Regards.

 

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?

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?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,087)