Announcements
Hi,
Wanting to use Proper() to tidy addresses but it changes NW, SW, NE, SW etc. to Nw, Sw, Ne Sw, is there is a function to keep uppercase words like that but correct the rest?
Hi @Sighman ,
Powerapps does not have a similar function.
You could use Proper() function first then use Substitute() function .
This needs hardcode to save the address.
Best Regards,WearskyIf my post helps, then please consider Accept it as the solution to help others. Thanks.
Unfortunately substitute() won't work as it tends to mess up other words...eg. 23 Swift Lane will end up as 23 SWift LaNE....
I was hoping to not have some massive if() statement using endwith()...but that looks like my only solution
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 405 Super User 2026 Season 2
Mohsin Ali 368
WarrenBelz 244 Most Valuable Professional
