Formatted number not working with LetterArray

Carla Murphy

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!

Alex Wong

@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

@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

@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.