web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : k1u+SScbsaD84tpiX+wBIM
Power Platform Community / Forums / Power Automate - Building Flows / Sending unique attachm...
Power Automate - Building Flows
Unanswered

Sending unique attachments from SharePoint based on Excel sheet

Like (0) ShareShare
ReportReport
Posted on 1 Sep 2022 18:30:35 by ssura123 4

Hi everyone, looking for some guidance for this flow I am trying to create. 

 

I have an excel sheet with name, email and file name. 

 

ssura123_1-1662056772006.png

 

 

The flow I created below sends the emails but for the second row, it sends both attachments instead of only "k - 0829.pdf"

Is there are way to only send the file that appears in the row for each email address? Thank you for the help!

 

ssura123_2-1662056905857.png

 

ssura123_3-1662056936085.png

 

ssura123_4-1662056954107.png

 

 

 

 

 

 

 

I have the same question (0)
  • ssura123 Profile Picture
    ssura123 4 on 02 Sep 2022 at 15:53:18
    Re: Sending unique attachments from SharePoint based on Excel sheet

    Thanks @DamoBird365 , that makes a lot of sense. However when I changed it to set variable instead of append, the flow just kept running without sending an email. Do you know why this would happen? BTW nice youtube channel, very informative as well! Thanks for your help!

  • DamoBird365 Profile Picture
    DamoBird365 8,942 Microsoft Employee on 01 Sep 2022 at 19:42:59
    Re: Sending unique attachments from SharePoint based on Excel sheet

    Hi @ssura123 

     

    No problems.  Here is a screenshot of all 3: 

     

    DamoBird365_0-1662061185774.png

    By update I mean set variable - i.e. the middle one.

     

    In terms of functionality, set will overwrite the existing value(s).  Append will add to the existing.

     

    If I have a variable set to A and I set it to B, the value will be B.  If I then append C, the value will be BC.

     

    I hope that makese sense and good luck with your Power Automate journey!


    Cheers
    Damien

    Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts. Thanks

  • ssura123 Profile Picture
    ssura123 4 on 01 Sep 2022 at 19:15:54
    Re: Sending unique attachments from SharePoint based on Excel sheet

    Sorry for my ignorance, still new to this. What is the difference between update and append? Is there a specific operation I should choose? 

  • DamoBird365 Profile Picture
    DamoBird365 8,942 Microsoft Employee on 01 Sep 2022 at 18:52:32
    Re: Sending unique attachments from SharePoint based on Excel sheet

    Hi @ssura123,

     

    rather than append to array, update the array/variable.

     

    Damien

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

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans