Sharing my Power Automate template: Overdue Action Audit

Options
Hallie Guiseppe
Hallie Guiseppe
Fifth Anniversary 250 Likes 100 Comments Name Dropper
in SKY Developer General Discussions

Description:

This flow will pull a list of overdue actions from RENXT and send an email requesting the fundraiser update the actions.

Required connections:

Blackbaud Raiser’s Edge NXT Constituents
Blackbaud Raiser’s Edge NXT Interactions
Office 365 Outlook
Microsoft Teams

Suggested skill level:

Beginner

Configuration details:

Begin by creating an action list in RENXT that is filtered by:

  • Action Status = Past Due
  • Action Date = (your choice). We use “Last quarter.”
  • Fundraiser = (your choice).
    • Note: I’m working on a version that will dynamically pull in the fundraiser assigned to the action. I will share an update when that is completed.

Download the flow:

Set up the Flow

  1. Update the recurrence trigger to suit your organization's schedule.
    • This flow is set to run on the first of every month at 8 am.
  2. In the “Select actions list from RENXT” step, Update the Action List
    • Link the list to the dynamic action list you created in RENXT.
  3. Update the “Append to information to array variable” step.
  4. Update the “Email about Overdue Actions” step
    • Replace the email address in the “To” field.
    • Update the email body as needed.
    • Replace the email address in the “From (Send as)” field.
    • Replace the email address in the “Reply To” field.
    • Disable static result
  • Update the “Post message in a chat or channel” step.
    • Disable static result

Category:

Automation, Data Management

Note:

This flow incorporates an error-handling method presented at the 2023 bbdevdays by @Alex Wong. You can learn more at: https://youtu.be/WbUvc50Or-E?si=RuoQ9dVpWnqa9Lgc

OverdueActionAudit-BlackbaudTemplateShowcase_20240523143342.zip

Tagged:

Comments

Categories