What's next after 'List constituent custom fields'?

Joe Shaver

Hi everyone! Longtime RE user, still somewhat new to the Developer space (a few years now, a few bbdevdays under my belt, been learning TONS about Power Automate). Building out my first major time-saver flow and running into some issues.

I used this post (thank you Nicole and Alex!) to get started on my flow. What I'm trying to do: update or add a constituent attribute based on query output. I'm successfully running a query and parsing out the query fields. Within the ‘apply to each’ loop, I'm successfully using the QRECID to ‘List constituent custom fields’. But that's when I get stuck. What's the next step? The output is an array of all custom fields on that person's record. I want to check if the custom field I'm looking for is in that array. If it is, I want to update it; if it's missing, I want to add it.

Any assistance would be much appreciated!

Alex Wong

@Joe Shaver
after list constituent custom field, you want to do a Filter array action, which filter on category = the category of attribute you are looking for.

After the Filter array, you will want to do a Condition action, condition on the length() of the dynamic content of Filter array body. If equals to 0, then you add the attribute, otherwise update it.

Joe Shaver

@Alex Wong This worked flawlessly! Thank you so much! I'm using this flow to update giving levels regularly instead of me updating the entire database at the end of the fiscal year manually. Appreciate the assist!