Formatted number not working with LetterArray

Carla Murphy
Carla Murphy
Eighth Anniversary Kudos 1 Name Dropper Participant
in Blackbaud Raiser's Edge NXT® APIs

I have a flow to generate acknowledgement letters. It creates individual letters and also a word document containing all of the letters in that run. The amount is formatted correctly in the individual letters, but not in the word file that contains all of the letters.

Below are some pieces of the flow. Any ideas what I may be missing?

Thanks!

fee04379f62a39dff743dc991f71fd3c-huge-im

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Carla Murphy
    your screenshot doesn't show when you assigned LinedArray (or is it LetterArray, blurry to see). If it is before you formatted the gift amount, then that would explains it.

  • Carla Murphy
    Carla Murphy
    Eighth Anniversary Kudos 1 Name Dropper Participant

    @Alex Wong
    Thanks Alex! The “apply to each” contains the formatted number, along with the word merge fields - I am using the formatted number with my Gift amount field. The Compose - Letter Array is outside of the “apply to each”. And then there is another Populate a Microsoft Word Template - Repeating Letter that has the LetterArray passed into it. Do I have to insert another formatted number outside of the “apply to each”?

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @Carla Murphy
    I'm going to assume your apply to each is applying to each gift.

    The first populate a ms word template populate the word template with info from constituent and gift and it is using the formatted gift amount. This is working as expected which makes sense.

    I'm going to assume also that your 2nd populate word template is using repeating section content control, where your LetterArray is storing the needed info for “each letter”. Since I can't see where you are setting/appending the values of the LetterArray variable (your screenshot only shows that you “Compose” action using the content of LetterArray, which isn't really neccessary), I can't really say where you went wrong. Though I would check the actions where you set/append to the LetterArray and see if you are using the formatted gift amount within the data you use to set/append LetterArray.

Categories