Combining multi-choice fields from 2 lists

(0) Share

Report

Posted on by CU13011633-0

I have a Flow that looks up 2 lists and gets the 2 multi-choice fields in a Select action and I have them displaying in Arrays like this:
Select Action 1:
[
{
    "Name": "Test1"
},
{
    "Name": " Test2"
},
{
    "Name": " Test3"
}
]

Select Action 2 (This one gets put in a ""For Each" control for some reason):
[
{
"Name": "Test4"
}
]
How can I combine these into one so that I can use it to Update item in a SharePoint list?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Ellis Karim 11,735 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @CU13011633-0,

You can use the union function to merge these two arrays. You can also refine the data by selecting the Switch to Map mode in the Select action to select just the values:

union(body('Select'),body('Select_2'))

Ellis Karim

Blog: https://elliskarim.com

Was this reply helpful? Yes No
CU13011633-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi EKarim,

I had to switch "Name" to "Id", so my Select actions look like this:

Compose looks like this:

I think I need my Compose to look like this:

[
{
    "Id": "90"
},
{
    "Id": " 1"
},
{
    "Id": " 3"
},
{
    "Id": " 2"
}
]

So that I can use it to update a Multi-Choice field in a SharePoint list.

Is this possible to make it format that way?

Was this reply helpful? Yes No