Hi!
I have a flow that copies one list (list 1) to another list (list 2). It is triggered when a list item is created, modified or deleted.
In both lists I have a column "coordinator". When I replace the coordinator for a list item in list 1, for example, Person A leaves the company and therefore Person B takes over the ask, list 2 updates correctly and shows Person B. However, when Person A leaves but the successor is not known and therefore I delete Person A in list 1 but leave the field empty, the second list shows still Person A. If I look into the details, it seems that in the information that the flow gets from list 1, Person A is still listed, although it is not visible in the list itself.
I am pretty sure that I read the code correctly because the field in list 1 has a slightly different name than in list 2, so I can easily see that it takes the info from list 1 and not the "old" info from list 2 when it fills in list 2. Also, the flow works perfectly when I replace the name.
I hope you understand my problem. Thank you very much for your help!
Franziska