Set Variable action appends, rather than sets, string value

[BCBuizer]

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?

[eric-cheng · Accepted solution]

Hi @BCBuizer ,

Can you post a screenshot of the switch or where it sets varSourceSite and varSourceList?  

Also, can you make sure have used Set Variable instead of Append to String Variable as they both have similar inputs.   I recommend deleting and re-adding the Set Variable action back in.

Lastly, you could always clear the variable at the end of each loop but its always better to find and fix the problem.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[BCBuizer]

I was more than convinced I used "set variable" rather than "append to string variable", but I deleted and replaced the actions in the switch anyhow to rule this out. And now the flow is working :S 

Thanks though!