Monday.com | Linking subitem to item on another board

[adinap]

I have spent hours trying to get this scenario to work, so coming here for help! I have read numerous posts, help articles, YouTube videos, etc. and still can’t get the result I want.

Goal: link subitem on board A (using connected boards column) to matching item on board B

1. I search for Connect Creative status on the subitems (works fine)

2. I get the subitem details (works fine)

3. I concatenate the parent name and subitem name to match the item that was already created on the other board (works fine)
   

   

4. I use the “List of Board items” module to get a list of of all the items on board B, including name and id
   

   

5. Using “Array Aggregator” I am grabbing the id and name
   

   

6. Now I need to search for the item in that list using variable in step 3 and this is where I get stuck. The output always brings back the 1st item of that list no matter what. In my latest try, I am using “Set Variable” module
   

   
   
   Output shows a single id, but the id it brings back is not a match at all to what I want.
   
   

Instead of list boards, I also tried getting the column values from the Connect Boards column on the parent task of board A (since these items are already connected to a different column on board B) but didn’t get anywhere with that either.

Let me know any additional info you need to help me out, thanks!

[ImMichaelCannon]

Hello @adinap; why not stick a filter on name between the Monday list and array aggregator? Then the array aggregator only contains the desired entry.

Going further, change the array aggregator to text aggregator and then you have the ID you want at that point that needing that last module to extract it.

[adinap]

Thanks for the ideas. Once I added a filter, I figured out that make doesn’t like matching items that have a vertical bar | in it.

What I ended up doing is splitting up the search. 1st search finds any campaigns on board B that match the parent name on board A. 2nd search searches those results to find the name of the subitem value.

Here is my updated flow: