Gift Tributes on Receipts?

Carol Grant

I'd like to show In Honor of and In Memory of on my receipts. I can't seem to figure out the List Gift Tributes. We have NOT setup the Gift Tribute Acknowledgee. We simply pull in the person's record and then choose what tribute type. Maybe that is the issue?

Here is my output for one gift with two In Honor Of tributes. I thought this would be easy enough to do Get a Constituent and put the "tribute_id": 175 for the system id but that doesn't work.

Also, how do I get the tribute type from here. It looks like 387 = “In Honor of”.

[
{
"id": 17176,
"gift_id": 792351,
"tribute_id": 175,
"tribute_type": 387,
"import_id": "00001-546-0000017176",
"acknowledge": "NotAcknowledged",
"sequence": 1
},
{
"id": 17177,
"gift_id": 792351,
"tribute_id": 129,
"tribute_type": 387,
"import_id": "00001-546-0000017177",
"acknowledge": "NotAcknowledged",
"sequence": 2
}
]

Thanks,

Carol Grant

Alex Wong

@Carolyn Grant
There is a “Get a tribute” API endpoint that's the “mid ground" to get to what you need.

Carol Grant

@Alex Wong- I couldn't find Get a Tribute anywhere. It's not in the Gifts endpoint. I checked the API reference although no Tribute fields are listed there.

Alex Wong

@Carolyn Grant
it's under NXT Data Integration

Provide the endpoint with the tribute_id, and you get the info about the constituent:

Carol Grant

@Alex Wong- thanks! What's funny is Get a Tribute is under the Constituents connector, not the Gifts Connector. I understand Tribute endpoints can go in both places because of which side you are looking at but that was not the first place I would look.

Heather McLean

@Carolyn Grant - Did you manage to figure out this flow and would you like to share it at the next Power Automate User Group?

Carla Murphy

@Carol Grant Hi Carol, Did you ever get this to work? Would you share it? Thanks!

Carol Grant

@Carla Murphy

I can share. I do a List Gifts then I loop around each gift and list gift tributes. You may not need Get a Gift but I need it for Fund Name.

Then inside of that loop, I have another Apply to each which grabs the Tribute ID and a Get a Constituent to get the Name of the person who the Tribute is for.

Then append to an array inside the loop. I append to an array because sometimes there is more than one and I can use Join later to combine them.

Carla Murphy

@Carol Grant - Carol, did you ever get the tribute information to display in the tax receipt? I'd like to try to get that to work. Would you share your flow so that I can see how you did it?

Thanks!

Carol Grant

@Carla Murphy- Yes and I can't share my flow because it's complicated. I did create a new one though and I see where you might have an issue.

Under the List Gift Tribute Acknowledgements, you can't access the Gift ID easily, it doesn't come up in dynamic content so what I have in there is:

items('Apply_to_each')?['id']

which is really the gift ID from List gifts.

Then I do another apply to each that gets the Constituent who is tributed and I get the name of them from Get a Constituent. Then I append to an array.

Here it is all in one

If you need more detail in a field and which ID is in there let me know.

Kristina Pollard

Hi @Carol Grant, I hope you are well. Can you help me with the append to an array when there are multiple tributes on one gift? What are you outputting next to the “name” field?

Carol Grant

@Kristina Pollard
Hi Kristina- when I append to an array I have the Tribute Type from the Get a Constituent Tribute. Here it's listed below.

Then I put a space and list the Name of the person. I got the name from Get a Constituent which I put the Constituent ID from above into that.

Note: My append to array looks like a Compose output and not a Tribute Type field because I had to change the Capital H and M to a lower case for my receipts.

OUTSIDE the Loop of the I have a Compose that does a join with the Append to Array variable. My variable is named Tribute Name so that joins all Tribute Names with a comma so it looks like in honor of President Anyname, in memory of Tina Turner for one gift.

join(variables('Tribute Name'),', ')

I hope that helps!

Carol Grant

Actually here's a print screen without my Compose if that will help.

Kristina Pollard

@Carol Grant- Thank you for the explanation. I got that output with the comma separated tributes but it is pulling the tributes from the entire gift list and not by each gift. Where do you nullify the tribute name variable? I never know where to put that.

Carol Grant

@Kristina Pollard- I have a one master Apply to Each loop that gets each gift, then some others inside (Tribute, Get Fund Name). You want to Set Variable- inside the master Apply to Each Gift loop for the gifts for your variable = null (expression type in null) but outside of the Tribute Loop and any other Apply to each loop (Tribute, Fund Name)

This way when it gets each gift it will start out blank and add to the variable each time. It doesn't work if you put it at the very bottom of the flow if you are clearing out others.