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
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?
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:
This worked well! However, the output is different from the input:
I tried creating a calculated column to destill only the value, but i'm not sure how to do this.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!