cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jmathur
Helper I
Helper I

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

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. 

 

Capture1.PNGCapture2.PNGCapture3.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User II
Dual Super User II

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

 

Capture.PNG

 

Regards,

Reza Dorrani

 

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

View solution in original post

8 REPLIES 8
RezaDorrani
Dual Super User II
Dual Super User II

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

@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
Dual Super User II
Dual Super User II

Hi @jmathur 

 

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

 

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
Dual Super User II
Dual Super User II

@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

 

Hi @RezaDorrani 

 

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.   

 

Capture1.PNGCapture2.PNGcapture1a.png

capture2a.png

 

capture3a.png

RezaDorrani
Dual Super User II
Dual Super User II

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

 

Capture.PNG

 

Regards,

Reza Dorrani

 

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

View solution in original post

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

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (17,091)