The actor auditioned six times to play Glinda the Good Witch, a role that eventually went to Ariana Grande