Sharing my Power Automate Flows: Event Check-in / Mark Attended via Adaptive Card

Kevin Fletcher
Kevin Fletcher
Fourth Anniversary Kudos 1 Name Dropper Participant
in SKY Developer General Discussions

Summary

A streamlined, two-flow Power Automate solution for managing event check-ins within an Adaptive Card tile on your Event page. It supports multiple lookup methods, handles multiple search results (disambiguation), and updates constituent records in real-time.

image.png

Features

  • Multi-Method Lookup: Search by Name, Lookup ID (ConsID), System Record ID (SysRecID), Phone, or Email. Includes regex to provide validation warnings on the last two.
  • Smart Routing: Automatically identifies the input type and routes to the correct RENXT search logic.
  • Disambiguation UI: If multiple records are found (e.g., common names), the system presents a secondary card with radio buttons and detailed contact info to ensure the correct person is checked in.

Architecture

The system consists of two interconnected Power Automate flows:

  1. Flow 1: Event Initialization - The Adaptive Card displays only when your event is within three days of today (can be updated via the addDays(outputs('Get_an_event')?['body/start_date'],-3) expression within the Day of Event - Display Tile condition
    1. Retrieves the participant list for that event to build a searchable library in memory.
    2. Generates the initial Adaptive Card with a searchable typeahead list and manual lookup options.
  2. Flow 2: Processing & Update - Triggered by the "Submit" action on the Adaptive Card.
    1. Parses the input to determine the lookup method.
    2. Performs the search in RENXT.
    3. Handles single matches (immediate check-in) or multiple matches (returns a selection card to re-run the flow with the new selection).
    4. Updates the participant's status to "Attended" in RENXT.

Required Connections

Flow `1:

  • Blackbaud SKY Add-ins
  • Blackbaud Raisers Edge NXT Events

Flow 2:

  • Blackbaud SKY Add-ins
  • Blackbaud Raisers Edge NXT Events
  • Blackbaud Raisers Edge NXT

Suggested Skill Level

Intermediate

Setup/Configuration Updates

  1. Import Flows: Import both provided .zip packages into your Power Automate environment.
  2. Configure Connections: Update the RENXT connector actions in both flows to use your environment's credentials.
  3. Update Trigger URLs: Copy the HTTP POST URL from the trigger of Flow 2 and populate into the value of your Trigger2URL variables in BOTH flows.
  4. Validate a user identity token: Add the Application ID from your SKY Application in both flows.

Usage

  1. Run Flow 1 to deploy the check-in card.
  2. Staff can either:
    1. Select a name from the Attendee Search dropdown of pre-registered guests. The flow currently is configured to output LastName, FirstName (LookupID) if the record is a constituent — which makes LookupID also searchable in the typeahead — and LastName, FirstName (non-constituent) if they are not.
image.png


b. Use the Manual Entry / Walk-In button to enter a Name, ID, Phone, or Email.

Screenshot 2026-08-05 132628.png

  1. If a unique match is found, the user receives a "Success" confirmation.
  2. If multiple matches are found, a selection card appears with radio buttons to pick the correct constituent.
EventCheck-inSKYcard_Flow1_20260805171338.zip
EventCheck-inSKYcard_Flow2_20260805180108.zip
Tagged:

Categories