web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Management of people n...

Power Apps

Unanswered

Management of people names in upper and lower case

(0) Share

Report

Report

Posted on by Ventit

422

I have a need to structure certain names based on certain products. For example one product has to be MacDonald and another has to be MacDONALD.

There quite a few names that fit these parameters and I have about 1500 names in all formats being entered monthly by just as many people. Unless I have some sort of formula managing this Human Error abounds.

Has anyone dealt with automating this problem in their apps?

I am toying with creating a separate table with names that get matched returns the standard, but if there is a formula out there would be better. Any ideas

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Ventit ,

You could do this

With( { wMac: Left( Lower(YourText), 3 ) = "mac", wMc: Left( Lower(YourText), 2 ) = "mc" }, With( { wRem: Upper( Right( YourText, Len(YourText) - If( wMac, 3, 2 ) ) ) }, If( wMac, "Mac" & wRem, wMc, "Mc" & wRem, YourText ) ) )

but watch out for Mackay, Mace etc OR make a list you can add to as you go . . .

Was this reply helpful? Yes No
Ventit 422 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Warren, as you note the variables are significant in this and I guess the only real way to accept the odd Human error. My issue with that is I also allow for a DIY by the clients besides our team members. Add to this the Client is served at three levels each with a different approach to what they want on this. The one that simply wants all upper is my favorite 🙂

Was this reply helpful? Yes No

Join the conversation