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

Tyler Johnson

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?

Alex Wong

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

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.

Tyler Johnson

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:

Tyler Johnson

@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

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

@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.