Send email with attached file from SharePoint library document

[adove]

I am trying to send an email to a prescribed list of users. The trigger for my Flow is "when an item is created or modified" in a SharePoint Library. While I have been able to work out the sending of a LINK to the attachment positioned in the body of the email, what I am trying to accomplish is to attach the library item as an attachment on the email.

Please see my below screenshots of my flow:

All of the examples I found online reference an "identifier" object. 

When I attempted to add a new action "get file contents", I could never grab the "File Identifier" property to allow me to grab the "content" dynamic property of the library item to use in the email.

Has anyone been able to solve this issue?

Many thanks,

ADove

[yashag2255]

Hi @adove , 

Please see the screenshots below

Note: Configure the array with the same attribute names. 

Hope This Helps!

Thanks. 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[v-zhos-msft]

Hi @adove ,

I was confused about your scenario.

Where is the file stored, in the SharePoint library or as an attachment in the SharePoint list？

If the file is in the library, I suggest you use the trihgger 'When a file is created or modified (properties only)'.

Then you can get the "identifier" from the trigger.

If the file is in the list, you can take a reference of @yashag2255's flow.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[adove]

When I run my Flow based on your recommendations, I receive an error "Column attachments does not exist." I believe this is because I am working from a library and not a list. If so, do you have another fix for allowing me to grab the file from a library?

Thanks.

[adove]

What are the series of actions to use if my file is in a SharePoint library?

[abm]

Hi  @adove ,

Use the Flow Step SharePoint Get File Content. It allows you to get the file content which you can map as your email attachment.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[adove]

After adding the 'Get File Content' action and clicking the 'File Identifier' button I get what amounts to an error. Is there an expression that I need to use instead or someother way to get the 'File Identifier' to work correctly (see screenshot):

Not sure what to do next. Any ideas?

[yashag2255]

@adove 

Please seee the screenshot below and replicate:

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[adove]

I don't think you understand. I can't call the 'Identifier' object from the 'Get file content' action. When I click into the field and press on the folder I receive a pop-up message indicating that SharePoint can't evaluate to the parameter 'path.#.dataset' ... etc.

[abm]

Hi @adove ,

The error is related to flow cannot find the fields on the library as it doesn't know which library to look and bind for.

You could try this via flow step 'Send an HTTP request to SharePoint'.

Set the address as runtime parameter like you used now, method as Post and specify the Uri (Rest API).

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[yashag2255]

Hello @adove 

Please try using the action as shown in the screenshot for that. You should use the send an HTTP request only if the direct actions do not support waht automation you are trying to achieve. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[abm]

Hi @adove ,

Any of these latest suggestions were helpful?

If you need further help please let me know.

Thanks

[adove]

No, none of the suggested solutions work. I continue to receive the above error when attempting to grab the identifier from either the 'File Path' using the 'Get file content using path' or the 'File Identifier' using the 'Get file content'. As to the suggestion that the flow doesn't know what library I am attaching to, that should have been clear from the trigger 'When a file is created or modified (properties only)' because it asks for the library name (which I input) and the associated folder (which I input as the root of the library).