Announcements
I've got a SharePoint list that is pulling in data from another source.One of the columns is 'ManagerName' and is formatted LastName/FirstName, and appears as 'Schmoe, Joe'.Can I create a SP calculated column that will transpose the above to 'Joe Schmoe' AND be able to pull that data into a Power Apps Label or Text Input?
Hi @Phineas ,
Please avoid SharePoint calculated columns - they simply do not "play well" with Power Apps. You can do the calculation in Power Apps with
Last( Split( ThisItem.ManagerName, ", " ) ).Result & " " & First( Split( ThisItem.ManagerNam, ", " ) ).Result
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
I'm using a LookUp to Label1.Text to pull in the original text 'Schmoe, Joe'.If I create another label (Label2.Text) and add your formula the names are reversed as desired.Can this be achieved as part of the LookUp in Label1.Text, rather than needing to create another Label for the reverse code?My LookUp is - LookUp('List1', FullName = UserNameFld.Text,ManagerName)
This should do it
With( { wManager: LookUp( 'List1', FullName = UserNameFld.Text ).ManagerName }, Last( Split( wManager, ", " ) ).Result & " " & First( Split( wManager, ", " ) ).Result )
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 514
WarrenBelz 419 Most Valuable Professional
Valantis 295
