Hi Damo, brilliant!! This is exactly the demo ↑was looking for - sending customised attachments ... I assumed it could be done, just didn't know how. Thanks again, I am just discovering the versatility of power automate and can say its a game changer.
Thank you so much for the help Sir, i did make a tweak a bit as i did not need the month etc as i am using this for sending out bulk certificates (Working in L&D) however, the flow kept running and sent 2 times until i manually turned it off lol any advice? I would really appreciate your help! even if we can have a call somehow? Forget coffee, dinner is on me lol
Hi, i am looking to customised send email with one unique attachment and 2-3 general attachments. Is there a flow to send bulk customised email with one unique attachment and 2 or 3 general attachments for a selected row in excel?
Great video. Can you do a demo on how to send multiple invoices? Or has multiple filter (such as more than 10k and older than 30 or 60 days)? Thank you so much.
That's a potentially interesting use case. Would the value be in column metadata? Or would you use AI to extract the value? Would these invoices go to a certain team based on these criteria?
@@DamoBird365 Thank you for taking the time to reply to me. I am so new to this whole Power Automate thing so I am not even sure I am asking the right questions. The value will be in a column called Amount Due. I don't think I will be using AI to extract the value since I don't know what this is at all. For each company, I have a contact person. For example, I will send all MS invoices to Bill Gates. lol
Hello, I have similar requirement, just wanted to know, instead of excel as a source, how to connect to oracle database and perform similar mail merge in cloud flow? Also, is oracle database connector still available in power automate cloud flow? Your response will be highly appreciated
@@DamoBird365 Hello, I have tried your approach for 3 files, mails are sent,but I am getting error for 4 th iteration, but files present are only 3 and getting at get file content using path step
Brilliant! I'm looking for a similar solution to send multiple emails in bulk based on Excel table data with multiple file attachments per email. I already have my flow created to bulk email but I can't figure out how to automatically attach all files that belong to that email. Each attachment starts with the Customer Reference number and there are 2 to 10 files that need to be attached per email. All files have different suffixes though, only commonality is the Customer Ref #. Any suggestions?
Content is great Damien, keep it going..subscribed...I have an excel sheet with customer data (account no etc)..do you have any videos on how to group by account number and send a copy of the excel to that specific customer with their specific rows? thank you
Thanks Eamonn, I’ve done invoicing from a SharePoint list, it might inspire you. ruclips.net/video/lskqQNDegXc/видео.html. Alternatively, you could drop me more detail to ideas@damobird365.com and I might be able to do a video on your concept. Thanks
Hi there, it's a dynamic file path, based on a root folder, the dynamic part from excel and a date/time using formatdatetime. You would need to tailor this to suit your requirements.
Interesting. Would this be at the end of the day? It’s possible to get emails and filter on subject, like a reference number and then get attachments and merge them, saving them to SharePoint or emailing. Csv is easy as it’s text, but an excel file could be created too.
@@DamoBird365It's possible that it could be either at the end of the day or even intermittently, maybe a condition can be used so that the automation doesn't try to merge less than 2 attachments. I think that even an excel file would be great. Just wondering how to keep the one file's headers and discard the rest. Is it possible that you could look into this solution? I think a lot of us could benefit from it. Thank you for your content.
@@DamoBird365 I have the same issue, it's been weeks and can't figure it out. the file extension is there. when i remove and "" it doesn't work. any support would be great
Hello my friend. Great video! I have a question, I work in a company that receive hundreds of invoices in PDF format to the mail. I download them and write something that it is required. I save them again in PDF format, and I send it back to the mail where they are processed by payments team. I usually download them and add a small text on them with Adobe Acrobat. Is it possible to automate that task on power automate?
Possibly. Not with the standard flow actions but maybe with something like encodian www.encodian.com/products/encodian-for-microsoft-power-automate/ add text watermark to pdf.
@@DamoBird365 I have a data file to send to school principals. I have an excel file with the names of the files, the names and emails of the principals, etc. I placed a column with the name of the file in the excel document. How do I connect them? I tried with Leila Gharani's video and it said it ran successfully but no emails were sent. HELP!
@@kellivelez8494 if you can send me a screenshot of your flow to ideas@damobird365.com and an explanation, I can take a look. You want to get rows and use the filename from your column to get the attachment contents and send an email.
I had the same problem and looking for alternative and found this video, previous attempt it worked half way, then it seemed it skipped the actions but was successful. I will copy this and if i modify the past time step, will it still work?
Wizard! hahaha I needed this for sending more than 200 emails with their unique attachment. Thanks as usual!
Hi Damo, brilliant!! This is exactly the demo ↑was looking for - sending customised attachments ... I assumed it could be done, just didn't know how. Thanks again, I am just discovering the versatility of power automate and can say its a game changer.
Great work
Thank you so much for the help Sir, i did make a tweak a bit as i did not need the month etc as i am using this for sending out bulk certificates (Working in L&D) however, the flow kept running and sent 2 times until i manually turned it off lol any advice? I would really appreciate your help! even if we can have a call somehow? Forget coffee, dinner is on me lol
Thank you! This solved a nasty problem for me.
Hi, i am looking to customised send email with one unique attachment and 2-3 general attachments.
Is there a flow to send bulk customised email with one unique attachment and 2 or 3 general attachments for a selected row in excel?
To achieve this you need to append the files to the array or create two arrays and use the union expression 👍
Great video. Can you do a demo on how to send multiple invoices? Or has multiple filter (such as more than 10k and older than 30 or 60 days)? Thank you so much.
That's a potentially interesting use case. Would the value be in column metadata? Or would you use AI to extract the value? Would these invoices go to a certain team based on these criteria?
@@DamoBird365 Thank you for taking the time to reply to me. I am so new to this whole Power Automate thing so I am not even sure I am asking the right questions. The value will be in a column called Amount Due. I don't think I will be using AI to extract the value since I don't know what this is at all. For each company, I have a contact person. For example, I will send all MS invoices to Bill Gates. lol
Hello, I have similar requirement, just wanted to know, instead of excel as a source, how to connect to oracle database and perform similar mail merge in cloud flow? Also, is oracle database connector still available in power automate cloud flow? Your response will be highly appreciated
It’s not something I’ve used but details are here learn.microsoft.com/en-us/connectors/oracle/
@@DamoBird365 Hello, I have tried your approach for 3 files, mails are sent,but I am getting error for 4 th iteration, but files present are only 3 and getting at get file content using path step
Brilliant! I'm looking for a similar solution to send multiple emails in bulk based on Excel table data with multiple file attachments per email. I already have my flow created to bulk email but I can't figure out how to automatically attach all files that belong to that email. Each attachment starts with the Customer Reference number and there are 2 to 10 files that need to be attached per email. All files have different suffixes though, only commonality is the Customer Ref #. Any suggestions?
Give me 30 minutes.... I am working on something just now and will drop the link here. Make sure you subscribe if you haven't already ;-)
Take a look here ruclips.net/video/9G9GNeknemg/видео.html
@@DamoBird365 thank you so much! I'll check this out! Already subscribed and excited to learn more from your channel!
Content is great Damien, keep it going..subscribed...I have an excel sheet with customer data (account no etc)..do you have any videos on how to group by account number and send a copy of the excel to that specific customer with their specific rows? thank you
Thanks Eamonn, I’ve done invoicing from a SharePoint list, it might inspire you. ruclips.net/video/lskqQNDegXc/видео.html. Alternatively, you could drop me more detail to ideas@damobird365.com and I might be able to do a video on your concept. Thanks
Thank you so much for helping with this much appreciated !🙂
Hi, thanks for your guidance. Could you please let me know how to add Filepath after "Select an output from the previous steps"?
Hi there, it's a dynamic file path, based on a root folder, the dynamic part from excel and a date/time using formatdatetime. You would need to tailor this to suit your requirements.
I didn't see you have a step to attach the attachment to the email :( but I figured it out.
Hello sir. Can we send 2 dynamic attachment using power automate? Please suggest. Each recipient will receive two customized pdf attached
Sure, take a look at the following guide flow.microsoft.com/en-us/blog/multiple-attachments-single-email/
@DamoBird365 can you make a solution whereby the user receives emails with a specific subject line and all the attachments of excel CSV are merged?
Interesting. Would this be at the end of the day? It’s possible to get emails and filter on subject, like a reference number and then get attachments and merge them, saving them to SharePoint or emailing. Csv is easy as it’s text, but an excel file could be created too.
@@DamoBird365It's possible that it could be either at the end of the day or even intermittently, maybe a condition can be used so that the automation doesn't try to merge less than 2 attachments. I think that even an excel file would be great. Just wondering how to keep the one file's headers and discard the rest. Is it possible that you could look into this solution? I think a lot of us could benefit from it. Thank you for your content.
Thank you Damo, But unfortunately the attachment arrives corrupt! Any hints why?
Have you included the file extension? Have you removed “” from surrounding the file content in the object?
@@DamoBird365 I have the same issue, it's been weeks and can't figure it out. the file extension is there. when i remove and "" it doesn't work.
any support would be great
Hello my friend. Great video! I have a question, I work in a company that receive hundreds of invoices in PDF format to the mail. I download them and write something that it is required. I save them again in PDF format, and I send it back to the mail where they are processed by payments team. I usually download them and add a small text on them with Adobe Acrobat. Is it possible to automate that task on power automate?
Possibly. Not with the standard flow actions but maybe with something like encodian www.encodian.com/products/encodian-for-microsoft-power-automate/ add text watermark to pdf.
How do i schedule this flow to run automatically
At the same time each day? It would be a recurrence trigger.
@@DamoBird365 yes at same time each day, but do we need to upload Excel and attachment files on onedrive before the scheduled time
@@SnehaLolge the files would need to be there, unless you generate the content at the time.
Do we have to save the pdf files with the name format prior?
You could create the files and then attach them? I do this in some of my other videos, for example ruclips.net/video/L67m8wgd4Ak/видео.html
This is my first time sending an email with this attachment and I won't do so on a monthly basis. How do I get it to go off without the get past time?
Hi there. As long as you can uniquely reference the file, you can send it automated. What’s your use case / scenario?
@@DamoBird365 I have a data file to send to school principals. I have an excel file with the names of the files, the names and emails of the principals, etc. I placed a column with the name of the file in the excel document. How do I connect them? I tried with Leila Gharani's video and it said it ran successfully but no emails were sent. HELP!
sorry, each file is a unique PDF and I matched the name of the file in my OneDrive folder to the file name in the excel document.
@@kellivelez8494 if you can send me a screenshot of your flow to ideas@damobird365.com and an explanation, I can take a look. You want to get rows and use the filename from your column to get the attachment contents and send an email.
I had the same problem and looking for alternative and found this video, previous attempt it worked half way, then it seemed it skipped the actions but was successful. I will copy this and if i modify the past time step, will it still work?
Why i cant search the FilePath ?
I don’t understand your question. You could try the Microsoft forum? powerusers.microsoft.com/
Thanks!