Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Unanswered

Power Automation

(0) ShareShare
ReportReport
Posted on by 8

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?

  • vinishzach Profile Picture
    8 on at
    Re: Power Automation

    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.

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at
    Re: Power Automation

    @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

  • vinishzach Profile Picture
    8 on at
    Re: Power Automation

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

     

    please help

  • vinishzach Profile Picture
    8 on at
    Re: Power Automation

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

    1.1100MO  Test1@mymail.co.ukhttps://eeees/MailMerge/Shared%20Documents/datafolder/1.pdf1.pdf
    1.2100ALEXANDER  Test2@mymail.co.ukhttps://eees/MailMerge/Shared%20Documents/datafolder/2.pdf2.pdf
    1.3100JASH  Test3@mymail.co.ukhttps://eeailMerge/Shared%20Documents/datafolder/3.pdf3.pdf
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at
    Re: Power Automation

    @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.

     

    annajhaveri_0-1617342595089.png

     

    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. 

  • vinishzach Profile Picture
    8 on at
    Re: Power Automation

    @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

  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at
    Re: Power Automation

    @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? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow