Hi Everybody,
I have a destination list that receives items from several source lists using PA. Since those flows can't remove items in the destination list when they are deleted in the source list, I was thinking to build a scheduled flow that checks if the items in the destination list still have a corresponding item in the source list:
This flow loops through all of the items in the destination list sets three variables to retrieve the corresponding item from the sources list:
varSourceSite: string type, set in the switch using "set variable" action where the values are hardcoded
varSourceList: string type, set in the switch using "set variable" action where the values are hardcoded
varSourceID: integer type, as in the image using "set variable" action (converts Identifier to ID)
In the first loop all is working well, but from the second loop things are not going as expected. For the varSourceSite and varSourceList, the values are appending rather than replaced, so if the value was "ListA" on the first loop, it will look like "ListAListB" on the second where I would expect it to be "ListB". This continue in the third loop until finally the flow errors out.
Anybody have any ideas if I'm doing anything wrong or how to work around this?
