Unanswered

Power Automation

(0) Share

Report

Posted on by vinishzach

How can i configure, send different attachments to each of the entries in the excel. Like adding the complete file name and path and linking it to Power automate?

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@vinishzach do you have a excel file which contains the email, file name and path? And you want a flow to go through all rows of excel, take the file from the path and send that file as attachment to email? Are the files stored in SharePoint?

Was this reply helpful? Yes No
vinishzach 8 on at

Like (0)

Report

@annajhaveri I've SharePoint having excel and pdf file. Each row contains all the details about it. but not sending the attachment. can you share some doc for PA attachments for emails? (My purpose is each person need to send a water bill )

Emails and all other field working well only the PDF attachments not showing on their email.

Many thanks
Vineesh

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@vinishzach in order to send file as attachment first you need to get the file content and then use that file content in attachments content parameter of Send Email action, as shown in below screenshot.

Here, first i am using "Get file content using path" action to get file content, you can use a dynamic value for File Path, if you need to. Then in send email attachment content parameter, select File Content from Dynamic Content of Get File action.

Was this reply helpful? Yes No

vinishzach

8 on at

Like (0)

Report

this is my excel file sample user not getting pdf file ,each user must have there own bills.

1.1	100	MO	Test1@mymail.co.uk	https://eeees/MailMerge/Shared%20Documents/datafolder/1.pdf	1.pdf
1.2	100	ALEXANDER	Test2@mymail.co.uk	https://eees/MailMerge/Shared%20Documents/datafolder/2.pdf	2.pdf
1.3	100	JASH	Test3@mymail.co.uk	https://eeailMerge/Shared%20Documents/datafolder/3.pdf	3.pdf

Was this reply helpful? Yes No

vinishzach 8 on at

Like (0)

Report

it is attaching only one file .my requirement is each emails need to get different attachment .This works only with one attachment .

please help

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@vinishzach you can create array of files reference post https://flow.microsoft.com/en-us/blog/multiple-attachments-single-email/, let me if you face any issues in implementing this

Was this reply helpful? Yes No
vinishzach 8 on at

Like (0)

Report

This is for multiple attachment in one email.

Example :
i have 2000 email address each of them need to get only there water bills.
All the dat is stored in share drive and excel list too.

Was this reply helpful? Yes No