Get specific file from Onedrive Business and add file as attachment on outlook.

(0) Share

Report

Posted on by Sormick

566

Hello,

I need to get a specific file from Onedrive from my Power app and send it as attachment By Outlook Email.

I know it's filename but need to get the full path of this file and send it as attachment by email.

Here is my current function i use to send email:

Office365Outlook.SendEmailV2(MAILDESTINATION;"This is my file:";{From: MYMAIL;Attachments: [
{Name:"MYFILE.PDF";ContentBytes:PDF(MYFILETEST)};]})

Any suggestion?

In the case if working with onedrive files is more complicated that sharepoint , i can also upload these files to sharepoint. In this case please suggest me another suggestion.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @Sormick,

Firstly, you are going to need to do this in Power Automate as the actual Content of either option (OneDrive or SharePoint) is not available directly in Power Apps. Also, if using OneDrive, this is accessed in the context of the Logged-in user (so it will see their OneDrive), so in the Flow, you would need to configure the Run only users to use your connection. SharePoint is a much better idea here (you can simply send the Identifier, grab the content and add to the email).

The PDF however produces another challenge as you will need a Premium Connector (Adobe one example) to PDF the content of the file.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report

Dear @WarrenBelz,

Thank you so much for your reply.

I'm an business user.

Please note that the file is already in PDF format. Do not need to convert it. just need to send this file as email attachment.

With my current understanding of Power automate i think i will know how to get the File ID but don't know how retrieve it on power automate.

For sure if sharepoint is easier than onedrive, so these files will be store on a sharepoint folder.

Just need to know after getting the file ID how to get this file using the Office365Outlook.SendEmailV2 function.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @Sormick,

Flow is below - you need to send the file Identifier which is available if you connect the Library as a data source.

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report

Dear @WarrenBelz ,

Thank you as always for your reply but i would rather prefer to use the Office365Outlook.SendEmailV2 function in power apps instead of using the Send an email V2 element on power automate because i have some restrictions on my automate about with some emails.

I managed to save these files to a sharepoint list as attachments. (One attached file per element)

Maybe it would be easier to get the attached files to be sent by email?

Is there a power apps function to retrieve the attached file of my sharepoint list?

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @Sormick,

Yes, you can send attachments to an email directly from Power Apps - I have a blog on this that adds some other options as well.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report
Sorry I'm a newbie with some power apps formulas.

I jist need to get the file which is stored in the first element of my sharepoint list.

Not sure if i need to create a Galery or Datatble to retrieve my attachment.

I tested with this formula with no success:

Please note that i have a french version of Power apps, this is why the formula is a little different than the english one.

Office365Outlook.SendEmailV2(( "xxx@yyy.com"; "Sujet de l'e-mail"; "Veuillez trouver ci-joint les fichiers sélectionnés."; { 'Pièces jointes_Colonne3': RenameColumns(( Filter( Gallery1.AllItems; First(Gallery1.Selected.'Pièces jointes').Value ); "Value"; "ContentBytes" ) } )

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @Sormick,

Assuming you want the first attachment from the record selected in your Gallery.
Office365Outlook.SendEmailV2( "xxx@yyy.com"; "Sujet de l'e-mail"; "Veuillez trouver ci-joint les fichiers sélectionnés."; { Attachments: { Name: First(Gallery1.Selected.Attachments).DisplayName; ContentBytes: First(Gallery1.Selected.Attachments).Value } } )

I do not know if the French version has a different field name for Attachments field, but this is the English version. The field name you supplied seems to translate to 'Attachments_Column3', which I do not think is correct (there is only one Attachment column in a SharePoint List)

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

Sormick 566 on at

Like (0)

Report
Thank you @WarrenBelz !

Please find below the final formula which worked perfectly for me:

Office365Outlook.SendEmailV2( "xxx@yyy.com"; "Sujet de l'e-mail"; "Veuillez trouver ci-joint les fichiers sélectionnés."; { Attachments: { Name: First(Gallery1.Selected.'Pièces jointes').DisplayName; ContentBytes: varContenuBinaire } } )

This formula sends by email the first attachment of my sharepoint Gallery

Great support all!

Was this reply helpful? Yes No