What If Every Job Posting Came Back With a Ranked Shortlist? HR Automation With a Copilot Studio Agent
Build an HR automation agent in Copilot Studio that reads a job posting from email, ranks your candidates in a Word report, replies, and books the meeting.
AI AGENTSMICROSOFT COPILOT STUDIOHR AUTOMATION
12/13/20256 min read
How HR Automation With Copilot Studio Works
Hiring managers send the same kind of email all the time: here is a job posting, do we have anyone who fits? Someone then reads the posting, digs through resumes, writes up a comparison, replies, and finds a time to talk. It is useful work, but it follows the same steps every time.
This post shows how to hand those steps to an autonomous agent built in Microsoft Copilot Studio. When a job posting arrives by email, the agent reviews it, compares it against a folder of candidate resumes in SharePoint, writes a ranked report in Word, replies to the sender with the report attached, and books a 30-minute meeting to talk it over. Nobody has to open the email first.
There is no code involved, and the whole build fits in about ten minutes of video.
Watch the Full Walkthrough First
The video shows the agent running end to end, from the incoming email to the finished Word report and meeting invite, and then walks through every setting used to build it. Seeing the result first makes each build step easier to follow.
What the Agent Delivers
In the demo, a hiring manager emails a colleague a link to an open Principal Product Manager role and asks whether anyone on the bench fits. A few minutes later, a reply comes back from the colleague's agent with three things:
A short email naming the strongest candidate and a strong second choice
A Word document with the full analysis, attached
A meeting invite to discuss the recommendation
The Word document opens with an executive summary of who the agent recommends and why. Each candidate then gets a paragraph and bullets covering technical ability, leadership, and culture fit, plus an overall rating that runs from excellent down to low. Every candidate also has a link to their full resume, so the hiring manager can check the agent's reasoning against the source.
Getting that result takes a few things set up ahead of time.
What You Need Before You Start
Access to Microsoft Copilot Studio
A Microsoft 365 Copilot license, which the Microsoft MCP tools used here require
A SharePoint folder that holds the resumes you want the agent to compare. In the video it is a folder called Hiring Bench on a Human Resources site
The Microsoft MCP tools are still in preview, so names and options can shift. With those in place, the build comes down to five steps.
How to Build the Agent in Copilot Studio
Name and describe the agent
The demo agent is called the Matchmaker and has its own icon
Add a short description, such as "This is an autonomous agent that receives emails related to job postings, matches the candidates to the posting, and ranks them." The description helps the people you share the agent with. It does not change how the agent behaves
Choose the model
The video uses GPT-5. The model list in Copilot Studio changes often and includes reasoning options and Claude models, so pick a current model that handles multi-step work well
Add the email trigger
The trigger is what makes the agent autonomous. Add the When a new email arrives (V3) trigger from the Office 365 Outlook connector
It is not in the featured list. Switch to All, where there are hundreds of triggers, and search for it by name
Connect the resume folder as knowledge
Add knowledge, choose SharePoint, and browse to the resume folder
Give the folder a description, such as "This folder contains the resumes of all candidates that are to be hired." That one line tells the agent what it is looking at
The agent works with your sign-in, so it can only reach files your account can already open
Add three MCP tools
Add a tool, filter by Model Context Protocol, and add the mail, Word, and meeting tools. In the video they appear as Outlook Mail MCP, Word MCP, and Meeting Management MCP. Microsoft has since grouped these tools under the Work IQ name, so look for Work IQ Mail, Work IQ Word, and Work IQ Calendar
Sign in to each one and check for the green connected mark
MCP, short for Model Context Protocol, is a standard way to give an agent a whole set of related actions through one connection. The mail tool alone can draft a message, add an attachment, reply, and send. Here the agent uses the Word tool to write the report, the mail tool to reply with the report attached, and the meeting tool to book the time.
Nothing else on the agent needs to change. Topics, suggested prompts, and multi-agent settings all stay at their defaults, which leaves the instructions to do the real work.
The Agent Instructions
The instructions tell the agent what to do, in order, every time an email arrives. Paste them into the Instructions box on the agent's Overview page. If your tools show the newer Work IQ names, change the tool names in the text to match.
Copy everything between START COPYING and STOP COPYING.
--- START COPYING
When a new email arrives, determine if it is related to hiring or job postings. If it is, see if there is a job description link in the email and review the job description in the link.
Next compare the job description to the candidates that are on the hiring bench in the Sharepoint site of your knowledges.
Then using the WordMCP Tool create a detailed document that compares each resume in the folder to the job description and compares them for technical ability, leadership, culture fit, and other factors the job requires and also provides an overall rating in terms of job fit for each candidate. Do not use a table but instead write a detailed paragraph along with bullets for each candidate. For each candidate provide a link to their full resume. At the top of a document create an executive summary highlighting who you recommend and why you recommend them.
Then using the OutlookMailMCP tool, create a professional email reply to the sender and let them know you looked at the job posting and are attaching a document with potential candidates. Make sure the email is formatted in HTML and send it to them as soon as you've created it.
Using the Meeting Management MCP Server tool find an opening between 9am-5pm PST in the next 7 days, without asking for permission create a meeting for 30 minutes and let them know you'll update the invite with a Teams meeting link after they've accepted it.
--- STOP COPYING
A few lines in there are doing more than they seem to, and they came straight out of testing.
Tips From Testing
Tell the agent to send right away. Without "send it to them as soon as you've created it," the agent sometimes stopped after drafting the email and never sent it
Tell it not to ask for permission. An autonomous agent has nobody to ask, so "without asking for permission" keeps the meeting step from stalling
Check the Teams link. When we built this, the meeting tool created the invite but did not add a Teams meeting link, which is why the instructions promise to add one after the invite is accepted. Test whether your version adds it now
Expect a run for every email. The trigger fires on each new message, and the first instruction filters out anything unrelated to hiring, but every run still uses Copilot Studio capacity. Our free AI Agent Cost Calculator helps you estimate what that adds up to
Test with sample resumes and a few test emails before you point it at real hiring requests
Testing covers whether the agent works. The bigger question with hiring is how much weight its ranking should carry.
Keep a Person in the Hiring Decision
The agent prepares the analysis. A person should still make the call. A few practical points before you use something like this with real candidates:
Treat the ranking as a starting point and read the resumes behind it, especially for candidates rated lower
AI used in hiring is regulated in some places. New York City requires a bias audit and notice to candidates for automated hiring tools, and the EU AI Act treats AI used in recruitment as high-risk
Resumes are personal data. Keep access to the folder limited and check with your HR and legal teams before using real candidate information
This is practical guidance, not legal advice, but it is worth sorting out before the agent goes live.
Where to Take It Next
Answering "do we have anyone for this role?" is a small task, but it comes up again and again. With this agent, it becomes an email you read instead of an afternoon of searching and writing, and the same pattern of trigger, knowledge, MCP tools, and clear instructions works for plenty of other requests that land in an inbox. Which one would you hand off first?
Have a question or an idea for a future video? Leave a comment on the full video walkthrough on the Collaboration Simplified YouTube channel.
Contact Us
Questions? Reach out anytime.
Phone
© 2020–Present Collaboration Simplified. All rights reserved.
Collaboration Simplified® is a registered trademark of Shervin Shaffie.