Automate Outlook and Teams Workflow

1. What the automation must do The automation must watch the shared Outlook inbox from 12:00 AM to 12:00 PM EST and look for emails that contain specific instruction keywords. If any keyword is found in the subject OR body, the automation must immediately send a message to a Microsoft Teams channel. That’s the entire purpose. 2. What emails look like Emails come from ~75 clients Subject lines vary Body text contains instructions Each email includes one Excel attachment (not used for automation) 3. Keywords that must trigger an alert These words below are the exact phrases must trigger the workflow: Change CU Size Update Create Redeem Update CU Size Add Create Redeem Delete CU Size Suspense Effective immediately Effective today If ANY of these appear in the subject OR body → send Teams alert 4. What the Teams alert must include The Teams message must show: Sender Subject Timestamp Keyword(s) detected Link to the email 5. Deadline The goal is to detect all critical instructions before 11:45 AM EST. SIMPLE FLOWCHART Code Email arrives in shared Outlook inbox │ ▼ Extract subject + body text │ ▼ Does subject OR body contain ANY keyword? │ ┌───────┴────────┐ │ │ YES NO │ │ ▼ ▼ Identify which keyword Ignore email │ ▼ Send Teams alert with: - Sender - Subject - Timestamp - Keyword found - Link to email Step 1 — Trigger Use: When a new email arrives (V3) Select the shared inbox. Step 2 — Get email details Use: Get email (V3) Extract: Subject Body Step 3 — Check for keywords Add a Condition block: Check if subject OR body contains ANY of these phrases: “Change CU Size” “Update Create Redeem” “Update CU Size” “Add Create Redeem” “Delete CU Size” “Suspense” “Effective immediately” “Effective today” (Make this case‑insensitive.) Step 4 — If YES → Send Teams alert Use: Post message in a chat or channel Message must include: Sender Subject Timestamp Keyword detected Link to email Step 5 — If NO → Do nothing Notes for Developers do not need to open or read the Excel attachment. You do not filter by sender — scan all emails. You do not use AI or machine learning — this is simple keyword matching. You must scan both subject and body. Alerts must be immediate, not scheduled. Keywords must be exact matches, except urgency words like “change” or “update,” which can be partial matches. The workflow must run only between 12:00 AM and 12:00 PM EST. I need the map so I can recreate it at work using automate. Please advice if this clear, how long does it take to build this and the exact cost