Send an email from a shared mailbox (v2) and attach a file from SharePoint

[techtudoor]

I have a very simple Power Automate Flow (when a new email arrives in a shared mailbox (v2)) --> (Send an email from a shared mailbox (v2)).

This is working just how it needs to, however, I have now been asked to add an attachment to the outgoing email. This has become problematic. The attachment the needs to be attached is located in my SharePoint Online document library. I have tried using Get file content, and this sent the email with a .xmIPK attachment. The file I am trying to attach is a .docx.

I am at a loss as to what I am missing to get this to attach to the email. Any assistance is greatly appreciated

[PriyankaGeethik]

Hi @techtudoor,

Would you try with Get files properties 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[techtudoor]

@PriyankaGeethik thank you for the suggestion. However when I try to do this, the email contains a text document with just the item ID as the name and no data

[PriyankaGeethik]

@techtudoor in the run history of the flow did you get the correct file properties ? No data files are usually due to file extension or content mismatch.  

[ScottShearer · Accepted solution]

@techtudoor 

It sounds like the same file will be attached all the time.  If so, add the ID column to a view of your library.  Make note of the ID of the document that you want to attach.

Then, follow my example below and let me know if you have any questions.  Don't worry that there is a loop - only 1 email will go out.

[techtudoor]

@ScottShearer , thanks so much that worked great. I really appreciate the assistance