Power Automate + AI Workflow

Overview

Work items in Azure DevOps were being created manually by copying details from Outlook task emails. The process was repetitive and caused delays when the team was busy. This workflow automates the handoff.

What I Built

• A Power Automate flow triggered when emails are flagged in Outlook
• An AI step using Azure OpenAI to extract the project name, task description, and priority from unstructured email text
• Automatic work item creation in Azure DevOps with the extracted fields pre-populated
• A fallback path for cases where the AI extraction confidence is low, routing to a human review step

Notes

The AI extraction step handles the messiest part — email subjects and bodies are written by humans and don't follow a consistent format. The prompt was tuned over several iterations by testing against a sample of real emails to get reliable field extraction.