Pipedrive Contact Birthday and Milestone Outreach

Overview

This scheduled cloud flow drives timely, personal relationship touches from Pipedrive. Every morning it scans all Pipedrive contacts (persons) for anyone whose birthday or account-creation milestone falls on today's date, posts a ready-to-personalize outreach draft to a Microsoft Teams channel for the contact's owner, and optionally emails an automated greeting directly to the contact via Outlook.

Why it matters: Personal, well-timed touches build loyalty, but they are easy to forget at scale. Surfacing them automatically each morning keeps relationships warm with near-zero effort, while still leaving a human in the loop (the Teams draft) unless the team opts into fully automated greetings.

Status: Built as an Off (demo) flow. Going live requires only (1) authorizing the three connections, (2) setting the environment-variable values, and (3) turning the flow on.

Use Case

A sales or customer-success team wants a daily, automatic reminder whenever a Pipedrive contact has a birthday or hits an account milestone, delivered to the owning rep with a suggested message they can personalize — with the option to also send a polished automated greeting email to the contact.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
Pipedrive	shared_pipedrive	ListPersons
Microsoft Teams	shared_teams	PostMessageToConversation
Office 365 Outlook	shared_office365	SendEmailV2

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.

Auto-greeting vs prompt-only

Set varSendAutomatedGreeting to true to email contacts automatically; leave false to only post the owner draft (default, keeps a human in the loop).

Birthday-only

Set varMilestoneEnabled to false to skip account-creation anniversaries.

Time zone

Change varTimeZone so 'today' matches your business region.

Cadence / time

Adjust the Recurrence trigger (frequency, interval, hour) to run at a different time.

Richer milestones

Extend the filter to read additional Pipedrive custom date fields (e.g. contract renewal) by adding their hash keys and OR-ing them into the occasion filter.

Gifting / channels

Branch the loop to call a gifting service or a different notification channel for high-value accounts.

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.

@{formatDateTime(convertFromUtc(utcNow(), variables('varTimeZone')), 'MM-dd')}

@and(not(empty(coalesce(item()?[variables('varBirthdayFieldKey')], ''))), equals(formatDateTime(coalesce(item()?[variables('varBirthdayFieldKey')], '1900-01-01'), 'MM-dd'), variables('varTodayMonthDay')))

@and(equals(variables('varMilestoneEnabled'), 'true'), equals(formatDateTime(replace(coalesce(item()?['add_time'], '1900-01-01 00:00:00'), ' ', 'T'), 'MM-dd'), variables('varTodayMonthDay')))

@coalesce(first(coalesce(items('For_Each_Matched_Contact')?['email'], json('[]')))?['value'], '')

@coalesce(items('For_Each_Matched_Contact')?['owner_id']?['name'], 'the assigned account owner')

@and(equals(variables('varSendAutomatedGreeting'), 'true'), greater(length(outputs('Compose_Contact_Primary_Email')), 0))

Customize & download