# Interview status emails (Power Automate)

> A working replica of a Power Automate flow that sends one email per interview request status, staged on a fictional grocery chain.

[← The Studio](https://tenantcraft.ca/work)

Power Automate · Grocery retail

## Interview status emails

Two SharePoint Designer workflows used to send these emails, and Microsoft has since retired that workflow engine. This flow replaces both. Click any card to see how it’s set up and preview the emails it sends.

-   **Tool**Power Automate cloud flow
-   **Trigger**SharePoint item created or modified
-   **Replaces**two SharePoint Designer 2013 workflows

make.powerautomate.com

Run this flow

Plays a quick run of the flow above. Nothing is sent.

1.  01 Request #57 changed
2.  02 Status is Request Info
3.  03 Request info email sent

Done in 3 steps: one email, picked by the request’s status.

Outlook · Inbox

You’ve got mail

From

Talent Acquisition <careers@maplecrate.ca>

To

Mark Thompson <mark.thompson@maplecrate.ca>

Subject

**Interview Coordination - Request Info - Produce Manager**

Interview / Testing Coordination

**More information needed**

A member of our Talent Acquisition team has reviewed your interview coordination request and needs a little more information.

<table style="border-collapse:collapse;font-size:13px;width:100%"><tbody><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">Job opening #</td><td style="padding:6px 0;color:#222">26-1184</td></tr><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">Job title</td><td style="padding:6px 0;color:#222">Produce Manager</td></tr><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">Status</td><td style="padding:6px 0;color:#222">Request Info</td></tr><tr><td style="padding:6px 10px 6px 0;color:#666;white-space:nowrap;vertical-align:top">Message from TA</td><td style="padding:6px 0;color:#222">Please add a second panel member who can attend both dates.</td></tr></tbody></table>

View request

Please do not respond to this auto-generated email.

A working replica of a real Power Automate build, redone in HTML and JavaScript so you can click through it here. Maple & Crate Market is fictional; all names, people and numbers are illustrative. [Open it full screen](https://tenantcraft.ca/demos/interview-notifications-flow.html).

Want help building yours? [hello@tenantcraft.ca](mailto:hello@tenantcraft.ca)

## **01**How it works

Every build here sticks to standard connectors like SharePoint, Outlook and Approvals, so it runs on the Microsoft 365 licences you already pay for.

01

### One trigger for create and edit

A single SharePoint trigger covers new requests and status changes, so there is one flow to look after.

How to build it

1.  Use **When an item is created or modified** on the request list.
2.  Add a trigger condition so the flow skips items with no status.

02

### A switch on status

Each status gets its own branch and its own email, which makes adding one later a small change.

How to build it

1.  Add a **Switch** on the status column.
2.  Add one case per status: _Submitted_, _In progress_, _Request info_ and _TA rep_.
3.  Leave the default branch empty, so an unknown status does nothing.

03

### Branded HTML emails

The same header, details table and footer in every email, with the request fields filled in.

How to build it

1.  Write the body in HTML in **Send an email (V2)**.
2.  Send to the requester and CC the hiring manager from the item’s columns.
3.  Link back to the list item, so people answer in SharePoint and not by reply.

## **02**More builds

-   [Power AppsInterview request appA four-step canvas app that collects the interview panel, locations, time slots and candidates, and checks each step before the request can go in.Power Apps · Grocery retail](https://tenantcraft.ca/studio/interview-request-app)
-   [Power AppsHR staffing requestA checklist, then a stepped request form. The approval scenario decides who signs off, and submitting starts the staffing approvals flow.Power Apps · Insurance](https://tenantcraft.ca/studio/staffing-request-app)
-   [Power AppsContractor insurance questionnaireProject managers answer 21 yes-or-no questions about a job and get the insurance clauses for the contract, ready to paste.Power Apps · K-12 education](https://tenantcraft.ca/studio/contractor-insurance-app)
-   [Power AutomateStaffing request approvalsFour approval routes in one flow. Who signs off depends on the kind of request, and every decision is written back to the list with a dated history.Power Automate · Insurance](https://tenantcraft.ca/studio/staffing-approval-flow)
-   [Power AutomatePosition number alertA small flow that tells position control when a new staffing request needs a position number created or changed.Power Automate · Insurance](https://tenantcraft.ca/studio/position-number-flow)
-   [Power AutomateBudget adjustment approvalPick a budget file in the library, send it for approval, and the flow stamps the outcome on the file and emails the finance leads.Power Automate · Financial services](https://tenantcraft.ca/studio/budget-approval-flow)

[All builds →](https://tenantcraft.ca/work#power-automate)

(Your process)

## Still running it on email?

[Book a discovery call](https://tenantcraft.ca/contact) [How projects work](https://tenantcraft.ca/services)

---

_Canonical HTML: https://tenantcraft.ca/studio/interview-notifications-flow · Agent guide: https://tenantcraft.ca/llms.txt · Site map: https://tenantcraft.ca/sitemap-index.xml_
