Viewers couldn't contain their emotions as they saw Sophie Powles reprise her role in Emmerdale for one last time.