Updating SharePoint List Multi-select column with data from an array

[hollyg]

I am creating a flow to populate a multi-select column (Region Team) in SharePoint list A based on data from SharePoint List B.

SharePoint List A (SP-A)

SharePoint List B (SP-B)

Connects site to Region

Here is my flow so far

I can get the list of regions in the array.  

How do I update the multi-select Region column in SharePoint List B with this information.

Thank you for your help.

Holly 

[ivan_apps]

You might have an extra set of brackets you need to remove so that it can read your options. It should probably look like this:

[

{Value: "test"},

{Value: "test2"}

]

[hollyg]

@ivan_apps Thanks! What do I need to change to get rid of the brackets?  Sorry, I am pretty new to this and have figured out this much from YouTube and community posts.

[ivan_apps]

Without knowing what the results are after each of your actions it’s hard to know where it needs to be fixed.

Lets say your get items properly retrieved all necessary records you need. Is your multi-select column in list A of type lookup or choice? The way you format the data would be important because a reference to another list would be different than the way you choose multiple choices.

for example choices may need to take this format:

[{Value: ‘Test}]
whereas lookups would likely need an ID as well:

[{ID: 1, Title: ‘test’}]

as you are looping through your get items, you would simply compose an object in the right json format. Then append that compose object to a string variable. 
your string variable would then be a proper array with several objects inside of it.

i can try to verify the above steps in a flow myself, but I’d need to know the column type of RegionTeam