Getting the fund description from "Get a Fund"

Alejandro Joven

Hi all,

I'm trying to get the fund_description from Get a Fund, I noticed that List of gifts have the fund_id within gift splits. I've tried to get the fund_id using the Gift Splits Item + Gift splits fund id and I tried the Gift splits fund id by itself as well, but always returns null.

Any assistance would be greatly appreciated.

Alex Wong

@Alejandro Joven

in list gift, there's a property call gift_splits, which is an array (since 1 gift can have multiple splits) of splits, that has the campaign_id, fund_id, appeal_id, package_id, amount (the amount of the split), etc. This is regardless of if your org uses split gift or not.

In order to get fund description of the gift split, you need to call Get a fund using the fund_id from the gift splits property, which power automate will put your get a fund into an apply to each loop, looping through each splits.

As to why you getting “null”, the likely answer is you used the wrong dynamic content for get a fund action. so what you want to do is (1) provide the full error message you got from get a fund action (2) in editing of your power automate flow, copy the dynamic content (click into the fund id input field for get a fund, then either highlight the dynamic content using your mouse, or just Ctrl-A to select and then paste it here.

Ashley Gelderblom

@Alejandro Joven
Even though you probably only have 1 fund, I think you need a 2nd nested for each to loop through the split gifts and then get the fund description- If you can guarantee there are no split gifts- you might want to assign the fund description to a variable so you can use it outside the for eachs

Alex Wong

@Ashley Gelderblom
If there is definitively no spliting of gift used in an org, you can avoid using another apply to each looping through the gift splits array. the first() expression can be used to get the first (and only) split data in the array and target the fund_id property within it. Though will make the flow cleaner, isn't required.

Alejandro Joven

@Ashley Gelderblom
Thank you Ashley !!! In our organization we use the split gift module, therefore the solution included two nested.

Alejandro Joven

@Alex Wong

Thank you Alex !! It worked with the two “Apply to each”