Attaching All files in a folder to an email based on a forms response

[GeigerCDill]

Hello,

I have no real flow to show because i cannot get anything to function the way I need and I am very lost.

I am using a Microsoft Form as a trigger. The user of the form is selecting a person off a list on the form. When they submit the form there are a bunch of steps in between such as approvals but what I cannot figure out is in the end part of the Flow. I need it to take all the contents of a specific folder (based on the person they selected on the form) that is stored on a sharepoint and attach them to an email. The folder is a subfolder so it has to be the ability to filter by path (folder name would be the same as the form selection). The files also will have different file names every time (although we could add something into the file names if that helps.)

Is there anyone who can help me get the files from this folder dependent on a form selection and then attach them to an email?

[fchopo]

Hello,

You can get all the files in a SharePoint Folder like this: 

Where test/samplefiles/ should be the folder your user selected in forms.

The problem is with the attach section in outlook, since the number of attachments is unknown and could be different everytime. One possible solution should be to iterate through all the files, get a link to them, store those links in a string variable, and the put this string variable in the email.

Hope it helps!

[abm]

Hi @GeigerCDill 

Please follow my blog  about how to attach all files in an email.

https://mydevexperience.wordpress.com/2019/09/08/microsoft-flow-onedrive-send-all-files-as-attachmen...

There are different ways you can retrieve the files from SharePoint. Have a look at Flow SharePoint actions such as List folder, Get File Properties etc. 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[GeigerCDill]

Hello,

@abm  The problem is I am a super beginner and I do not really know what the functions of List Folder do or how sharepoint lists work in general.

I started to sort of use what you have there but how do I get the content of the files to put in the append to array variable?

This is where I am at

[GeigerCDill]

@fchopo  Unfortuantely i cannot just provide links. The final documents are invoices going out to customers in which we would like to provide them attached to the emails.

[abm]

Hi @GeigerCDill 

You are in the right direction here except some minor changes. You need to read the folder of the files from SharePoint. Construct in a loop and get th file content into your array. This way you will have all the file contents. Finally you can use the array to attach the files.

If you need any further help please let me know.

Thanks

[abm]

Hi @GeigerCDill 

If you want a screenshare then happy to help you as well.

Thanks a lot

[GeigerCDill]

@abm what is the method of screen sharing? As it is my work computer I may need to get prior approval. 

[abm · Accepted solution]

Hi @GeigerCDill 

Thank you for the discussion earlier.

I have built a flow solution for you. This solution explains reading a one particular directory from SharePoint, Get all the file contents and send an email as attachment.

Please follow below steps.

Above  add the false as expression

Above expression is as follows:

body('Get_file_content_using_path').$content

Finally add the send email outside the loop.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[GeigerCDill]

This solution worked perfectly for a single folder and then beyond that we discussed privately how you can use dynamic content within the paths to help it pick up paths depending on a selection on a form. As well as if you have spaces in your files path, you may need to insert that path into a URI component.