Dynamically Send Multiple Files as Email Attachment in Single Email using Power Automate

[@rickb.3666]

Thank you sooooooo much for doing this video! I used your logic plus added some more to do the following - Starting trigger - SQL When a new row is created - SQL Get Row V2 - Create New Folder in Sharepoint/ (name is my SQL OrderID I use for grouping) to get all files into that folder - SQL - Execute the query to get the rows - Apply to each - { "$content-type": "application/pdf", "$content": @{items('Apply_to_each')?['FileBlob']} } Then SharePoint - Create File - SharePoint Get File Content (so I could validate was working), After that you are in Apply to each, Added step outside of it - Sharepoint - Get folder metadata using path - Get Files Properties - Then the rest is your logic :) After much playing! It works and I coped the same logic for another task to send customers their proof of delivery when a file is added. :) Thanks again

[@sueamin2788]

Thank you! Perfect timing! Here is a request for a future video: Need a process to select specific files coming from a Portal PowerApps to a single SP library. Attach these files from the SP library related to a single Dataverse record to a single OUTLOOK email and send it to the pertinent users.

[@iamdhruvinshah]

Noted

[@sueamin2788]

@@iamdhruvinshah Thank you for the detailed explanation. However in my case, I have an Online Portal PowerApp form that has a Form ID assigned when a form is created. Files attached to this Form are saved in a SharePoint Document Library, where a Folder is created dynamically named as "FormID_GUID". (Example of Folder Name: ID-001021_C2D675C197D7EC11A81B001DD803484B). This Folder can have more than one attachment documents in it. I am working on creating a Power Automate FLOW where I would like to pull these documents and attach to a single email and send it to pertinent recipients automatically. Issues: There is no option to indicate Folder Name in "Get file content" step or "Get attachment content" step. My folder name is not a fixed value that I can hard code in the Library URL. How to point to the correct dynamic Folder name and Where in the Flow I do that step? Please provide any suggestion you may have. Thank you, SueA.

[@5uysal]

This has helped me a lot today after trying for days! Thank you so much!

[@annabanga7938]

You made my day thaaaanks!

[@sarnst1]

Nice one i looked at an older blog and the Dynamic content was not there. besides they didn't show the extra option in the attachements so my variable did not come up. Well done

[@ssend825]

Thank you so much for your videos, so clear and easy to follow!

[@zwolfnutzer41]

Very professional tutorial and well explained 👍👍 Many thanks for this great explanation! Would it be possible to update the download link in the video description. That would be awesome : D

[@ДмитрийСоколов-о5х]

Thank you! It was simple and clear!

[@tisarasthanarassthiwatt7964]

Thank you very much for your clip VDO.

[@ajambo2010]

Enjoyed the video, very helpful. I would like to attach only specific files from the folder and not all files. I am have tried using the 'Filter Query' in the 'Get Files (properties only)' action but cannot get it to work. Do you know how structure these filter queries?

[@richp2894]

Great video. Easy to follow. You make it look pretty easy! Have you ever run into the situation where the attachments get sent successfully, but the files can' be viewed or opened? I'm struggling to figure out why that happened. I only used a small bmp file and a small PDF file. Any thoughts? - THanks.

[@billybanana]

Brilliant, thank you.

[@ejtirador]

Thank you for this. Just wondering if your formula can also be used in "for selected row" then the folder is onedrive.

[@rajatpandey7295]

Hi @dhruvin What should we do if there are more than two attachment sections in the same form? In that case, how can we apply a rule in the workflow to receive emails from different attachment sections?

[@SiyamandRashid]

Thank you very much for the video, I did exactly the same as your video but I'm receiving emails without attachments! why is that please?

[@ivanimmi]

Thank you for the video. How do I make sure that if a user has created a new file in the location, that power automate only sends a new file as an attachment not all fies in the folder?

[@TheUsamawahabkhan]

Brilliant!

[@Aarti-zb8dp]

Thanks u are brilliant 😅

[@sundrapillay6668]

Thanks Dhruvin

[@iamdhruvinshah]

Keep watching!

[@whalesbaba12]

Hi, thank you for this video. I have a question. After following all the steps involved here, When I attach one file then the recipeint recieve one email, but when i attach two files, the reciepient recieve the email twice and so on for multiple files. How can this be resolved please? Thank you

[@luisalejandro3036]

Hi Wale: Could you solve that? Any resource to review? Thanks in advance.

[@luisalejandro3036]

Solved! In my particular case, I've used the following rule to set a trigger condition @startswith(triggerOutputs()?['body/{Name}'], 'InitialNamefile.file') You can refer to these exceptional videos and blogs: kzbin.info/www/bejne/ppXQgJihpZJnqcU tomriha.com/run-power-automate-flow-only-if-email-contains-a-specific-attachment/

[@Rakesh_RV]

@@luisalejandro3036 dont use Email action in apply to each. Use next step

[@kuroilotus]

Nice video!! Could you use OneDrive instead of SharePoint and a "Parse JSON" to collect the name and the base64 and then intialise the array variable before the loop. After that in the loop you would have the create file and the append to array variable with the body of this Parse JSON action to send it by email as attachment. Is it possible or I'm out of it? Thanks.

[@paullee4442]

In the beginning of the video you linked the flow to a sharepoint list but didn't explain what the list has in it? Did you just use that to store the array or was there existing content in there?

[@dnasol5370]

Do you have video for multiple files from form to outlook using power automate?

[@erikabrizuela7567]

Hi! i have 3 documents (pdf, macro excel, excel sheet) it will work for this format ?

[@TheSamyakjain]

hi Dhruvin, can you please tell how to do the same procedure using onedrive

[@edugazzebo506]

Is there a way to filter only Multiple selected on a large document library?

[@lionthegame8174]

Whit using OneDrive?

[@ВладимирВ-и8л]

Thank You for this instruction. Files comes, but empty. What I do wrong?

[@sadsandesh]

Same happening for me too.

[@ВладимирВ-и8л]

@@sadsandesh In my case was an error - I added " to the content field when sending an emai

[@nasreenmerchant7823]

How do I run this flow on a schedule? For example, I want this flow to run every 24 hr and send the file that name contains yesterday's date (The file's name end with yesterday's date). Thank you

[@amrshoeeb2995]

it shows Succeeded, the email comes to the inbox but no attachment

[@samyakjain679]

I tested this flow but this this is taking so much time and I’m still waiting to get the output, can you please suggest solutions

[@Poojayoudream]

I have this folder PDF folder in mergedocs document library how do I use this in uricomponent as it is showing me Jason error that's why I want to pass it in uricomponent

[@harshjeetkothekar4169]

I was able to do recreate this for onedrive just replace SharePoint option with onedrive

[@mardithpascua8112]

I tried the same approach but it doesn't work for SMTP connector.

[@Perfectnst]

Hi can you help me sending 2 custom attachments in a single email. Both these attachments are stored in folder and excel sheet has the names of the files in each row. I want to read the name in excel find the attachment in folder and send it via outlook

[@manikantar5848]

I am trying to get each attachment from the apply to each loop and send email. However I see in 2 nd loop item it picks up the old items along with and sends. The list I am using is from SharePoint. Could you please help me. Looking forward to hear back

[@iamdhruvinshah]

May be you are adding some diff way! That's why two loops are there!

[@incomparable642]

Same thing Loop is going through old and new files and sending them in 1 email

[@mohamedalawihee8191]

Why I recieve many Emails for every excel files? Could you please help me?

[@sosinamezemir2612]

I couldn't find the code of this flow

[@piyushborkar1988]

HOW TO SEND EMAIL TO USER WHO CREATE ITEMS IN SHAREPOINT WITH ATTACHMENTS. THE PERSON CREATE ITEM SHOULD RECEIVE EMAIL FROM YOUR EMAIL ID.....