How to Add Fundraiser's Name to a Gift List Notification Flow

Options
Cathy Kollar
Cathy Kollar
Third Anniversary Name Dropper Participant Facilitator 1
in SKY Developer General Discussions

In the Append Array Variable Gift Digest, Fundraiser Item returns the fundraiser's system ID. Can anyone tell me how to add the fundraiser's name instead of the system ID to the email output or Gift Digest?

Tagged:

Comments

  • Stacy Cope
    Stacy Cope
    Third Anniversary Kudos 2 Name Dropper Participant

    Hi @Cathy Kollar ! You will need to add a “Get a constituent" action to the flow, and for that action enter the Fundraiser ID from dynamic content. That action will then pull in all the constituent information for the fundraiser, including name.

  • Cathy Kollar
    Cathy Kollar
    Third Anniversary Name Dropper Participant Facilitator 1

    Hi Stacy! Thanks for your reply! If I already have Get a Constitiuent and it pulls in the constituent who made the donation, can I add fundraiser ID to the same action? Or do I need a second Get a Constituent action?

  • Stacy Cope
    Stacy Cope
    Third Anniversary Kudos 2 Name Dropper Participant

    You will need a second “Get a Constituent”. It's a good idea to rename the second “Get a Constituent” action to something like “Get Fundraiser Details” so it's easier to keep them straight when you are looking for dynamic fields to output.

  • Cathy Kollar
    Cathy Kollar
    Third Anniversary Name Dropper Participant Facilitator 1

    When I added “Get a Fundraiser” multiple apply to each loops were automatically created and I received and error message “invalid json”:

    409b0b4ae637e5d1ed0375f918080a06-huge-im
  • Stacy Cope
    Stacy Cope
    Third Anniversary Kudos 2 Name Dropper Participant

    Would you add a screenshot of the earlier part of your flow?

  • Cathy Kollar
    Cathy Kollar
    Third Anniversary Name Dropper Participant Facilitator 1

    I really appreciate your help. Here's the additional steps of the flow. Also I deleated the fundraiser loops.

    671c7cb81dd65d2b9ddeae01839000d6-huge-im
  • Stacy Cope
    Stacy Cope
    Third Anniversary Kudos 2 Name Dropper Participant

    Hi @Cathy Kollar ! I think the issue is that fundraisers are an array, so it thinks there are more than one and it wants to create the apply to each to run through all fundraisers for each gift. You could likely use steps similar to this process from @Glen Hutson to compose just one fundraiser's name which you could then add to your digest array.

    https://www.youtube.com/watch?v=409ITVV3cSE
  • Dan Snyder
    Dan Snyder
    Ninth Anniversary Kudos 5 PowerUp Challenge #3 Gift Management Name Dropper

    @Cathy Kollar another option is to initialize a variable to store the fundraiser name. When I was building my flow for gifts where there was no fundraiser it kept erroring out because the fundraiser value was null and this was the option we came up with. I have not tested Glen's option, but it seems much cleaner if it can handle those without a fundraiser.

    7bac17806e78698670f5ca3535af264c-huge-im

    This is the expression in the condition to look for the presence of a fundraiser: length(outputs('Get_each_gift_details')?['body/fundraisers'])

  • Padman DeSilva
    Padman DeSilva
    Third Anniversary Facilitator 1

    Hi Cathy, you can get fundraiser's name via just in 03 steps.

    1. add ”apply to each" control and loop it by “fundraiser” under “get a gift" connection
    2. add “get a constituent” control and set its value as “fundraisers fundraiser ID" under get a gift connection
    3. and get the “name” to a variable that comes under get constituent control you added in previous step

    below are the screenshots for what I did to retrieve fundraiser name

    a1ee47b8219d9a4d72591c54d6ed2257-huge-1.
    e65ae95d8239b1178745ce051ae8f0a7-huge-2.
    512a6f3e6b27d00e9c9c0cf394068172-huge-3.
  • Cathy Kollar
    Cathy Kollar
    Third Anniversary Name Dropper Participant Facilitator 1

    Hi Padman, This is a great solution! Thank you for the screenshots, they really help. I first initialized a Fundraiser variable in the beginning of my flow, then followed your steps . I really appreciate your help! ? Here it is, just as you suggested.

    240301df8465456e2e80c20901015e20-huge-im

Categories