Addition of Gift Benefit Amount to Simple Acknowledgement Letters

Hallie Guiseppe

I am sharing an addition to the simple acknowledgement power automate flow in case anyone else needs an option to include a benefit amount in your letters. At my organization, we combine the acknowledgement with the gift receipt to save on the amount of mail that we send out. Below is a snip of what I built out using the traditional conditional mail merge (not power automate) to accommodate our needs.

I could not locate the end point for benefit amount in Power Automate so I followed THESE instructions to calculate the benefit (Gift Amount - Receipt Amount = Benefit Amount) for use in the Simple Merge Acknowledgement Template provided in the template showcase. Below is a snip of what I added to the flow template provided.

• Compose-ReceiptAmount Expression: item()['receipts'][0]['amount/value']
• Compose-ConvertGiftAmountToFloat: float(outputs('Compose-GiftAmount'))
• Compose-CalculateBenefitAmount: sub(outputs('Compose-ConvertGiftAmountToFloat'),outputs('Compose-ReceiptAmount'))

I hope this helps some of you! I know how much your posts are helping me learn. Thanks!