Apply multiple values from choice field to separate fields in File Update command

[jmathur]

I am building a flow that copies documents from one SharePoint site to another. In Site 1, I have a multiple selection choice column called Related Products. I want the flow to take each value selected, and tag the Related Products column in Site 2 with all of those values. I use Get Items and Select actions to tell the flow how to identify which values Site 2 should be updated with. Currently, the flow accurately identifies each value, but udpates Site 2 with only one value from Site 1. I think it is overwriting the other values with the most recently updated value from Site 1. How do I get it to apply each value selected in Site 1 to the mapped value in Site 2? 

See attached images. The conditions after Create file do not affect the Apply to each 5 action. 

[RezaDorrani]

Hi @jmathur 

It is beause you are looping through the array and updating the same item each time

check this blog for how to add multi select choice field

https://veenstra.me.uk/2019/04/01/microsoft-flow-update-a-multi-select-choice-field-in-a-sharepoint-...

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[jmathur]

@RezaDorrani Thanks for that. However:

• I am trying to get Site 2 to update its identical multi select choice field to match the corresponding one in Site 1 
• Site 1 will not always have the same values in its mulit select choice field selected. Site 2 needs to update with whatever values Site 1 has input into it. 

When I apply the setup in the link you provided, it does jam those values into the mapped column for Site 2, but Site 2 is not applying the values to its multi select field. 

Is there a way to Compose a variable instead of text? I run into an error complaining of needing an array, not a string, but there's no way to initialize variables in the lower levels of a flow, which is where I am implementing the work.  

[RezaDorrani]

Hi @jmathur 

If the column types are multi select - are the values(options) of both the multi select fields in SharePoint the same?

[jmathur]

Hi @RezaDorrani ,

Site 1 has 3/4 defined values in Site 2 (I've recreated the values in Site 1 to match Site 2 based on what users of Site 1 will need). 

[RezaDorrani]

@jmathur 

Ok share screenshots of your current Flow with the latest updates 

Highlight if any errors in Flow

Also, share screenshot of column type and data in both the SharePoint lists

I will try recreate the scenario at my end tomorrow

[jmathur]

Hi @RezaDorrani 

I really appreciate the help. 

Since opening the thread, I've changed which Property I'm testing this on (I will eventually need to do Related Products but I want to do the same thing on Content Distribution Rules, which has far fewer choices that are possible to select from than the former). 

To review, my goal is to have a user be able to update a metadata tag in a document library on Site 1 with any configuration of choices from a multi select choice field and have the mirrored document in the document library in Site 2 be updated with the same choices. Both Site 1 and Site 2 have the same column (Content Distribution Rules) and share three of four choices ("A", "B", "C"). In my example, the document I am testing on is trying to update the mirrored document in Site 2 with options A and C.   

[RezaDorrani · Accepted solution]

Hi @jmathur 

when you do get item for source library

it will give you the multi choice field value as dynamic content 

In my example I have a column called multi in document library source and destination

All I did is directly applied the value from the multi column to the destination library item

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[jmathur]

@RezaDorrani , I can't believe I didn't see this sooner. Thank you so much.