Update a constituent custom field

Liz Dixon-Eversole

I am trying to update a custom field via Power Automate.

If I ADD a custom field, the flow works fine. When I replace the Add with Update, it does not. It keeps replacing the input with body/value and giving me the following error:

InvalidTemplate

Unable to process template language expressions for action 'For_each' at line '0' and column '0': 'The template language expression 'outputs('Filter_for_YGNC')['body/value']' cannot be evaluated because property 'body/value' doesn't exist, available properties are 'body'. Please see https://aka.ms/logicexpressions for usage details.'.

Even if I change the input to body, it give this error and changes it back to body/value.

Why? How do I fix. The output in the previous step (filter) only returns a single result. I know it might be expecting more than one match, but why won't it work? Why does it keep changing its own inputs and then getting feisty about it?

Alex Wong

@Liz DixonEversole
A few things that's unclear from your post, but I will try to answer and you can reply with more info and screenshot.

1. are you using flow new editor or old editor
   1. I have encounter bug with new editor before where the dynamic content selected is INCORRECTLY coded
2. for updating a custom field (assuming constituent custom field, but same idea if gift custom field), you need the custom field system record id, not the constituent system record id (see image below)
   1. since your post mention “filter”. I am assuming you are getting list of custom field then filter on if a certain category exist, if no, add new, if yes, get the custom field system record id to use in the update action.
   2. filter will give you an array, EVEN if your RE NXT custom field configuration is set to “unique” (allow only 1). So one way to deal with that is to use the first() expression to just take the first custom field from the filter array: @{first(body('Filter_array'))?['id']}

Liz Dixon-Eversole

@Alex Wong Thank you! Let me try the first selection and see if that helps. I am not sure if I am using the new or old interface… I can share the packaged flow with you, if that's helpful? Thanks again!

Alex Wong

@Liz DixonEversole
don't need to share the package flow, you can use new/old editor anytime with the toggle that is on the upper right corner of editing screen.

Liz Dixon-Eversole

@Alex Wong THANK YOU!!! I cannot believe that toggling to the old designer and adding the update part back in fixed this. I wish I had reached out to you last week. I have picking at this a little every day and could not figure out what was wrong with my logic. Hahaha. VERY APPRECIATED!!!!