Great collaborations? Well, Queen/David Bowie's Under Pressure was a good one. My personal favourite is Pet Shop Boys/Dusty Springfield What Have I Done To Deserve This? (from 1987).

In a similar vein to Duran Duran/Tove Lo, New Order did a great single relatively recently that featured Elly Jackson (La Roux) on backing vocals called Tutti Fruiti.