You’re offline. This is a read only version of the page.
65
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 , I can't believe I didn't see this sooner. Thank you so much.
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
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.
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 ,
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).
Hi @jmathur
If the column types are multi select - are the values(options) of both the multi select fields in SharePoint the same?
@RezaDorrani Thanks for that. However:
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.
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
Regards,
Reza Dorrani
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
