What is the easiest method to send an email notification withe a SharePoint list item attachment?

Question

I am trying to create a flow to send an email on demand from a SharePoint list. I need to have fields in the list populate in the email subject and body and also pull the list item attachment and send it as an email attachment.

Scenario: Client submits a request for service, adds key information and attaches a field service guide. I need to then create a flow which sends an email notification to someone with certain fields from the item as well as the file attachment itself.

I have gotten as far as getting the email to send with the attachment but it will not pull the values of the list fields into the body of the email.

Answer 1

hi @Maggiacomo, Michael if you use SharePoint Online you can use Microsoft Flow.
https://flow.microsoft.com/

With MS Flow the flow can be run directly from the user logged in SharePoint Online.

You can use MS Flow with SharePoint 2016+ in an on premises evirorment if you install an "On-Premises data gateway" in the SharePoint Server.
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem

Another solution is to use Azure Logic App.

The last one is like MS Flow but for enterprise use.
You can access to Azure Logic App from Azure Portal.

https://learn.microsoft.com/it-it/azure/logic-apps/logic-apps-overview

Answer 2

Hi @Maggiacomo, Michael ,

I would recommend using flow for this.
The built in connectors will allow you to pick up the fields. You will need to use the Sharepoint action >get properties.

Then in your email action you should see all the fields available in your list.

Stephen

Answer 3

Check our the Technet article it explains how to send email with fileds from SharePoint list with Flow

Article Link

Answer 4

Hi @Maggiacomo, Michael

You might check this Flow template which shows how to add SharePoint list content in the email body.
https://asia.flow.microsoft.com/en-us/galleries/public/templates/2bd714484de84d1391cb288208b9f609/send-a-customized-email-when-a-new-sharepoint-list-item-is-added/

Ken