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.
@emmanuelmaceda24753 жыл бұрын
This reminds me of the old dataviews in designer only 1000 times better. Thanks April!
@AprilDunnam3 жыл бұрын
That's a good way to describe it! Thanks for watching!
@aragaocb2 жыл бұрын
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!
@jennifergrauer63533 жыл бұрын
Love this new formatting. Is it possible to have the Sum in the Header so it is visible when the list is collapsed?
@robinjamesnjarlely3 жыл бұрын
Loved the Grouped headers format
@AprilDunnam3 жыл бұрын
Me too - so happy to see that we have this ability now!
@Zim543 жыл бұрын
Very nice video. Thank you very much...
@AprilDunnam3 жыл бұрын
Most welcome 😊
@MsAnarea3 жыл бұрын
Absolutely amazing, your videos and examples make learning fun. Thank you and nice day:)
@AprilDunnam3 жыл бұрын
Awe thank you so much! I really appreciate it! ☺
@RPAChampion3 жыл бұрын
Big party 🥳 🤪
@AprilDunnam3 жыл бұрын
:)
@williamdaniels97286 ай бұрын
Great video. What portion of the code gets rid of the asset tag header? I'm a bit confused on that part.
@veloenbladefist22 күн бұрын
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?
@divyankraj71682 жыл бұрын
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?
@ScottRosenbloom2 жыл бұрын
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-ox6st1ux5n10 ай бұрын
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?
@abcemilyxyz2 жыл бұрын
How do you get a name from a person/group column???
@amycoleman26283 жыл бұрын
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.
@anthonyleduc2 жыл бұрын
Just Wow. Very interesting. Better than microsoft Docs ^^
@AprilDunnam2 жыл бұрын
Wow, thanks!
@cvkealey2 жыл бұрын
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.
@andyolb3 жыл бұрын
Great video thx!
@AprilDunnam3 жыл бұрын
You're welcome - thanks for watching!
@fanzfanzilla10 ай бұрын
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.
@okidipekimbambo2 жыл бұрын
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?
@espeolguin2 жыл бұрын
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
@jaggyjut2 жыл бұрын
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!
@chrisbare45473 жыл бұрын
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?
@Kondziurek2 жыл бұрын
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?
@stefaancorthals38372 жыл бұрын
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?
@FSchimidtBR2 жыл бұрын
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?
@jollyonlan2 жыл бұрын
12:20 Can you get the total sum value from PowerApps? Would be nice without doing any calculations
@AnandavadivelanV3 жыл бұрын
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
@ChristyInDenver2 жыл бұрын
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.
@ing11472 жыл бұрын
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?
@vishalpise18942 жыл бұрын
Can we change list header background colour?
@jessicaleska92102 жыл бұрын
Thanks! Is there a way to show the group totals in the collapsed group? I've searched everywhere!
@brandiwoodson26882 жыл бұрын
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!
@TTeamFan3 жыл бұрын
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.
@yehunlavolontededieu3223 жыл бұрын
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.Caldwell3 жыл бұрын
Are we able to mess with subgroupings as well?
@AprilDunnam3 жыл бұрын
Yes I've noticed that the styles you apply also apply to the subgroupings
@hokki283 жыл бұрын
@@AprilDunnam Is it possible to detect the underlying column to make the formatting dynamic?
@hokki283 жыл бұрын
Found it: @group.columnDisplayName
@aaaaa6012 жыл бұрын
🙋♂️ Hi April i,would like display title in group view, do y think it s possible thks Marc
@mohammedsuheb47932 жыл бұрын
Is it possible to create "2 tier" header in sharepoint lists???
@simonvoigt91452 жыл бұрын
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?
@learnalittleeveryday78483 жыл бұрын
If you use this approach for doc libraries the json view changes don’t appear to reflect in the ms teams channel files view.
@AprilDunnam3 жыл бұрын
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.
@learnalittleeveryday78483 жыл бұрын
@@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.
@EricAkawie3 жыл бұрын
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"
@AprilDunnam3 жыл бұрын
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
@EricAkawie3 жыл бұрын
@@AprilDunnam Thanks! It looks like my problem is that the column I'm grouping by is a Person field. Any suggestions?
@EricAkawie3 жыл бұрын
Got it - needed: "txtContent": "= @group.fieldData.title",
@iamthedon113 жыл бұрын
Will groupings and aggregate functions work if the List is throttled
@AprilDunnam3 жыл бұрын
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
@hokki283 жыл бұрын
How to reference lookup values (in case you group by lookup column)?
@frankRasphaug3 жыл бұрын
I'm wondering about the same. Any luck figuring it out?
@viviamb3 жыл бұрын
@@frankRasphaug You have to use "txtContent": "= @group.fieldData.lookupValue "
@Mkt60403 жыл бұрын
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
@Mkt60402 жыл бұрын
April, could you kindly respond to my question above. I’m in desperate need of this solution. Thanks
@youdagoob2 жыл бұрын
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.
@AprilDunnam2 жыл бұрын
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.