Is it possible to Group By First Initial without a specific column for that?

Iron Contributor

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 >  

B >  

C >  

Is this something that can be done within the Group settings or with some sort of coding without the need to create a dedicated First Initial Column? 

2 Replies

@Anthony-123 no, you'd need to create a dedicated first initial column.


Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)


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.