Compose email from sharepoint list items and attachments

[Price83]

Hi All,

I'm seeking some help as i'm now going bald from my flow failing.

I currently have a flow for when someone submits an MS form the data goes into a sharepoint list. What i then want is when the file uploaded from the form is saved into the correct sharepoint folder to compose an email including some items from the list and the attachment from another folder.

I cannot get this to work and any help would be greatly appreciated.

Paul

[v-bacao-msft]

Hi @Price83 ,

Could you provide more explanations about your needs so that we can provide you with a suitable solution?

For handling attachments in MS Form submission, you can refer to this great article:

working-with-files-on-ms-forms-in-ms-power-automate

Best Regards,

[PURNA429]

Hi @Price83 

Basically you need to use "Get File Content" option in your flow. Which expects the path of the file ( in your case attachment stored in a folder of a SharePoint document library ).

Here is a post from my blog on how to read the file from a SharePoint folder in flow. In this example, i am grabbing an image and sending it as a attachment in Send Mail activity.

Power Automate Get File Content Sample 

If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .

Thanks

Purna

Blog 

[Price83]

@PURNA429  ok so i can get it to add the attachment but i need it to also link the list details for the email body but it keeps failing asking about an array.

I know i am missing something for the body text but i get see what.

for some reason it says i cant upload images to the forum

[Price83]

[Price83]

ok i now have it working but it is sending about 13 emails rather than 1, is there a way to stop this?

[PURNA429]

Hi @Price83 ,

Use "Compose" Action in your apply to each loop and append the email addresses and store it in to a array /string variable.

Then use this array/string variable outside of your apply to each loop to send an email.

Here is a sample post from my blog in which i used "Compose" action inside apply to each to concatenate (append) all the customer email addresses in to a variable and sending email out side of apply to each using this variable in to "To" address.

If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .

Regards

Purna

Blog

[Price83]

hi @PURNA429 

the sample link doesnt work 😞

[PURNA429]

I have updated the link. In case if it has still issue, copy paste below url.

https://moresharepoints.blogspot.com/2020/04/how-to-read-sharepoint-person-or-group.html

[Price83]

Sorry to ask again

I now have the flow working to get data compose email and add attachment however it sends an email for each entry in the list rather than just the new one created each time. so it sends 15-30 emails rather than just 1 for each new entry

is this possible?

[PURNA429]

Hi @Price83 ,

It is possible. One option is, add one more column to your list of type boolean with name "EmailSent" and keep the default value as "No". Once you send the email, update this column value to "Yes" using Update Item action.

In your GetItems query, add a filter like "EmailSent eq 'No'".  That way it only brings the items for which the email is not sent.

If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .

Thanks,

Purna

Blog