Syncronize 2 lists by a field that is NOT the ID field

[Calcioscacchi]

Hi there,

To start a new project I need to syncronize two lists. 

First step, I need to take all data from the first list to the second one, by using the "BigBag" field as key. 

Suppose to have this list as List1:

BIG BAG MATERIALS
BigBag	Material
1	A
2	B
3	C
4	D
5	E
6	F
7	G
8	H
9	A
10	B
11	L
12	M
13	N
14	O
15	A
16	A
17	A
18	D
19	C
20	E

I need to bring the materials in this second table (List2):

LINES SUPPLY MAP
Linea	BigBag
Cast 3	6
Cast 3	20
Cast 3	5
Cast 3	4
Cast 4	1
Cast 4	2
Cast 4	3
Cast 4	4
Cast 5	7
Cast 5	8
Cast 5	16
Cast 5	4
Cast 6	13
Cast 6	10
Cast 6	12
Cast 6	9
Cast 7	14
Cast 7	11
Cast 7	13
Cast 7	9
Cast 8	19
Cast 8	18
Cast 8	17
Cast 8	16
Cast 8	15

I try with GetItems+Update Item but the connector asks for the ID, I don't know how to tell him to copy and paste the value using "BigBag" field. 

Please note that in the second step I have to build a flow that will syncronize the BigBag details, so when a row from List1 is edited, new values had to be syncronized in the List 2 using "bigBag" filed as key.

Some help? 

Thanks!

[wyattdave]

Have you consider setting the big bag column (LINES SUPPLY MAP) as a look up column to the (BIG BAG MATERIALS). It will require copying data over into a new column but after that will automatically show the value you need with no need for a flow.

https://support.microsoft.com/en-gb/office/create-list-relationships-by-using-lookup-columns-80a3e0a...

>--------------------------------------------
If this helped solve your question please mark it as the solution.

I also do a weekly Power Platform blog at https://dev.to/wyattdave

[BCBuizer · Accepted solution]

Hi @Calcioscacchi ,

For a one off activity, this is how I would do it:

Not the prettiest, but it will get the job done.

Here are the inputs in text format, but you need to make sure all actions in your flow are name exactly as in the screenshot for them to work:

@{outputs('Get_items_-_Lines_Supply_Map')?['body/value']}

BigBag eq '@{items('For_each')?['BigBag']}'

@{outputs('Get_items_-_Big_Bag_Materials')?['body/value']}

@{items('For_each')?['ID']}

@{items('For_each')?['Title']}

@{items('For_each’)?[BigBag']}

[Calcioscacchi]

Thats works perfectly. 

Thankyou!