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.
Solved! Go to 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
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
@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
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).
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
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.
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
28 | |
27 | |
20 | |
10 |