Updates from one list applied to another list (multiple fields)

%3CLINGO-SUB%20id%3D%22lingo-sub-1754410%22%20slang%3D%22en-US%22%3EUpdates%20from%20one%20list%20applied%20to%20another%20list%20(multiple%20fields)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1754410%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20two%20lists%20-%20the%20first%20is%20the%20master%20list%2C%20the%20second%20has%204-5%20columns%20of%20the%20same%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20make%20updates%20to%20the%20first%20list%20and%20have%20them%20repeat%20on%20the%20second%20list%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20matching%20value%20for%20each%20item%20across%20each%20list.%20But%20the%20updates%20could%20be%20to%20all%20the%20fields%20and%20I%20don't%20just%20have%20one%20set%20value%20-%20I%20have%20around%20100.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaster%20List%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EName%26nbsp%3B%20%26nbsp%3B%20Surname%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BRoom%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BPool%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BNotes%3C%2FP%3E%3CP%3EJohn%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Smith%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20A3%20Barclay%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%204%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BWords%2C%20words%2C%20words%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20data%20above%20is%20already%20on%20List%202%2C%20but%20if%20the%20room%2C%20pool%20or%20notes%20were%20updated%20in%20the%20Master%20List%2C%20is%20there%20a%20way%20to%20%22copy%22%20that%20to%20List%202%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20any%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1754410%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eitems%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi

 

I have two lists - the first is the master list, the second has 4-5 columns of the same data. 

 

Is there a way to make updates to the first list and have them repeat on the second list? 

 

I have a matching value for each item across each list. But the updates could be to all the fields and I don't just have one set value - I have around 100. 

 

For example - 

 

Master List

 

Name    Surname     Room               Pool     Notes

John      Smith          A3 Barclay        4           Words, words, words

 

The data above is already on List 2, but if the room, pool or notes were updated in the Master List, is there a way to "copy" that to List 2?

 

Thanks for any help!

 

1 Reply
Highlighted

@HW_Magd Do you want to update an existing item? In that case, you need to identify that item somehow. The master list would have to have the ID of the item in the copy, so the copy can be looked up.

You can then us Power Automate to update the item in the copy list. Get the values for all columns from the master list item. You cannot just update ONE field. But that doesn't matter, because if a field content stays the same, it will not be recorded as a change and it won't show as a change in the version history.