Send email with flow for each row from SharePoint List with the attachment of each record

[ramyhabka]

Hello, 

I am trying to create a flow to schedule sending emails on weekly basis from the available data of a SharePoint List, the email should include the data in the list and the attachment for each record.

When trying to get the attachment content; i cannot find the id and file identifier in the dynamic content?

How to achieve that? or how to send such emails with attachment of each record?

Thank you,

[#2]

@ramyhabka 

After you "Get attachments" action, you will have to add one more apply to each action based on output of get attachments action.

Inside this apply to each action you can use the Get attachment content action where you can get the needed information from "Get attachments" action output. Try collecting all the attachment names and attachment contents inside one array variable which will help you to send all related item attachments in single email.

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

[#3]

@ganeshsanap the array will be collecting all the attachments of the SP list or one by one?

[#4]

@ramyhabka 

It depends on your requirements. If you are going to send on email per each record, you will have to collect all attachments for specific list item in array inside apply to each then send an email using the array. Then clear the array value by setting it to empty array []. Then again collect attachments for next list item.

If you are going to send single email for all list items then you can collect attachments for all list items in single array.

---

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

[#5]

@ganeshsanap what I am trying to achieve is the following:

i have this list and the flow should read every record and will send the email to the email from SendTo; so for each row, it will send the data available and the attachment to the designated email.

How can i loop that? can you do it on your side quickly :) 

Appreciate your help,

Thanks a lot,

[#6 · Accepted solution]

it was solved, here are the details