How to add Fundraiser Name from the Connector

Chris Zello

I'm working with a flow that emails a digest showing everyone with a birthdate this month.

I'd like to add the Fundraiser to the output that is emailed, and believe I simply need to add a Connector to get the name of the fundraiser. How do I do this?

I don't see the Name field I'm seeking with only the Connections for Blackbaud Raisers Edge NXT and Outlook. I believe it would be in the Fundraiser connection/endpoint, although I'm not seeing an option for Name there.

Thanks.

Alex Wong

@Chris Zello
there is a get fundraiser assignment action, which returns an array of fundraiser (only gives you fundraiser's system record id) for a constituent. You will then need to use the fundraiser system record id and call get a constituent endpoint to get the fundraiser's name.

However, one constituent can have more than one fundraiser, so you will need to determine if (1) org-wide policy only have one fundraiser per constituent, then you can use “first()" expression without using loop or (2) you are going to use a for each loop to loop through each fundraiser.

below is the “steps” for option (2).

1. initialize an array variable for constituent
2. initialize an array variable for fundraiser name
3. list constituent
4. apply to each constituent
   1. list constituent fundraisers
   2. apply to each fundraiser
      1. get a constituent on the fundraiser system id
      2. append name from get a constituent action to array variable for fundraiser name
   3. append to array variable for constituent info you want from the constituent, and use expression to join the potentially multiple fundraiser separated by a semi-colon
      join(variables('fundraiser name'), ‘; ’)
   4. reset varaible fundraiser name by setting it to empty array []
5. create html table
6. send email

Jessica Daggett

Chris or Alex, this is the exact first flow I'm trying to build. I'm still really new so I'm lost in the steps. Chris if you got this built, would you share a screenshot of the order of things perhaps?

Jessica Daggett

@Chris Zello or @Alex Wong

this is the exact first flow I'm trying to build. I'm still really new so I'm lost in the steps. Chris if you got this built, would you share a screenshot of the order of things perhaps?

Jessica Daggett

I'm stuck on Steps 4 c, d, and Step 5 (I think!). For 4c, I've selected initialize array variable for constituent and under value I've selected name and birthdate fields but every time I type the join expression into the value box it goes away. Then on 4d, I don't actually know where or how to do that. Then in step 5, the html table "from" lets me pick either of the 2 variables, or data from List constituents but can't figure out how to combine both constituent and fundraiser info. Sorry I am so new only having been to bbdevdays and taken the 3 Blackbaud classes which only get you so far with comprehension! Here is what I have if anyone has time to respond in 3rd grade terms:

Chris Zello

I believe I attended the monthly BB Power Automate user group and got assistance with this flow. It changed a lot as a result of that.