Answered

Copying multi-select items from one Sharepoint List to Another

(0) Share

Report

Posted on by Grewvy

Hello all,

Let me preface by saying I've spent the last 7 hours reading multiple articles on how to do this and have either gotten past the point of being able to understand this or simply have been unable to find something that matches my scenario.

I have a Sharepoint List for the 2021 Financial Year. Come March 31 2022 I will need to copy this list across to a new Sharepoint List for the 2022 Financial Year (I will filter out records I do not need after the copy is completed).

I have built a flow that will copy all data across except the "Accommodation Attributes New" field which in my form appears as:

It then appears in my 2021 list correctly; however trying to write the variables to get it copied across to my 2022 list is where I am falling over.

Step 1 consists of getting the items from the 2021 list and then initializing a variable (UnitAttributes):

Following this; I have an "Apply to Each" container with the following compose actions:

Format output is meant to take the "Accommodation Attributes New" field and remove all of the '[' and ',' etc.

Split previous output to array ideally formats the leftovers as an array but as I was receiving an error that it was being parsed as a string instead, I tried my hand at another compose action to convert that string to an array:

Following this; I have another "Apply to Each" within the same container selecting the final 'compose's output and appending the array to the variable:

The final step in my flow is to create the items in the 2022 list; with the variable "UnitAttributes" selected as the reference for "Accommodation Characteristics New":

The flow runs however the issue appears when the items are created in the 2022 list:

Unit A107 should have the attributes "1 Bedroom, East Facing, Balcony/Patio" however it seems that my flow is adding '[]'s to each item in an ascending order; and also not parsing the options list correctly.

Any advice would be greatly appreciated as my mind is starting to melt from trying to figure this out!

Cheers,

Grewvy

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-LilyW-msft on at

Like (2)

Report

Hi @Grewvy
I set up a simple Flow, you can take a try with the screenshots as below to see if it helps.
Assume my 2021 Financial Year list like this:
Flow in details:
After Flow runs,these items will be added to 2022 Financial Year list
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Grewvy 4 on at

Like (0)

Report

Hello @v-LilyW-msft,

Thank you so much for that - a lot simpler and it's working heaps better than it was originally.

While I originally had some issues with records being duplicated; and some records not being copied across if they don't have any attributes loaded against them; I managed to reorder my flow to correctly copy all items across and this is demonstrated below.

Thanks again - your help was greatly appreciated!

Was this reply helpful? Yes No
PURNA429 195 on at

Like (0)

Report
Hi @v-LilyW-msft

Thank you so much for putting this here . This solution worked. Since the images are not clear, I am uploading the images from my flow for reference .

Note :

Here my Managed Metadata Column Name is "Persona Group Test". Which allows multiple values.

The source list and destination list are part of same site and having the same schema. Both lists pointing to same termstore.

Note : Below I am adding clear images which shows the Managed Meta Data Column and Managed Meta Data Column Value. Which were used in Apply to each 2 action above.

Persona Group Test Column :

Persona Group Test Value :

Was this reply helpful? Yes No