web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Dynamically add pdf fi...

Power Automate

Answered

Dynamically add pdf file from OneDrive, then attach the email

(0) Share

Report

Report

Posted on by Wenom

6

Hello,

I want to add to a workflow that we have developed before. The workflow checks the birth dates of people from the excel table and sends mail to the relevant people. This workflow works smoothly. We want to make an addition to the same workflow. We want to do;

There are pdf files of people's names in a folder. We want to add the pdf file belonging to that user to this e-mail that we celebrate their birthdays. For example. We want to add the abc.pdf file to the attachment of the abc user's birthday mail. How can I add pdf file to related email?

Thank you

Categories:

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Srini007 3,490 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Wenom

Check below post for your reference

https://powerusers.microsoft.com/t5/Building-Flows/Find-File-in-OneDrive-Folder-then-attach-to-email/td-p/733901

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Wenom ,
Do you want to see the date of birth of a person from an excel sheet and send an email to the relevant person?
Then add the abc.pdf file to the attachment of the abc user's birthday email?
Since I don't have a screenshot of your process, I'm assuming a running environment.
In my scenario:

concat(split(formatDateTime(item()?['birthdayDate'],'yyyy-MM-dd'),'-')[1],'-',split(formatDateTime(item()?['birthdayDate'],'yyyy-MM-dd'),'-')[2])

concat(split(formatDateTime(utcNow(),'yyyy-MM-dd'),'-')[1],'-',split(formatDateTime(utcNow(),'yyyy-MM-dd'),'-')[2])

items('Apply_to_each_2')['Name']

This is my excel table:

Best Regards,
Sunshine Gu

Join the conversation