After gift is processed, add a Custom Field to Const. Record RENXT Power Automate

Tyler Johnson
Tyler Johnson
Eighth Anniversary Kudos 1 Name Dropper Participant
edited September 30 in SKY Developer General Discussions

Hello Everyone,

Once a gift comes in, I'd like the flow to put an attribute (custom field) on the Const. record. I was able to get this to work with a gift list I set up, but wanted to go one step further and make sure if the record already has this attribute (custom field), then do not add again, since this flow would be running the list every 30 minutes or hour. Here is my flow. Any ideas?

Screenshot 2025-09-30 132353.png

Best Answers

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge
    Answer ✓

    After the List constituent custom fields action, add a Filter array action to filter the value (array of custom fields returned for the constituent) by Category = the category you are looking to add. Then add a Condition action to condition on the length() of the filter array = 0, meaning the custom field category is not found. Add the Create a constituent custom field action in the "Yes" path.

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary Kudos 5 Facilitator 3 Raiser's Edge NXT Fall 2025 Product Update Briefing Badge
    Answer ✓

    Your For each action is definitely not supposed to be there, and likely placed there when you did some selection of dynamic content.

    so what you want to do is check Create a constituent custom field to make sure it is not using any dynamic content from an array. If no, then just "move" the Condition 1 outside of the For each loop right after the Filter array action.

    If you have trouble "moving", then screenshot what is in the "For each" action.

Answers

  • Tyler Johnson
    Tyler Johnson
    Eighth Anniversary Kudos 1 Name Dropper Participant
    edited October 1

    Thanks @Alex Wong! Totally makes sense, but it seems to get stuck at the "For Each" / "Condition" part though…not sure what I did wrong. Screenshots below:

    Screenshot 2025-10-01 095343.png Screenshot 2025-10-01 094936.png Screenshot 2025-10-01 094724.png Screenshot 2025-10-01 100212.png
  • Tyler Johnson
    Tyler Johnson
    Eighth Anniversary Kudos 1 Name Dropper Participant
    edited October 1

    @Alex Wong hmm…I thought that might be the case with the For each, as you did not mention it in your response, but was not sure.

    Edit: ok, I used your suggestion and moved things around and then updated things and it works now! Thanks so much, truly appreciate your help.

  • Joanna Caley
    Joanna Caley
    Facilitator 1 First Anniversary

    Hi Tyler - I am curious as to why you are doing this and what the purpose is for the custom field on the record. Are you not able to get the information you need from the gift record?

  • Tyler Johnson
    Tyler Johnson
    Eighth Anniversary Kudos 1 Name Dropper Participant
    edited October 3

    @Joanna Caley I know it's extra info, but it was/is a way to manipulate the RENXT Const. Lists (they are very basic) before the Query section was brought into NXT. Also use it for Power Bi stuff.

Categories