Eventbrite Live Check-In Dashboard

Overview

This flow gives event organizers a real-time turnout view for live Eventbrite events without watching the Eventbrite app. On a 15-minute schedule it lists the organization's live events, reads each event's attendee check-in state, upserts a live attendance stat row in Dataverse, and posts 25/50/75/100% turnout milestone alerts to a Teams event channel. It also records no-shows (registered minus checked-in) once an event's start time has passed.

Why it matters: Live milestones and no-show counts surfaced in Teams keep the whole events team informed and able to react (e.g. release a waitlist) without anyone babysitting the Eventbrite dashboard.

Status: Built and deployed to the environment as a solution-aware cloud flow. Ships Off (demo). Going live requires only connection authorization + env var configuration (see Customization Guide).

Use Case

An events team running in-person events wants live check-in visibility and no-show detection surfaced in a Teams channel, with a durable Dataverse record of turnout per event for reporting.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
Eventbrite	shared_eventbrite	GetOrganizationEvents
Microsoft Teams	shared_teams	PostMessageToConversation
Microsoft Dataverse	shared_commondataserviceforapps	ListRecords CreateRecord UpdateRecord

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.

Set the env vars

Before turning on: Eventbrite org id + private token, the Teams group/channel ids of your event channel, and the milestone band size (default 25 -> alerts at 25/50/75/100%; set 20 for finer bands).

Authorize connections

Authorize the three connections (Eventbrite, Teams, Dataverse) on first open.

Polling cadence

Change the Recurrence interval (default 15 min) for closer-to-real-time updates.

Attendee pagination

The Eventbrite attendees endpoint returns the first page (50). For very large events, extend Get Attendees to follow pagination.has_more_items / continuation and accumulate the checked-in count across pages.

Per-session tracking

For multi-track events, key the stat row on event id + session/track to track check-ins per session.

Live artifact / Power BI

Point a Power BI report or a live view at the flowlibs_eventcheckinstat table for a visual dashboard.

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.

@if(greater(outputs('Compose_Registered'), 0), div(mul(outputs('Compose_CheckedIn'), 100), outputs('Compose_Registered')), 0)

@mul(div(outputs('Compose_Pct'), variables('varMilestoneBand')), variables('varMilestoneBand'))

@if(less(coalesce(items('Apply_to_each_Event')?['start']?['utc'], '9999-01-01T00:00:00Z'), utcNow()), sub(outputs('Compose_Registered'), outputs('Compose_CheckedIn')), 0)

and(greater(Compose_Band, Compose_LastMilestone), greaterOrEquals(Compose_Band, varMilestoneBand))

flowlibs_eventid eq '{event id}'

Customize & download