Adding attachment from Form to Teams

(0) Share

Report

Posted on by SandraA

Hi All,

I was wondering if someone might be able to help. I created a flow which, when a MS Form is submitted:

1. Sends an email notification to relevant people

2. Creates a message in the relevant channel in MS Teams

I use Dynamic content to include all the answers from the Form questions, which works well.

But one thing doesn't seem to work in very well, especially in Teams. One of the Form questions allows responders to upload a file. I can get that file to show in the email (although it doesn't looks pretty - name and clickable link of the file. Do you have any idea how to make it look better? - see the Upload maps row).

But in the Teams notification it doesn't seem to work at all. All I get is this:

*****

Map uploads: [{"name":"QLD-Map_Sandra Adams 1.jpg","link":"https://eskmappingcomau705-my.sharepoint.com/personal/sandra_adams_eskmapping_com_au/Documents/Apps/Microsoft%20Forms/Drone%20Survey%20-%20Forestry/Question/QLD-Map_Sandra%20Adams%201.jpg","id":"01I7E6KRHO6QXMX7QVZZBIXM5Y2SFLFPAI","type":null,"size":46335,"referenceId":"01I7E6KRBFTNCIMO6TPBGJM5FHJAXZPEA4","driveId":"b!RWXiKKneQEypERhLd2k5B2NZqp_BW3hBv4HtXjpAoFPyNQZN7H78T6awQhQ78nDV","status":1,"uploadSessionUrl":null}]

*****

Is there a way to attached the files from the Form into the Teams channel notification?

Many thanks,

Sandra

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

fchopo 8,003 Moderator on at

Like (1)

Report
Hi @SandraA

When you upload a file when responding to a Forms form, the file is stored in the OneDrive storage area of the user who created the flow, where only this user has access (unless he/she shares it with other users). Therefore, the best idea should be to create a copy of the file to the Teams folder (something like this):

1) Get response details

2) Parse the content of the file question (in this case, "Business justification"). The parse json schema would be:

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

3) Then, you could select link property to get the url of the file, and name to get its name, and use those actions to get the content and copy it to the Sharepoint document library related to Teams.

Hope it helps!

Ferran

Was this reply helpful? Yes No
SandraA 30 on at

Like (0)

Report

Thank you for your reply. I passed this on to our Dev team and asked them for help, as it's way above my abilities 😊

Was this reply helpful? Yes No