question

MaggiacomoMichael-3577 avatar image
0 Votes"
MaggiacomoMichael-3577 asked ajkuma-MSFT edited

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

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.

not-supported
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I'm not very familiar with SharePoint but could you try to use Azure Functions or LogicApps to send emails?

0 Votes 0 ·

Apologies for the late response on this. Since the scenario is related to SharePoint and Flow, it is recommended to post such questions on the following dedicated forums where you will receive more specialized assistance from our targeted audience.

https://social.technet.microsoft.com/Forums/sharepoint/en-US/home?category=sharepoint

https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

Microsoft Q&A supports all Azure services today. In addition, in the coming weeks Microsoft Q&A will support more products and services.

If you wish to learn more about the new platform, kindly see Microsoft Q&A Getting Started :
https://docs.microsoft.com/answers/articles/388/microsoft-qa-frequently-asked-questions.html

We really appreciate all the active and insightful conversation on this topic so far. Thanks a lot!


0 Votes 0 ·
MirkoSalicini-8837 avatar image
1 Vote"
MirkoSalicini-8837 answered

hi @MaggiacomoMichael-3577 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://docs.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://docs.microsoft.com/it-it/azure/logic-apps/logic-apps-overview

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Stephen-4315 avatar image
0 Votes"
Stephen-4315 answered

Hi @MaggiacomoMichael-3577,

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PankajGawande-9962 avatar image
0 Votes"
PankajGawande-9962 answered

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

Article Link


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

kenchung avatar image
0 Votes"
kenchung answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.