Send email with excel as attachment

[jshah]

I am unable to send an email with excel file on my desktop or onedrive.

[ScottShearer]

Could you provide some more detail such as any erroro messages that you receive, a crenn shot of your Flow, etc..

[jshah]

Actually there is no option to attach excel file in email. If you could send some sample screenshot on how to send an email with excel as attachment that would be helpful.

My excel file is on one drive.

thanks.

[ScottShearer]

I believe what you are trying to do is use the "For a selected file" trigger to attach the selected file to an email.  This is not available in the consumer/free version of OneDrive but is available in OneDrive for Business.  I don't know if there are plans to add this capability to the consumer version of OneDrive.

If what you want to do is to send an email with a file attached when that file is created or modified, that capability is currently available.

The  screen shot below uses a OneDrive and Outlook (consumer version) connection.

Scott

[v-xida-msft · Accepted solution]

Hi @jshah,

Do you want to send an email with an Excel file from your OneDriver as attachment?

I agree with @ScottShearer's thought almost, I have made a test on my side and please take a try with the following workaround:

• Add a proper trigger, here I use Flow Button trigger.
• Add a "Get file metadata" action, File field set to a specific file that you want to send as email attachment.
• Add a "Get file content" action, File field set to Id dynamic content of the "Get file metadata" action.
• Add a "Send an email" action, Attachments Name -1 field set to Display name dynamic content of the "Get file metadata" action, Attachments Content -1 field set to File content dynamic content of the "Get file content" action.

Image reference:

The flow works successfully as below:

 

Best regards,

Kris

[jshah]

Perfect!

thanks.