Send mail with attachment when a new message and file posted in Teams channel

[asingh8111]

Hello Everyone,

I'm facing a issue to send mail with attachment when a new message with attached file posted in Team channel.

I'm able to create flow to send message when posted message in channel but file is not getting send as attachment.

Could you please try and let me know what expression I should try.

Thank you in advance.

[ChristianAbata]

hi @asingh8111  the message sended to teams as attachments? for example as .msg

[v-litu-msft · Accepted solution]

Hi @asingh8111,

You could following these steps to send an email with attachments when a message upload a file into a channel in MS teams:

1. My team named Westeros, and I create a trigger when a new channel message is added, you could create a condition under it to whether has attachment in a newly added message to determine the following steps. For a better explanation, I didn't create it.
2. Initialize an array variable named Attachment to store File attachments.
3. Create Apply to each action to loop through attachments get from channel message.
4. Get Filename by using the expression: item()?['name']
5. Get SiteAddress by using the expression: split(item()?['contentUrl'],'/Shared Documents')[0]
6. Get FilePath by using the expression (the 'Westeros is my team's name, you should use yours'): split(item()?['contentUrl'],'Westeros')[1] 
7. Then add Get file content action of SharePoint connector, put the output of the step 5 and 6.
8. Add Append to an array variable action, when you append the contentByte field, you should convert the file content into base64 by base64() function.
9. After the loop, put the variable into the send email action.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[asingh8111]

Hi,

Any file uploaded or posted in channel like, xls, pdf, txt etc...

same should get send as attachment to outlook...

[asingh8111]

Hello @v-litu-msft 

Thanks for the reply, let me try and will update you..

[asingh8111]

Hello @v-litu-msft 

Yes, It's working 😀

Thank you very much for the solution and guidance.