Thanks @RandyHayes I'm sorted @v-bofeng-msft solution worked for me !! (sort of..) It didn't work when I used it as stated i.e in the dropdown value. but when I used it as the update value of the datacard it worked !! thanks for all your help on this one..
Sounds good. Sorry to drop the ball on responses. I get so distracted with all the posts, messages, plus regular emails, work and everything else. I try to keep on top, but sometimes the ball drops.
Glad you are sorted out now.
_____________________________________________________________________________________ Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did. NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!) Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes Really want to show your appreciation? Buy Me A Cup Of Coffee!