Assigned Fundraiser not displaying in Power Automate
This was an issue I came across last year (and did get some input at the time), but never resolved and am only getting back to it now.
I am looking to send an Action list via email and want to include the Action Solicitor name. All I get is the ID number. Any thoughts as to what is wrong with this flow? In the Dynamic content in “Assigned to Array Variable”, Constituent 2 fields don't display.

Comments
-
@Reuben Schmitz
You do not need to use another apply to each on the fundraisers.After your Get a constituent action action, you get a dynamic content of Fundraiser(s) (with a description of “The set of system record IDs for the fundraisers….”). What you can do is, use the List constituents action and in the Constituent ID field use the join() expression to join the fundraiser's system id with a comma (,):
join(outputs('Get_a_constituent_action')?['body/fundraisers'], ',')
You will get something like this as a result of the join(): 1111,2222,3333

This will give you all the constituents in an array for all the assigned fundraisers. You can then use the Select action to select only the name of the constituents as an array

in your append to array variable, yo ucan use the join() expression again, to join the mulitple assigned fundraiser(s) by a delimiter (i.e. semi-colon or comma)
join(body('Select'), '; ')
You will get something like this as a result of the join(): John Smith; Mary Jones; Tom Hanks
1 -
@Alex Wong Thanks as always for your insight and guidance. Your solution worked fine for me. and I have what I need. Thanks again!
1
Categories
- All Categories
- 6 Blackbaud Community Help
- 209 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 359 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 563 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 243 ResearchPoint™
- 118 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 779 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)

