Forum Discussion
Send email with flow for each row from SharePoint List with the attachment of each record
- Oct 08, 2023
it was solved, here are the details
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.
ganeshsanap the array will be collecting all the attachments of the SP list or one by one?
- ganeshsanapOct 04, 2023MVP
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.
- ramyhabkaOct 04, 2023Copper Contributor
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,