How to format an array of owners for the people column on Monday?

Hello everyone!

I believe I’m having the same issue as @GregG1 had in his post below.

I’ve added a Data Store app to save Monday’s ownerId for each owner’s email, and the output was 3 bundles.

Since the output was not an array, I understood I had to add another app to create an array, so I added an Array Aggregator, and the result was as follows.

Then, I took @Runcorn’s advice and mapped the array’s data, and the result was an error, cause the output was not in the format Monday expected. OMG.

So, I’ve tried a different approach, adding a Tools app to get only the IDs from the array, and using a really messy map expression (I’m not sure if it worked at all :sweat_smile: ), Monday accepted the request correctly, but the result was not as I expected, and the task on Monday received only one owner. Bummer. :smiling_face_with_tear:

So that’s why I need your help, community.
I truly believe we need a definitive and complete solution explaining how to handle this issue for future Monday integrations, so we don’t have to bother you anymore.
Anyone else agree? :blush:

I would humbly appreciate your input. Thank you in advance!

Hi @Melissa_O

Right now you’re mapping the array inside Item 1, which means Monday is expecting you to manually build Item 1, Item 2, Item 3… one by one. That’s why it’s not working as you expect.

Instead, you need to place the map at the Persons and Teams level (one level above the Item). That way, Monday will automatically create as many items as your array contains, instead of just filling one “Item 1.”

Thank you for your reply, mr.G…

I’ll try it and let you know! :blush:

Hi everyone!

So, after trying different approaches and various app combinations, going from adding and removing an array aggregator, adding a Create and Aggregate to JSON, I unfortunately was unable to find the final solution myself. As I said before, my programming skills are minimal…and for me, having to handle different output formats to match the inputs other apps needed was overwhelming. :sweat_smile:

For now, I’ve decided to force the ownerIds in the Monday app.

That’s all, folks. :blush:

Thanks!