SharePoint List Formatting for Grouped Views

[@R01202]

Thank you April! I'm commenting from work just to let you know how helpful this kind of information is for my current scope of projects. I have almost zero coding experience, but I am in a position where I have an opportunity to make enormous improvements to some of my company's processes using SharePoint lists. Looking forward to applying what I learned here to deliver much needed results.

[@emmanuelmaceda2475]

This reminds me of the old dataviews in designer only 1000 times better. Thanks April!

[@AprilDunnam]

That's a good way to describe it! Thanks for watching!

[@aragaocb]

Great video! I was able to make an accordion with a list using this, then put it on a page, looks really nice. Thank you!

[@jennifergrauer6353]

Love this new formatting. Is it possible to have the Sum in the Header so it is visible when the list is collapsed?

[@robinjamesnjarlely]

Loved the Grouped headers format

[@AprilDunnam]

Me too - so happy to see that we have this ability now!

[@Zim54]

Very nice video. Thank you very much...

[@AprilDunnam]

Most welcome 😊

[@MsAnarea]

Absolutely amazing, your videos and examples make learning fun. Thank you and nice day:)

[@AprilDunnam]

Awe thank you so much! I really appreciate it! ☺

[@RPAChampion]

Big party 🥳 🤪

[@AprilDunnam]

:)

[@williamdaniels9728]

Great video. What portion of the code gets rid of the asset tag header? I'm a bit confused on that part.

[@veloenbladefist]

If I have a list that has existing JSON formatting, am I able to simply append the headerFormatter to the top of the JSON to include it into the formatting I have already?

[@divyankraj7168]

Can we Use columnAggregate.value in the headerFormatter? Is there a way we can show the aggregate value in the header as well as the footer?

[@ScottRosenbloom]

Hey April! Thanks for this video! Is there a way to not only group the FIRST level of a "group by column", but a SECOND level of a "group by column" as well?

[@user-ox6st1ux5n]

Hello teacher, I would like to ask how to update the contents of the attachments column in SharePoint (there are multiple contents in the attachment) to json format for storage?

[@CyNiT]

Thnx April for the good information But I am searching the same for the gallery view. How do I do that?

[@abcemilyxyz]

How do you get a name from a person/group column???

[@amycoleman2628]

Hi April. Working with group headings, but don't want the heading to be selectable or collapsible. Thinking of using this in a web part scenario and would only want the group headers to be there as labels, not actionable selectors. Is this option available. Also, when working with list views in web parts, is there a way to hide the "See All" option within your list webpart view? If we embed into the page, for user experience it would be nice to turn off the "See All" link to users. Thanks for this video, it was super helpful in understanding the grouping better.

[@Kinosei30]

Isn't it possible to change the background color of the entire section the grouping creates? If I have colored each row, there will be this white gap between each group.

[@anthonyleduc]

Just Wow. Very interesting. Better than microsoft Docs ^^

[@AprilDunnam]

Wow, thanks!

[@cvkealey]

Hey, April! Do you know if it's possible to have multi-level groupings in a gallery view using this functionality? For context, I'm using a document library to display photos as part of an art show. Basically, each image is tagged with the name of the artist and a "collection" (they will submit 3 collections, each with three photos). I can get a gallery view to group by the artist name, but it's ignoring the second 'layer' of grouping.

[@andyolb]

Great video thx!

[@AprilDunnam]

You're welcome - thanks for watching!

[@fanzfanzilla]

Thank you for all the helpful videos. These videos are very helpful. I have one question that I cannot figure out to resolve. Does anyone know how to set the column widths in lists? If I adjust the size of one of the columns it just defaults back to original size next I visit the list.

[@okidipekimbambo]

Amazing Tuto April. Just one question: Is there a way to change the text color on the group colored BOXES?

[@rachelweller1071]

I have a grouped list of committee members which includes their O365 details. I would like to add functionality to email just the people within the Group within the list using the email field. Any suggestions?

[@espeolguin]

Hello, I just created a SharePoint list with lookup columns, but when I try to use it in the mobile version, the look up column was not available - read only. Is there a way to make it work? Now I am creating drop down columns to replace the lookup column, but I need the correct formula or JSON code to obtain the auto populate that the lookup column was doing before. Any help will be greatly appreciate it

[@jaggyjut]

Superb. What if we want to build parent and sub-list. For example a contractor details in the parent and then certification, license detials with expiry dates as sublist

[@jackiesullivan6589]

I love your JSON videos! I used the code you provided on github to remove the column header from the grouping. Can you help me with what the JSON code would be to put the group count in parentheses, i.e.: Tablets (12). TIA!

[@chrisbare4547]

Hi April, thanks for all you are doing. Most of it is still over the top for me but I', learning a lot. Just a quick question. Is it possible to add or subtract values in separate columns and show the difference in another column?

[@Kondziurek]

Interesting info! What if list contains multiple grouping? Is it possible to refer to each of them separately or the only way is to format all of them at once like in the video?

[@stefaancorthals3837]

Hello, I would like to show all groups in a view, even when a certain group doesn't have any matching items, so the group would be empty but the group would still show up. Any advice how to do this?

[@FSchimidtBR]

Great video! April, is there a way to select which column I want to display in each group? Using your list as an example, let's suppose I wanted to display the "Serial number" column only when the Accessory or Laptop groups are expanded and the "Order #" column only when the Printer or Smartphone groups are expanded. Is there a way to achieve this using JSON?

[@jollyonlan]

12:20 Can you get the total sum value from PowerApps? Would be nice without doing any calculations

[@AnandavadivelanV]

Hi April, any way to override the sorting order that happens default inside the Group by? I want to sort by another column instead but Group by takes priority it seems.

[@kayleekasapis2343]

What would cause my list to have multiple groupings of the same item?For example it would say... Asset : Laptop (3) and Asset : Laptop (1)

[@AprilDunnam]

What type of field are you grouping on? Typically that's because of a difference in spelling. This is especially true if it's an open text field but sometimes even in choice fields if the options have been changed. Sometimes trailing spaces before or after accidentally get added.

[@mkt65361]

Cannot find the json in the whole repo!

[@AprilDunnam]

It's linked in the video description: github.com/aprildunnam/ListFormatting/blob/master/GroupHeaderFormatSimple.json

[@ChristyInDenver]

Thanks April for the great video. Do you know what json element to use to sort the groupings in descending order. I've tried "group-dir": "desc" but can't get it to work. Hope you can help.

[@ing1147]

if u have a column that contains mutliple choices for each cell (eg. apples and oranges for 1 cell, another cell contains only apples, and another cell contains oranges), how do you group the data to show a header for apples and a header for oranges?

[@vishalpise1894]

Can we change list header background colour?

[@jessicaleska9210]

Thanks! Is there a way to show the group totals in the collapsed group? I've searched everywhere!

[@brandiwoodson2688]

Is there a way to do JSON to hide the views drop down? I have searched everything to hide views from visitors so they don't switch it and can't find anything for SharePoint Online lists. Starting to drive me nuts!

[@TTeamFan]

Like this, it's so useful. However, I have a list which is formatted as gallery cards, does this group header formatting work with the gallery card formatting? In trying it out, the card formatter seems to work perfectly but the groupformatter looks as if it's ignored - the group header isn't formatted anyway.

[@yehunlavolontededieu322]

Hi April, Could you please confirm if the list formatting for birthday-format is still applicable? Not working. Mainly the Date picker . To show the proper date i have to pick from the date picker calendar, but that's not realistic HR can't click click/scroll up to pick 1980, So, when I enter 6/161980 manually by default, it'd show December 30 in the calculated column for all entry. I edited/played with the date and time setting... no avail. How can I enter a date manually ? And the ones I'd picked from date picker, at times it shows "No Birthday Entered" or shows the correct date in the birthday card. Also it doesn't show a picture. So, yea Date and picture aint working. Thanks in advance.

[@Ryan.S.Caldwell]

Are we able to mess with subgroupings as well?

[@AprilDunnam]

Yes I've noticed that the styles you apply also apply to the subgroupings

[@hokki28]

@@AprilDunnam Is it possible to detect the underlying column to make the formatting dynamic?

[@hokki28]

Found it: @group.columnDisplayName

[@aaaaa601]

🙋‍♂️ Hi April i,would like display title in group view, do y think it s possible thks Marc

[@mohammedsuheb4793]

Is it possible to create "2 tier" header in sharepoint lists???

[@simonvoigt9145]

Great video, thanks a lot! I am looking for a simple JSON Script to deploy 2 views (grouped and sorted) in a SiteDesign to Lists and Libraries. Can someone help?

[@learnalittleeveryday7848]

If you use this approach for doc libraries the json view changes don’t appear to reflect in the ms teams channel files view.

[@AprilDunnam]

This won't work with the native Teams files or the "Document Library" option in Teams. A work-around would be to use the "SharePoint" data source option instead and reference your document that way. List formatting will come through then. Hopefully that makes sense.

[@learnalittleeveryday7848]

@@AprilDunnam thanks for the reply. Yes I thought as much. It seems to maintain the json for other lists , non doclibs, if you use the lists app/tab in ms teams.

[@EricAkawie]

This is great, but do you think you could provide a "Hello World" example, where all you do is remove the column name? If I try to remove all of the specific "If" statements, I wind up with the Header reading "object Object"

[@AprilDunnam]

Sure. I added a new file to my Github Repo called "GroupHeaderFormatSimple". All it does is remove the header. Hope it helps: github.com/aprildunnam/ListFormatting/blob/master/GroupHeaderFormatSimple.json

[@EricAkawie]

@@AprilDunnam Thanks! It looks like my problem is that the column I'm grouping by is a Person field. Any suggestions?

[@EricAkawie]

Got it - needed: "txtContent": "= @group.fieldData.title",

[@iamthedon11]

Will groupings and aggregate functions work if the List is throttled

[@AprilDunnam]

Typically groupings and aggregates start to break when you exceed the threshold. To get around it you'll want to adjust the list settings and created filtered views

[@hokki28]

How to reference lookup values (in case you group by lookup column)?

[@frankRasphaug]

I'm wondering about the same. Any luck figuring it out?

[@viviamb]

@@frankRasphaug You have to use "txtContent": "= @group.fieldData.lookupValue "

[@Mkt6040]

Great video by the way. Could you kindly advise or provide an already modified json to only remove the repetitive columns e.g hide Asset type? Also unlike your example, I have grouped twice e.g Asset type and then Manufacturer. I tried to use your json and modified it but it's not showing what how I want it. All I would like to do is to remove the repetitive columns in both groups e.g Asset type and Manufacturer and just show the value of the column. Would really appreciate your help. Thanks

[@Mkt6040]

April, could you kindly respond to my question above. I’m in desperate need of this solution. Thanks

[@youdagoob]

This is all great... until I want to embed the final beautifully formatted list as a web part into a page. Then all formatting goes bye bye.

[@AprilDunnam]

Can you share more about what it's doing and how you're embedding it? Because that's not expected behavior, list formatting is supported in the list web part on pages.