Adding the constituent name in List Gifts notification

Options
Jundino Ugo
Jundino Ugo
Tenth Anniversary Name Dropper Photogenic First Comment
in SKY Developer General Discussions
Hi there,

What is the trick to add the constituent name in Create HTML table or Create CSV using the List Gifts? It is not included in the LIst Gifts so I tried using Get Constituent in the For Loop then Select the fields which works - I'm able to pick the constituent name. However, I can't create a HTML table outside the loop for the List Gifts including the name.  Your help will be appreciated if someone can direct me how to properly write the code.


thanks,

Jundino
Tagged:

Comments

  • Prenger Solutions
    Prenger Solutions
    Fifth Anniversary Name Dropper Photogenic First Comment
    I have also been trying to do this with no luck.  I'm hoping that someone can help.
  • Ben Lambert
    Ben Lambert
    Ninth Anniversary 100 Likes 100 Comments Name Dropper
    Hi Jundino,


    There are probably a few ways this could be accomplished, but one way is to loop over the results of the List Gifts action and call Get Constituent to retrieve the name (as you're doing).  You can use the addProperty() function to append the name to the current item in the array, but the trick is you'll need to compose a new array to contain the result.  I'll create a flow to demonstrate this and paste in some screen shots today.
  • Ben Lambert
    Ben Lambert
    Ninth Anniversary 100 Likes 100 Comments Name Dropper
    Here's a flow that demonstrates the technique I described above (and this is just an example, you could certainly rearrange some steps in this flow if desired).


    First, I'll initialize a new empty array variable to hold the "augmented" gift items which will include the constituent name (note the empty brackets provided as the default Value for the variable):




    Next, I'll use the List gifts action (with whatever criteria is desired) to fetch gifts:




    I'll iterate over the results, and within the loop use the Get a constituent action to fetch the constituent details.  I'll then use the Compose action to compose a new object (including the constituent name), and then use the built-in Append to array variable action to append that new object to the gifts array variable:




    In the above Compose action, the addProperty() function is used to add a new property named "Constituent Name" to the current item in the loop: 

    addProperty(item(), 'Constituent Name', outputs('Get_a_constituent')?['body/name'])

    Now, outside of the loop, for convenience I'll use the built-in Select action to project a new array object (based on the gifts array variable) containing only the fields I want in my HTML table:




    The Select actions also allows me to specify more user-friendly column names, and the map formulas I'm using for the column values are:


    item()?['id']
    item()?['type']
    item()?['amount/value']
    item()?['constituent_id']
    item()?['Constituent Name']



    Finally, I use the built-in Create HTML table action to built the HTML table based on the output from the Select action:




    So my completed flow looks like this:




    ...and when the flow runs, the HTML table will look like this:




    I hope this helps demonstrate the approach - please let us know if you have questions!

Categories