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.
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.
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?
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?
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?
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.
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.
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?
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!
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?
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
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.
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
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?
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!
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.
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?
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.
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.
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?
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.
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?
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.
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?
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.
@@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.
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
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
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"
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
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.
![YoungBoy Never Broke Again - Missing Everything [Official Video]](http://i.ytimg.com/vi/dTYeMZGzOzw/mqdefault.jpg)
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.
This reminds me of the old dataviews in designer only 1000 times better. Thanks April!
That's a good way to describe it! Thanks for watching!
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!
Love this new formatting. Is it possible to have the Sum in the Header so it is visible when the list is collapsed?
Loved the Grouped headers format
Me too - so happy to see that we have this ability now!
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.
I just found your channel - you rock! Is it possible to format when grouped by dates, in a smooth way?
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?
Absolutely amazing, your videos and examples make learning fun. Thank you and nice day:)
Awe thank you so much! I really appreciate it! ☺
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?
Great video. What portion of the code gets rid of the asset tag header? I'm a bit confused on that part.
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?
Thnx April for the good information
But I am searching the same for the gallery view. How do I do that?
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?
How do you get a name from a person/group column???
Amazing Tuto April. Just one question: Is there a way to change the text color on the group colored BOXES?
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.
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.
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?
Very nice video. Thank you very much...
Most welcome 😊
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!
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?
Just Wow. Very interesting. Better than microsoft Docs ^^
Wow, thanks!
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
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.
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
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?
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!
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.
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?
Thanks! Is there a way to show the group totals in the collapsed group? I've searched everywhere!
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.
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.
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?
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.
Can we change list header background colour?
🙋♂️ Hi April i,would like display title in group view, do y think it s possible thks Marc
12:20 Can you get the total sum value from PowerApps? Would be nice without doing any calculations
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?
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)
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.
Big party 🥳 🤪
:)
Great video thx!
You're welcome - thanks for watching!
Cannot find the json in the whole repo!
It's linked in the video description: github.com/aprildunnam/ListFormatting/blob/master/GroupHeaderFormatSimple.json
Are we able to mess with subgroupings as well?
Yes I've noticed that the styles you apply also apply to the subgroupings
@@AprilDunnam Is it possible to detect the underlying column to make the formatting dynamic?
Found it: @group.columnDisplayName
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?
If you use this approach for doc libraries the json view changes don’t appear to reflect in the ms teams channel files view.
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.
@@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.
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
April, could you kindly respond to my question above. I’m in desperate need of this solution. Thanks
Will groupings and aggregate functions work if the List is throttled
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
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"
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
@@AprilDunnam Thanks! It looks like my problem is that the column I'm grouping by is a Person field. Any suggestions?
Got it - needed: "txtContent": "= @group.fieldData.title",
How to reference lookup values (in case you group by lookup column)?
I'm wondering about the same. Any luck figuring it out?
@@frankRasphaug You have to use "txtContent": "= @group.fieldData.lookupValue "
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.
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.