Flow: Update main list from diferent lists based on UniqueID (not the standard ID)
I am having trouble with creating this flow.
I have 5 lists: A,B,C,D,E - all of them are the same. There are 2 columns that we need to focus:
1) ID - standard ID field
2) MyID - ID we made to have real unique ID between lists. Formula: [ID] & [ListName]
There is also main lists - that combains all records from those 5 lists above. Here comes the problem:
When I try to make flow that updates main list - based on MyID (the only possible value) - I can only choose [ID] - the standard ID witch will be diferent. For example: First record from list A has ID = 1. and MyID = 1A, but this record on main list has ID= 3, and MyID = 1A.
How can I make flow that identyfy rows by MyID instead of ID