I have soft water, and the best controlled-suds seems to be Persil Biological Powder. I was quite surprised that I could put in 60, 70, 80 ml and the suds weren't filling the door glass.
If I had tried that with Lidl 'Formil' powder, foam would be gushing out the powder drawer.
As for liquids...