Hello,
I have a gallery from a SharePoint site and there is a people picker field (person or group) where users can assign tasks to themselves. I can display the user name in the gallery without issue, but cannot figure out use the Split function to only show the first and last name. For example, the field I'm pulling is ThisItem.AssignedTo.DisplayName, which results in Doe, John (XXX-California). The XXX-Calfornia represents the part of the organization and region of the user. I want to only show Doe, John.
When I use the Split or Left/Split functions, it gives me an error saying Expected Text Value.
Examples:
Any suggestions on how to do this? Thanks!
Solved! Go to Solution.
Try the following:
First(Split(ThisItem.AssignedAT.DisplayName, "(")).Result
Try the following:
First(Split(ThisItem.AssignedAT.DisplayName, "(")).Result
User | Count |
---|---|
225 | |
101 | |
93 | |
56 | |
30 |
User | Count |
---|---|
288 | |
116 | |
109 | |
62 | |
58 |