Skip to content
tenantcraft
← The Studio
Power Automate · Insurance

Position number alert

Some staffing requests need a new position number or a change to an existing one. This flow emails position control when one of those comes in, and stays quiet for the rest.

  • ToolPower Automate cloud flow
  • TriggerSharePoint item created
  • Stepsfive
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. Algonquin Mutual Insurance 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

Triggered by the list, not the app

The flow fires on the list, so it works whichever form created the request.

How to build it

  1. Use When an item is created on the staffing request list.
  2. Keep the recipient in a variable at the top, so go-live means changing one value.
02

Only when a number is needed

A condition checks the two position-number columns. Most requests never send an email.

How to build it

  1. Add a Condition: new number required or existing number to update.
  2. Use coalesce() in a Compose step, so the job title is never blank in the email.
  3. Send the HTML email to position control and CC the person who submitted it.

02More builds

All builds →

(Your process)

Still running it on email?

Sneak peek

Document preview

100%

Loading the document…