Unanswered

Copying multiple-select choice fields (between SharePoint lists)

(0) Share

Report

Posted on by HappyPA

Hi,

I'm new to PA/JSON. Trying to copy a list in its entirety to another site. All columns except any that are multiple-select copy across successfully:

Assigned field: This is a People/Group type and sometimes there are more than one person selected here.

Browser field: Just a standard "Choice" type with multiple select available.

I believe it's because I'm using Append to variable so it's adding the data to existing values, but I don't know how to 'clear' the variable data before the next list item. Should I use something other than Append? Most guides I've seen use the Append to feature.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @HappyPA ,

multiple selection fields have a specific format for the data, multiple choice as below:

[ { "Value": "value1" }, { "Value": "value2" } ]

and multiple people picker:

[ { "Claims": "user1@company.com" }, { "Claims": "user2@company.com" } ]

To copy them between SharePoint lists I prefer to use the 'Select' action instead of a loop as explained in these two articles: multiple choice and multiple people picker.

Was this reply helpful? Yes No
HappyPA 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @tom_riha , I've followed your guide but I keep getting an error.

"The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each')' is of type 'Object'. The result must be a valid array."

Every time I select "Assigned" for the select value, it adds an Apply to each, and then when I select Assigned Email within the Select action, it adds another nested Apply to each. I'm unable to drag this outside of the apply to each. I also need to repeat the steps, for the Browser values (multi-choice also) which adds a further nested Apply to each.

Any ideas what I may be doing wrong?

Was this reply helpful? Yes No