Send email with attachment from SPO - Ideas?

(0) Share

Report

Posted on by efowler99

Hi, can anyone provide some guidance on how to send specific files (attachments) from SPO in the flow email?

The specific file that needs to be attached is dictated by the selected options from the MS Form.

MS Form --> Flow Trigger --> Get file content (SPO) --> Email with attachment.

I have the overall flow working fine when I am not trying to attach a file to the email.

I tested a flow to practice email user with SPO Attachment when new file is added to SPO (this was just a test to confirm I could email an attachment from SPO via flow email).

Do you have any suggestions on how to "get content from SPO" based on MS Forms response?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

sudharsan1985 1,325 on at

Like (0)

Report
Copy link

Link copied!
Hi @efowler99

Try to get the content of the file using Get attachment content for list or Get file content using path for library. Then you have to compose an array variable with the values in the below format. You can also add multiple values in the same format if you want to add multiple attachments.

{ "Name": <Filename>, "ContentBytes": <file content in binary> }

Send the above variable to the email action. Please try it out and let me know.

Was this reply helpful? Yes No
efowler99 6 on at

Like (0)

Report
Copy link

Link copied!

Sudharsan - Thank you for the info.. I do not see Compose an array variable as an option?

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like (0)

Report
Copy link

Link copied!

Hi @efowler99

I think you are confused. I told you to initialize the variable with the value or you can also append to the array variable. Sorry for the confusion.

Was this reply helpful? Yes No