Spouse Code only certain ones for Receipt

Carol Grant

I am working on a receipt flow and I want to look at the primary donor code of the spouse and see if it matches a special list of donor codes that we have when we want to send to both parts of the couple.

For example, if the spouse has a code of Trustee and the donor has a code of Alumni, then we want to address the receipt to both of them. If the spouse code is a Friend then it won't be addressed to both of them. There are 11 donor codes that we want it addressed to go to both.

What I have doesn't work, it returns false even though it should be true. Details below.

Part 1 of the Spouse part- I filter the Spouse constituent codes by Sequence =1 and then append it to a string. See below, the spouse primary code is Trustee Spouse/Partner

I have loaded the codes into a simple table which is the List rows present.

Then I loop through them and my condition is my variable above.

Spouse Donor Code is equal to

items('Apply_to_each-Compare_to_See_if_Spouse_should_appear')?['Spouse Donor Codes']

This is where I get false even though they should be true! The spellings are correct on both ends. Any other tricks I can do to make this work? Also, this is time consuming in the flow. If the Spouse code is in the list then I pull the Combined Mailing Name instead of the Single Address Name.

Thanks!

Carol

Carol Grant

Hello- I figured it out and got some guidance from a search I did on finding a value within an array. I'm not sure if it's correct but it works. It still takes a long time to run. I thought I would share in case anyone tries to do this.

I had to convert my Primary Spouse Code to an array instead of a string because it told me it didn't like it as a string.

Created a Select on the single column from my Excel table and then a Join to put a comma in.

Then did an apply to each on the Sp Donor Code Array

The condition is the Join Output from above contains the item (). The item is the Sp Donor Code Array which contains the Primary Donor Code.