nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter on multiple funds in Power Automate Flow

Tyler Johnson

Hey @Alex Wong or anyone else,

I have this flow that works and is based on a Gift list in NXT. The Gift List has two different funds being pulled and I need to show which fund it is in the email.

My Filter Array works if it is set to "equal" but not if I try to use the Advance Mode and put in code. Maybe my code is wrong?….

Code:

or(equals(item()?['description'], '26-27 Fund'), equals(trim(item()?['description']), 'Senior Gift'))

Here is my flow:

Without giving donor info away, here are the headers:

Find more posts tagged with

Accepted answers

Alex Wong

I'm not sure what you are trying to do with the flow.

I'm assuming List funds is listing all funds in your RE NXT as there is no "action" that list all funds of a gift record.

if it's List funds as I said, then you may be running into issue on "limit" as by default it will only return 500 funds.

All comments

Alex Wong

I'm not sure what you are trying to do with the flow.

I'm assuming List funds is listing all funds in your RE NXT as there is no "action" that list all funds of a gift record.

if it's List funds as I said, then you may be running into issue on "limit" as by default it will only return 500 funds.

Tyler Johnson

I figured it out Alex. Thank you for replying and checking on my situation. Cheers.

Carol Grant

@Tyler Johnson - Hi Tyler- are you trying to limit the gifts that come in to only those funds? We would need to see what is behind your List Funds. Did you pull in the split gift funds ID?

When I use Get a Gift, I pull in Get a Fund next and pull in the gift splits fund id from Get a Gift. Even though you may not split gifts it will work to pull it in. Then if you want to pull out only those Funds to

Your filter array looks fine. You also might want to try using Query API and run this as a query which may be easier and selecting gifts to a certain fund then using JSON as an output and pulling over the constituent information you want to display in the email.

-Carol