How to copy a sharepoint list with multiple select column in flow

(0) Share

Report

Posted on by EricXIII

There is an existed Sharepoint List, with some columns are multiple select.

Below is the Column "Role".

Building a flow to copy this sharepoint list to another, when new row is created.

In the "Create Item" action, I found it created EachLoop for the "Role" due to it is multi select items

So, the result became one original list row triggers multiple "create item action" as looped by the "role" column.

Is there any way to help me to just copy the list to anther, including the multiple select column as One item?

All responses (4)

Answers (1)

EricXIII 12 on at

Like (0)

Report

Re: How to copy a sharepoint list with multiple select column in flow

Hi Anna,

Thank you for your answering,
I finally got it, the copy list item with lookup field, indeed just like you showed above, pass id is enough.

My pervious issue seems because I went to a mess, I did' build the relevant role list in the same site, the role id link was failed to get role value.
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

Re: How to copy a sharepoint list with multiple select column in flow

@EricXIII I think in order to update lookup values, you need IDs, so please use Role ID in the creating the Array, please see below screenshot where i have field named TestLookup, and i am appending to array the lookup id
EricXIII 12 on at

Like (0)

Report

Re: How to copy a sharepoint list with multiple select column in flow

Thank you for quick reply,
As the GetItem from list add trigger, the "Role" field is as below as a multiple object,
so when I get Role in the Each Loop, actually I need the "Role Value", which is defined in PowerApps customize.
could you help to check the flow Getting Role value in the Each Loop is correct?
I get the below error message "ExpressionEvauationFailed. .. @Items(Apply_to_each_2)?[Value] is 'String'. Valid Array is necessary."
though I also tried to use string() to convert.
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Re: How to copy a sharepoint list with multiple select column in flow

@EricXIII to assign value to multi valued column you need to first create array, from screenshot it looks like you have multi value lookup column, refer to this post https://powerusers.microsoft.com/t5/Building-Flows/Updating-SharePoint-Lookup-Column-with-multiple/td-p/558443 on how to create Array for assigning value to multivalued lookup column