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
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
Creating a variable sounds like the perfect solution.
I'll let you know when i get that to work. @v-yuazh-msft
Thanks!
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?
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!
User | Count |
---|---|
45 | |
42 | |
37 | |
36 | |
23 |
User | Count |
---|---|
40 | |
39 | |
30 | |
29 | |
29 |