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.
- ToolPower Automate cloud flow
- TriggerSharePoint item created or modified
- Replacestwo SharePoint Designer 2013 workflows
- 01 Request #57 changed
- 02 Status is Request Info
- 03 Request info email sent
Done in 3 steps: one email, picked by the request’s status.
You’ve got mail
- From
- Talent Acquisition <careers@maplecrate.ca>
- To
- Mark Thompson <mark.thompson@maplecrate.ca>
- Subject
- Interview Coordination - Request Info - Produce Manager
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.
Want help building yours? hello@tenantcraft.ca
01How 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
- Use When an item is created or modified on the request list.
- 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
- Add a Switch on the status column.
- Add one case per status: Submitted, In progress, Request info and TA rep.
- 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
- Write the body in HTML in Send an email (V2).
- Send to the requester and CC the hiring manager from the item’s columns.
- Link back to the list item, so people answer in SharePoint and not by reply.
02More 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
- 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
- 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
- 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
- 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
- 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