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

Like (0) Share

Report

Posted on 4 Feb 2021 04:57:36 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?

I have the same question (0)

All responses (4)

Answers (1)

EricXIII 12 on 05 Feb 2021 at 02:00:30

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.

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on 04 Feb 2021 at 12:34:02

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

Was this reply helpful? Yes No
EricXIII 12 on 04 Feb 2021 at 07:45:21

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.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on 04 Feb 2021 at 06:05:58

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

Was this reply helpful? Yes No