Forum Discussion
Is it possible to Group By First Initial without a specific column for that?
I have a List of employees where I'd like the option to present a collapsed grouping of first initials (and maybe last initials). This list is essentially used as our company contact list. A > ...
As mentioned by RobElliott you "have to" create a new column for first initial in the list.
Depends on the column type and format you have used for employee names, you may able to fill in the values in first initial column automatically using calculated column or power automate flow or power apps customized form.
Then you can apply grouping on this column and remove column name from group header.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.