cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Anonymous
Not applicable

 

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

Anonymous
Not applicable

Creating a variable sounds like the perfect solution.

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

 

Thanks!

Anonymous
Not applicable

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

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

 

Where and how do you get the actual value?

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (8,738)