Notion New Hire Onboarding Board Generator

Overview

This flow spins up a personalized Notion onboarding workspace for every new hire. When a new-hire row is created in Dataverse (typically by HR, or fed from an HR form/HRIS), the flow reads the hire's details, creates a personalized onboarding board page in Notion, generates role-specific onboarding tasks (each with a calculated due date) in a Notion tasks database, emails the hire and their manager the board link, and posts a Teams notice to the IT channel to begin account and equipment provisioning.

Why it matters: manual onboarding setup is repetitive and inconsistent. Generating a tailored Notion board from a single HR trigger ensures every hire gets the same complete, on-time experience - and cues IT automatically so provisioning starts on day one.

Ships Off (demo).

Use Case

HR adds a new hire (a Dataverse New Hire row) and wants a ready-to-go Notion onboarding board with role-based tasks, shared to the right people, and IT cued to provision - automatically and consistently.

Flow Architecture

Environment Variables

Connectors & Connections

Note — All connections are referenced as solution connection references; the flow is portable between environments as long as a connection is mapped at import time.

Customization Guide

Almost every realistic variant of this flow can be implemented by changing environment variable values. A few cases require small edits inside the flow definition — those are called out explicitly below.

Role-based tasks

Edit flowlibs_RoleTaskTemplate (JSON). Add departments or seniority tiers by branching on department/job title before the loop, or pick a template with a Switch.

Account creation

Chain Microsoft Entra ID after the board is created to provision the hire's account once approved.

Approval gate

Insert an Approvals step before provisioning so a manager signs off before IT is notified.

Board content

Extend the board properties or append block children (welcome text, checklist) using the Notion block operations.

Offboarding

Mirror this pattern for departures to revoke access and archive the board.

Key Expressions

The flow is intentionally light on Power Fx / WDL gymnastics — the heaviest expressions are the branch-name concatenation and the approval outcome check. They are listed below in the order they appear in the flow.

first(split(last(split(triggerOutputs()?['body/@odata.id'], '(')), ')'))

concat('Onboarding - ', variables('varHireFullName'))

json(parameters('flowlibs_RoleTaskTemplate'))

formatDateTime(addDays(variables('varStartDate'), item()?['offsetDays']), 'yyyy-MM-dd')

@{variables('varHireEmail')};@{variables('varManagerEmail')}