web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to get unique atta...
Power Automate
Answered

How to get unique attachments for a list of mails

(0) ShareShare
ReportReport
Posted on by

Hi,

I'm trying to build a flow that sends an email to several addresses from an excel file. I've managed to use the variable union() to gather all vendor mails, but cannot do the same with attachments, which have the name vendorid.pdf

 

VENDOR IDSUPPLIER NAMEDESCRIPTIONVENDOR EMAIL
123ABC, LLCXYZvendorabc@domain.com
123ABC, LLCXXDvendorabc@domain.com
133CBD, LLCXVYvendorcbd@domain.com

 

On the same shared folder I have

123.pdf

123.pdf

133.pdf

 

This is how I filter all emails as one.

ElisaB_1-1666123919122.pngElisaB_2-1666123942710.png

 

Is there a way to send to each vendor, each corresponding pdf? Should I structure my table in a different way?

 

Thanks!

Categories:
I have the same question (0)
  • Verified answer
    v-liwei-msft Profile Picture
    Microsoft Employee on at

    Hi @ElisaB 

     

    Could you please tell me:

    Where are your pdf files saved?

    Do you want to find the corresponding PDF and send an email based on the deduplicated Excel data? 

    I'm assuming your PDF files are saved in OneDrive.

    I have made a test for your reference:

    1.

    vliweimsft_0-1666234840019.jpeg

    vliweimsft_1-1666234851015.png

    2.

    vliweimsft_0-1666235396063.png

    3.

     

    vliweimsft_6-1666235240283.jpeg

     

    4.

    vliweimsft_4-1666234886826.png

    5.

    vliweimsft_7-1666235262667.png

     

     

    Best Regards,

    Levi

     

     

     

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard