Unanswered

For a Selected File send email to Email Column and Attach File

(0) Share

Report

Posted on by LASA

I'm trying to create the following flow - for a selected file in SharePoint, send an email to the email in the Contact column, and attach the file for their reference.

For context, I'd like to send an expiring insurance certificate to the insured (Contact) to request an updated one. I have hundreds of insurance certificates so this would allow me to sort by ones expiring soon and send emails for specific ones that need to be renewed.

I'm getting stuck in a few places.

Where do I tell the flow to use the email in the "Contact" Column?

How do I attach the file as an attachment?

"Send an Email (V2)" keeps getting put into an "Apply to each" and it causes the flow to happen to each file not just the selected one.

I've attached screenshots of my current flow, the columns in my doc lib, and the Apply to Each error I'm getting. Any screenshots back would be very helpful!

Categories:

Building flows

Compose and Send ...

Doc Lib & App...

For a Selected Fi...

I have the same question (0)

All responses (10)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

1) The first problem I see is you are using Get Files Properties only, which will retrieve an array of files. What you want is Get File Properties and give it the File Identifier from the trigger. That will retrieve just one file. That's why you are getting the apply to each.

2) Once you have the Get File Properties in place you should have some dynamic content called "Contact Email" or something like that. YOu put that in the To field of the Send an email

Was this reply helpful? Yes No
LASA 14 on at

Like (0)

Report

Thank you, that solved my issue with the Apply to Each!

So now my remaining issue is getting the file to attach to the email. I believe I have to add a "Get file content" but this keeps braking the flow. Can I have a Get file properties and a "get file content" in the flow?? Without the "get file content" I cant add "File content" to the Compose.

Get File Content.PNG

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

After you do the Get file properties you'll need a Get file content using the same File Identifier. Then you can add the filename with extension and the content in the advanced properties of the email.

Was this reply helpful? Yes No
LASA 14 on at

Like (0)

Report

There are two "ID"s available in Dynamic content, one for "For a Selected File" and one for "Get file properties" but either one I use causes an error with "Get file content" when I run the flow...
"File not found
clientRequestId: 6e45f5c2-a6bc-48c9-b924-266c44dd8167
serviceRequestId: 6e45f5c2-a6bc-48c9-b924-266c44dd8167"

File Identifier.png

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

There is an ID which is the List Item ID. and an ID that is the File Identifier. Use the File Identifier ID from the for a selected file Trigger.

Was this reply helpful? Yes No
LASA 14 on at

Like (0)

Report

I am still have the File Not Found error and I cannot figure out why.

Get File Not Foun...

Was this reply helpful? Yes No
LASA 14 on at

Like (0)

Report

I am still getting the File Not Found error and I cannot figure out why.

Get File Not Foun...

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

The run shows a file identifier of 8. That would be the list ID, not the file Identifier. The file identifier should be a path value. Double check again that you are using the one labeled as the file identifier from the for a selected file trigger.

Was this reply helpful? Yes No
LASA 14 on at

Like (0)

Report

I had definitely used the "ID" labeled as the file identifier for a selected file, but that wasn't working. A little extra research led me to try this "Identifier" (value that can be used in file related actions for selecting...) and that worked!

I did use "File Content" for the email Attachment Content and that still worked.

Thank you for your help!!

Identifier.PNG

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Identifier is the one in the Get File Properties. The same value in the Trigger is labeled as File Identifier.

Either will work. The other ID is from the Get File Properties and it won't work.

Was this reply helpful? Yes No