Sounds like dirty/corroded contacts in the passenger window switch.
You could take it out and try and clean the contacts, or try temporarily swapping your working drivers side switch to see it that makes a difference.
Depending on age/model you would probably be able to source a cheap replacement at a breakers or flea bay.
Sound I’ll try that first sounds nice an easy an I’ll let you no 👌👌Ok so it's unlikely that both driver and passenger door switches are faulty,
just to rule it out try a 20min battery disconnect/re-connect, sometimes you find software gremlins cause this sort of issue