Issue with Flow

Jessica White

Hi All,

I am fairly new to Power Automate. I took the in-person class in Chicago but haven't had much time to dig deeper until now. I am taking the accelerator courses which have been great and are helping a lot, and received some assistance from Austen, but I am still stuck on why my current flow isn't working. I noticed when looking at the output that in the first step it's pulling the correct record, but when I move on to constituents it's pulling a different record so it seems the two steps aren't connected. The logic of my flow is to look at a list of event participants, and update participation to Staff if constituent code of staff exists on the constituent record. Does anyone have any ideas?

UpdateEventParticipationifConstituentCodeisStaff_20231129151219.zip

Thanks!

Jess

Austen Brown

@Jessica White - Within your List constituents action you need to include the Constituent's record system ID which is… List Event Participants > “Contact ID” (in Power Automate). Put this within the constituent id field (screenshot below):

That should solve it.

Alex Wong

@Jessica White
a few things you can do to make your flow cleaner.

• you do not need the List constituents action (step)
  • this will remove your need to have an Apply to each constituents returned from List constituents action
• in your list constituent codes action, use the Contact ID from the List event participants action
• your Filter array action is perfect, but with that action, you no longer need the Apply to each 2 that loops through the item in the output of Filter array action.
  • Move the Condition action outside of Apply to each 2 right after Filter array, then delete Apply to each 2
  • Remove the ID you put for Constituent ID field in Update a participant action, you only need the Participant ID specified.

Jessica White

@Austen Brown
Thank you SO much! That worked! I had a hunch that was my missing piece but didn't know that Contact ID would work. I thought that the constituent system record ID wasn't available in the event fields since none of the ID names were clear. Is there a chart or pdf that compares automate fields with NXT fields for newbies?

Jessica White

@Alex Wong
WOW thank you so much! I'm so thankful for the quick responses not only solving my issue, but teaching me how to make cleaner and more efficient flows as I hope to make much more complex flows going forward.

Alex Wong

@Jessica White
Developer.blackbaud.com sky api reference documentation tells you all the details of what property is what

Austen Brown

@Jessica White - You can look at the API documentation or the RE NXT Connector Documentation within Microsoft. I happened to go the long route, looked at the output from the List event participants action and located the ID that had a matching number to the test record's constituent system ID.