Send acknowledgement email flow is running but not sending the email

Options

I wrote this acknowledgment flow to because a specific donor requested to be acknowledged every month for his recurring gift. Since this not our usual policy I decided to use power automate to take care of this recurring monthly task. The flow is running successfully but never sends the email. I cannot figure out where I am going wrong.

I want this flow to run daily to look for new gifts since the last time it was run. It always says there are no new gifts even though I know a new gift was added. Note: I approve the batch the next business day AFTER the gift batch has been created.

65bf04fe758a4d30267c1e21e9524e6c-huge-im
6bd6e30132de3557af20f37c720ff075-huge-im
944ea63959469e15cb51e530e0b69aed-huge-im

Here is where the flow stops running but the flow run is listed as successful.

c610d27b9a5f459640e5763a52144c29-huge-im
daede7333ad44bbfaebd356f1208a8dc-huge-im
5e0eadce1c76595cad36c90e322011f8-huge-im

Here is the output from the test for the step where it stops

007280e3c6c3d7918e165d149c0078e6-huge-im
028a3ed2ac4d94cef244a32d3d35a466-huge-im

Comments

  • @Susan Fioribello
    check your List gifts action to see if any gifts are returned, if none, that explains why no email

    your logic may not be wrong, but the issue has to do with webview gift batch has a problem with gift property of “date added”. When a gift is made on 7/6/2025, the gift is “added” to the webview gift batch on 7/6/2025. If the webview gift batch is approved on 7/7/2025, the gift will still have 7/6/2025 as gift date added, instead of what it should be, which is 7/7/2025.

    I may have heard that this problem has been fixed, OR maybe it's “going” to be fixed but not yet. I am not certain as I have workaround for this issue from 2 years ago when the problem existed. @Anthony Gallo can you confirm if this has been fixed?

  • @Susan Fioribello
    Hi Susan- try removing the Needs Acknowledgement under Acknowledgement Status. I know I leave that blank on mine. Unless you know that the gift has that.

    Also, there might be a delay, are you running this right after you approve the batch?

    Alex has valid points about recurring gifts and their dates. I have problems with the date added with recurring gifts although I have not fully tested it since they made the change.

  • @Susan Fioribello
    Removing the Acknowledgement and the date added did allow the flow to run properly.

    I tried to use the Past Time as the gift date but then the letter was not sent.

    So, it looks like it is not possible to filter the gifts on date added, gift date or acknowledgement status.

    So how do I make this flow check daily for new recurring gifts and send the acknowledgment email?

  • Anthony Gallo
    Anthony Gallo Blackbaud Employee
    Ancient Membership 100 Likes 100 Comments Name Dropper

    @Alex Wong
    That specific issue was corrected. Gift date added is the date of the batch approval and the Gift date is the date of the transaction.

  • @Anthony Gallo
    thank you for that confirmation.

    @Susan Fioribello then the issue no longer exists and your flow should run properly if other paramters/logic is sound. So for your “list gift” you will want to use the “past time” on the Added on or after, not Start gift date.

    the only other issue you want to be careful about is making sure your “trigger” date/time is using same timezone as your “past time” action

Categories