web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Combining multi-choice...

Power Automate

Suggested Answer

Combining multi-choice fields from 2 lists

(0) Share

Report

Report

Posted on by CU13011633-0

2

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Ellis Karim 11,940 Super User 2026 Season 1 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

Join the conversation