cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Copy a list with multiple selection in a column

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

5 REPLIES 5
Highlighted
Anonymous
Not applicable

Re: Copy a list with multiple selection in a column

 
Highlighted
Community Support
Community Support

Re: Copy a list with multiple selection in a column

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:

Capture.PNG

 

Best regards,

Alice

Highlighted
Anonymous
Not applicable

Re: Copy a list with multiple selection in a column

Creating a variable sounds like the perfect solution.

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

 

Thanks!

Highlighted
Anonymous
Not applicable

Re: Copy a list with multiple selection in a column

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

Highlighted
Frequent Visitor

Re: Copy a list with multiple selection in a column

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

 

Where and how do you get the actual value?

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (6,908)