Skip to content
tenantcraft
← The Studio
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.

  • ToolPower Automate cloud flow
  • TriggerSharePoint item created or modified
  • Replacestwo SharePoint Designer 2013 workflows
make.powerautomate.com

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

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

  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.

02More builds

All builds →

(Your process)

Still running it on email?

Sneak peek

Document preview

100%

Loading the document…