Copy a list with multiple selection in a column

[Anonymous]

Hi,

Consider a list A, with colums A1, A2.

A1 (e.g. description) can only contain a single line of text.

A2 (e.g. department) is a lookup column which allow for multiple selections.

I designed a flow to send an e-mail once a new item is created in list A, and that copies the column values to list B.

The e-mail is send properly, but the copying provides me with a new item for each possible combination.

I have the actions (hope that translation is right): When a new item is created -> get item -> get my profile -> convert timezone -> send e-mail which all work properly.

When i add the action create item I am forced to use apply to each.This provides the following results:

A new item is created

Item id1 A1="request 10 new desks" A2=finance; HR

results in:

Item id1 B1="request 10 new desks" B2=finance

Item id2 B1="request 10 new desks" B2=HR

but I want it to result in

Item id1 B1="request 10 new desks" B2=finance; HR

(In reality i have many more columns with multiple selections which means i get a new item for each combination possible).

How do I apply the create item to each value in a column without creating a completely new entry for each value?

Thanks

[v-yuazh-msft]

Hi @Anonymous,

What is the type of B2 column in your list 2?

Please set the B2 column to a single line of text type column and create the flow as below:

Best regards,

Alice

[Anonymous]

Creating a variable sounds like the perfect solution.

I'll let you know when i get that to work. @v-yuazh-msft

Thanks!

[Anonymous]

Hi @v-yuazh-msft,

This worked well! However, the output is different from the input:

{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"City1"}{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":5,"Value":"City2"}

I tried creating a calculated column to destill only the value, but i'm not sure how to do this.

Any protips?

Kind Regards,

Wouter

[Yobeekster]

I had the same issue. Returns the {Odata....}

Where and how do you get the actual value?