Loading video player...
Tired of the endless pile of resumes? Manually screening candidates is time-consuming, subjective, and prone to human error. In this comprehensive tutorial, I'm building what I once thought was impossible: a fully automated, intelligent Resume Scanner that acts as your first-round interview panel. This isn't just a simple form-to-email automation. We're building a sophisticated, cloud-native application that leverages cutting-edge AI to read, understand, and evaluate candidates against your exact criteria. Watch as I transform a simple Microsoft Form into a powerful, decision-support system that can save your HR team dozens of hours per hiring cycle. đ§ In This In-Depth Tutorial, You Will Build: A complete, end-to-end recruitment automation pipeline: Candidate Interface: A professional Microsoft Form for resume submissions. Orchestration Engine: A robust Power Automate cloud flow that coordinates the entire process. AI-Powered Intelligence Layer: Azure services that handle document parsing and cognitive analysis. Centralized Data Hub: A SharePoint List that acts as a dynamic candidate database and reporting dashboard. ⨠Detailed Features & Technical Implementation: 1. Smart Document Processing with Azure AI Document Intelligence Go beyond basic text extraction. We'll use the pre-built "Read" model to accurately parse complex PDF layouts, fonts, and structures. Implement robust file handling in Power Automate to securely transfer the PDF from Microsoft Forms to the Azure AI service. Learn how to work with the Document Intelligence API's asynchronous pattern, implementing a polling mechanism with a "Do Until" loop to handle long-running processing jobs reliably. 2. Custom AI Scoring with Azure OpenAI Service Deploy and consume your own GPT-4 model within the secure confines of your Azure tenant. Master the art of prompt engineering to create a precise "AI HR Assistant." Our custom prompt will: Instruct the AI to evaluate only the specific skills we define (e.g., Azure, SharePoint, Power Apps). Enforce a strict scoring scale (0-10) for each skill. Command the AI to return a structured JSON object for easy parsing, not free text. Generate a concise, human-readable summary of the candidate's overall suitability. Include guardrails like "if a skill is not found, return a score of 0." 3. Professional-Grade Power Automate Development Configuration-Driven Workflow: Learn professional development practices by storing all sensitive endpoints and API keys in a SharePoint "Configuration" List. This makes your solution secure, maintainable, and easy to update. Advanced Data Parsing: We'll use multiple "Parse JSON" actions to navigate complex API responses from both Azure AI and the OpenAI service, cleanly extracting the data we need. Dynamic Variable Handling: Implement sophisticated string manipulation to correctly split file URLs and construct the necessary API calls. Data Enrichment & Storage: We won't just store the scores. The flow will: Calculate an average score automatically. Save the detailed skill breakdown. Store the AI-generated summary. Attach the original PDF resume to the SharePoint list item for easy access. 4. Enterprise-Ready SharePoint Dashboard Create a SharePoint List that becomes your candidate leaderboard. Instantly sort and filter candidates by their average score to identify top talent in seconds. Use the built-in views and reporting features to track recruitment pipeline metrics. đ ď¸ Core Technologies Used: Microsoft Power Platform: Power Automate: For workflow orchestration and business logic. Microsoft Forms: For the candidate submission portal. SharePoint: For data storage, configuration, and the reporting dashboard. Microsoft Azure: Azure AI Document Intelligence: For advanced PDF text extraction. Azure OpenAI Service (GPT-4): For cognitive skill assessment and summarization. Azure App Service / AI Foundry: For deploying and managing the custom AI model. đ End Result: By the end of this video, you will have a fully functional system that: Automates the initial resume screening process. Provides Data-Driven Insights with consistent, unbiased scoring across all applicants. Dramatically Accelerates your time-to-hire by instantly ranking candidates. Saves Countless Hours for your recruitment and hiring manager teams. Serves as a foundation for even more advanced automations (e.g., auto-rejecting low-scoring candidates, automatically scheduling interviews with top performers). 00:08 Introduction to AI resume scanner with live demo and project goals 00:53 Build Microsoft Forms interface and Power Automate workflow trigger 03:26 Configure JSON parsing and PDF processing with variable setup 58:15 Integrate chat service and build SharePoint database with attachments 01:22:31 Test system with multiple resumes and demonstrate final ranked results 01:33:42 Project recap highlighting business value and automation benefits