Send Single E-Mail Containing Excel Attachment(s) from Sharepoint List Based on Specific User

[nbbell]

Right now I have a Flow setup that automatically notifies a user of an upcoming expiration of a request they submitted to my team. It sends an e-mail 30 days before the expiration and gives the user the name of their request along with other bits of information (the expiration end date, direct link, etc), but I would also like to include the attachment(s) to the request itself. This could be multiple Excel files (for example, if the user wishes to renew, it would be a new attachment added to the list entry).

Additionally - it updates a separate column called "notified" to prevent that list entry from being sent again.

The user fills out an Excel form as part of their request. These requests also have approvals (often as .pdf or e-mail attachments) that I would like to exclude. Down below is what my flow currently is, and I'm struggling to figure out how to have a single e-mail sent with only Excel attachment (could be multiple), which display the file name.

In a test example I was able to send out an email with multiple images but they were sent as multiple e-mails instead of a single e-mail, and it did not include the actual file name (but rather the Id from Get Items that included the filename at the end, between garbled characters).

[v-qiaqi-msft]

Hi @nbbell,

Based on the issue that you mentioned, do you want to send a single email including multi attachments?

Could you please share a bit more about the scenario?

I think the point is that you should add the Send an email action outside the Apply to each as an single step.

Here I think you should add the Get attachments content action to read the attachments, here I post my complete flow for reference.

[nbbell]

I was able to get this working, but had to swap out the AttachmentContent from the append step with the following:

body('Get_attachment_content').$content

Prior to that I was getting errors when it was trying to send an email.

{
  "status": 400,
  "error": {
    "message": "No input parameters provided. Please provide required input parameters 'To', 'Subject' and 'Body'."
  },

Follow-up question: Is there a way to only send a specific file type? If a list entry has a few Excel files, a .pdf and a .msg I would like to just send the Excel files.

[v-qiaqi-msft]

Hi @nbbell,

Could you please attach your complete flow configuration?

The error message indicates that you need to input the required information of the 'To', 'Subject' and 'Body'.