Introduction
In my previous article, we discussed how to collect information from external users and then add this information to SharePoint. This is an extension of the same article. Here, we will discuss how we can collect the documents from the emails received from external users and then attach them to an already existing record in SharePoint.
Let us consider the same business use case that we discussed previously, i.e., Collection of personal information from the potential candidate to be considered for an initial round of interview.
The Approach
- In the previous article, we used MS Form to collect the personal information and to push the collected information into a SharePoint list through MS Flow.
- The collection of the CVs of candidates is the most important step of this whole recruitment process. MS Form currently offers a limited functionality as it is not possible to upload the documents such as candidate's CV in MS Forms.
- The only way to collect CVs from candidates is through email. So, we will explore how we can collect the CVs through email and then associate this CV to the corresponding record of the candidate. We will achieve this objective by creating one more Flow.
Let us begin with notifying the candidate
- As a first step, we will extend the flow that we created in the previous article and will add an additional step to send an email notification to the candidate with the message that his/her form was accepted.
- The message should contain the clear instructions that the candidate should reply to the email received by them and send the CV along with this E-Mail. (Refer to the image below).
Now, let's expand the Send an Email action and then go through it.

In the image above, please observe the highlighted sections.
- The Email ID mentioned in the To field is the Email ID provided by the candidates while submitting the personal information through MS Form.
- The ID is the dynamic content which is picked from the newly created sharepoint list item. Please note that this is a very important link between the candidate and the information stored in the SharePoint.
- Please note the highlighted text in the body of the email which reads "********** Important Please do not change the subject of this email ****** ". This message is to ensure that a candidate does not change the subject of the email as this subject will be used in the upcoming steps below.
Now, save this Flow and then let us re-iterate the steps we have discussed so far.
- HR Recruiters sends a MS Form to the potential candidates and asks them to submit the personal information.
- The candidates submit the personal information using the MS form, but they cannot submit the CV due to the limitation of MS Form.
- This information flows into the Sharepoint list through the MS Flow and an email is sent back to the candidate in a specific format i.e.

- It is important to note that the ID in the subject line is the itemID of the newly created record in the sharepoint list based on the information submitted by candidates through the MS Form.
- Let us now create a MS flow which gets triggered when an email is received by HR recruiter and extracts the attachment(s) and then pushes it to the corresponding list item in the sharepoint.









Join the conversation! Your thoughts help the community grow.