Updating list from diferent lists based on unique ID

%3CLINGO-SUB%20id%3D%22lingo-sub-2081445%22%20slang%3D%22en-US%22%3EUpdating%20list%20from%20diferent%20lists%20based%20on%20unique%20ID%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2081445%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20run%20out%20of%20ideas%20of%20how%20to%20fix%20my%20problem.%20I%20would%20like%20to%20have%203%20lists.%20Lets%20name%20them%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EListA%26nbsp%3B%3C%2FP%3E%3CP%3EListB%3C%2FP%3E%3CP%3EListMain%20-%20combaining%20records%20from%20ListA%20and%20B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20idea%20is%3A%3C%2FP%3E%3CP%3E-%20Anytime%20something%20new%20is%20created%20on%20List%20A%20or%20List%20B%20it%20is%20copied%20to%20ListMain%20-%20this%20works%20fine.%3C%2FP%3E%3CP%3E-%20Anytime%20something%20is%20updated%20-%20it%20should%20also%20be%20updated%20on%20ListMain%20-%20and%20this%20is%20the%20problem%2C%20since%20the%20%5BID%5D%20column%20is%20not%20unique%20and%20does%20not%20match.%20(There%20is%20a%20row%20with%20ID%20%3D%201%20on%20both%20List%20A%20and%20List%20B.%20)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20though%20I%20need%20to%20make%20new%20columnt%20on%20all%20lists%20named%20%5BUniqueID%5D%20that%20insted%20of%20%5BID%5D%20%3D%201%2C2%2C3%2C%20etc.%20stores%201A%2C2A%2C3A%20for%20List%20A%20and%201B%2C2B%2C3B%20for%20List%20B.%20With%20this%20i%20would%20be%20able%20to%20update%20any%20record%20in%20MainList.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20use%20power%20automate%20I%20can%20only%20use%20standard%20%5BID%5D%20to%20update%20my%20MainList%2C%20and%20it%20doesn't%20work%20correctly.%20Any%20ideas%20how%20to%20approach%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2081445%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, 

 

I run out of ideas of how to fix my problem. I would like to have 3 lists. Lets name them

 

ListA 

ListB

ListMain - combaining records from ListA and B

 

The idea is:

- Anytime something new is created on List A or List B it is copied to ListMain - this works fine.

- Anytime something is updated - it should also be updated on ListMain - and this is the problem, since the [ID] column is not unique and does not match. (There is a row with ID = 1 on both List A and List B. )

 

I though I need to make new columnt on all lists named [UniqueID] that insted of [ID] = 1,2,3, etc. stores 1A,2A,3A for List A and 1B,2B,3B for List B. With this i would be able to update any record in MainList.

 

When I use power automate I can only use standard [ID] to update my MainList, and it doesn't work correctly. Any ideas how to approach this?

 

Best regards

0 Replies