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.
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!