Does having a AWS solution architect professional certificate adds value in an interview ??

No idea. Might help your resume get shortlisted. To do well in interview you should be able to answer their questions on cloud services. If interviewer is expecting a good depth of understanding and experience with cloud, certification won't mean anything. Almost everyone has some certification listed in their resume. It might just help in showing that you are curious to learn and upskill.