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

Community site session details

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

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
    on at
    Re: How to get unique attachments for a list of mails

    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard