Man I just want to say you have been my number 1 content creator for Sharepoint. I really hope you continue to put out content regularly. The videos you have are absolute gold, keep ‘em coming!
I'm starting a new job and a key part is designing and managing the new company Sharepoint - after watching quite a few videos now I have to say yours are definitely some of the best! I love your attention to detail and showing what can be achieved! Please keep posting videos!
Thanks for such a nice comment Melanie, very much appreciated! Congrats on the new job and the exciting challenge 🎉 if you need to brainstorm please feel free to reach out 👌
This is wonderful! I've been managing SharePoint sites for years and I still picked some major design tips. Thank you so much for the great video. Please continue the SharePoint content.
Excellent!! This is truly a first class video in every way; 10 super useful and applicable practical tips. Each tip clearly and concisely articulated with just the right level of detail, well presented throughout with great tempo and pitch! Honestly, you are THE benchmark presenter in your subject. So glad I found and subscribed to your channel. Thank you.
This was INCREDIBLY helpful - I am a Senior Executive Assistant who started a new job recently and want to help move the Management Team away from tracking docs in Excel/Word. I want to make the user experience as friendly as possible and have just used a bunch of your steps in the SP List I am currently building - fingers crossed that they will be receptive to this different interface LOL :)
Hey Monica! Congrats on the new job! I'm delighted you have found the tips helpful. I'm sure they will be receptive and if not at first, no doubt you will show them the light! ;-) Best of luck in the new role!
These are great tips, and make a big difference! Thanks for sharing the drag and drop to get things categorised on the form (tip #5), that is awesome 🤩
This is brilliant ! Thank you so much - I loved your video and will definitely watch more of your content. In fact I think I am going to sign up for your SharePoint course as well. Thank you again for these great Lists tips!
It is super useful video, rewatching and applying, I just want to mention that adding emojis to link type of column, it somewhat seems to mess with the links in content area...
Fantastic thank you. I create/manage a lot of lists and I'm glad to see I have been doing the majority, even the emojis. BUT, guilty I add a comments column! I will be having a word with my Team and we will be using the native comments going forward 🤩 Please keep the amazing content coming 🤓🤩
One thing about the native comment feature is that I can't export it to Excel, which my company prefers for reporting. Is there a way to export version history and/or the comments history? That would be fantastic.
Hey Stephen! I'm not aware of any UI driven method to do this however, if you are open to working with PowerShell (the one ring to rule them all!), you can achieve this. Full disclosure, I personally have not done this before yet! Maybe give it a shot and lettuce know how you get on? 😁
Hey! I'm not aware of how to achieve that I'm afraid. The first column locks in place with the new list experience but after that I think we are out of luck. Would certainly be a nice feature. Maybe somebody else can chime in with a better answer!
Hey Mens, great to hear from you again! Sure I could, could make it short and snappy too so it's not feature length ;-) anything specific you had in mind?
Wow! This is really interesting and well presented! You have a new follower 👍 I am starting a new job and SP is my main tool. Do you have a video on how to search/filter on many directories and sub-directories by any chance? Many thanks 😊
Hey thanks for that! Content Types and customising the search experience through the 'Search and Intelligence' options are good ways to do this. I'm thinking of a video on that very subject. Watch that space (very soon!) 😁
Hey there. There is no concept of folders within lists. Saving filtered views would probably be your best bet, or you could go a step further and create a nice site page UI front end for the list that acts as a nav page for each view in the list... that could be very nice! ;-)
Regarding the "form layout", that has been a major source of frustration for me. I've found that certain columns will simple NOT appear in the group or order I specify. There's no rhyme or reason as to which types of columns that don't behave, although it seems a bit more prevalent with "multiple line of text" columns. On rare occasions, opening the list in another browser or private window will make it work (so, could be a caching problem), but more often than not, they simply don't want to budge.
That sounds really annoying. Can't say I've noticed it on my end but I'll run some tests and see if I spot anything. I'll report back as soon as I have something to report! Keep the faith, SharePoint can test even the most patient of people at times! ;-)
@@Academy365-Dan I *think* it happens more often with lists or libraries to which I've added a site or tenant content type. So, it may have something to do with the content type publishing process.
Great tutorial, very helpful. One question to section 5.: I edited the details view, but my colleague seems to have a different layout. What could be the root cause? Best regards, Alexander 13:33
Yes, he does see the same Fields in the details view, but under different categories. Also, he does not see the icons I put in front of the coloumn names...
@@Academy365-Dan Yes, he does see the same Fields in the details view, but under different categories / the last category. Also, he does not see the icons I put in front of the coloumn names...
Hey! Have you added a column which captures employee ID? Out of the box, the only columns containing a user would be the 'Created by' and 'Modified by' columns. Showing specific columns in certain situations would be achieved by creating a list/library 'View' (the 9th point on my list). A view can be created as either 'Public' or 'Private'. If Public, anyone with access to the list can use the view. If Private, it will only be available to the user who created it. There is no real concept of targeting views to specific users or groups. You could achieve that through pages and embedded list views, effectively creating a user experience which "guides" users to the correct view. If you go to my site academy365.io and send me a message from there I can reply with more guidance than a YT comment will allow for! 💡
Thank you for this video. Great information. I am just getting started with lists and forms. I have one list that has a major horizontal scroll issue. Is there a way to have a lookup list that has all of the same options for every row in the original list but it can be customized? Essentially I am trying to track which software add ons each requestor has approved. The list of available add ons is the same but each requestor or row in the main list can have different ones
For the List view formatting/field for “View”, I’m attempting to do the same idea for a Site Pages library, particularly for the Page Details/Properties so that the user can click the icon on an item and view the metadata (page properties) as we have turned our SOPs into Pages. For the users view, I’d like to provide both a button for the user to view the SOP page, and the other button to view the properties. Is this possible? Thanks again!
Hey! Yes, you have different 'action' properties available to you. The action 'defaultClick' will open the page, whereas 'editProps' will open the properties panel. Here is a reference which goes into more detail than YT comments will allow me to ;-) learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/formatting-syntax-reference#customrowaction
Hi @Academy365-Dan, I am desperate to understand if we could use lists to work as a PIM (Product information management) which I think its possible after watching bunch of your videos, where we create product information but the question is the assets. Our goal is to have a folder with photos like, photoshoot photos of ambient or ecommerce products, and when someone searches for one SKU they can find all the images related to that SKU, even if one image has 3 SKU's in ambient..
Hey! I think there could be many solutions to this. One might be to have a "sister" document library where you have a folder for each SKU containing the images. You could then link to this folder from the the product row in the list. Another option would be using a custom search method with the PnP Modern Search Web Parts. This would be a lot more advanced but potentially worth the investment of time to figure out if this is supporting a core process within your business.
Hey, you cannot hide the default 'All items' view or make it permission-based. An alternative approach could be to delete it. However, you would need to specify an alternative view as 'the default' for the list first. Only then can you delete the 'All Items' view
@@Academy365-Dan Thanks for your reply. Here is the scenario I wish to build. Would appreciate any guidance on this. Wish to have a master database in a view for which only admin will have access. The other views (filtered based on a specific column in master view) needs be visible to all who have read access.
So sorry I missed this comment! I'm not sure I understand the requirements. Can you give me some more detail? When you create a new list from within 'Site Contents' you should see an option to create 'From CSV'. That may be an option?
Hey Dan, thanks for these awesome tips and hello from Cork 🙂 Any idea on how to implement the view details column for document library? Instead of showing me the details of my metadata it opens the file :-/ I looked at the JSON and it seems the action is "defaultClick". I thought maybe there's another action so I went to the schema url at the beginning of the code but didn't find anything other than custom action, maybe? Also, Your blog doesn't have the code for the "Edit" column we can see in your list.
Hey there! Try using the action "action": "editProps" as opposed to 'defaultClick'. That should give you what you are looking for. Apologies for that, I'll update the blog, thanks for the heads up! Hope you are getting better weather down in Cork than we are up here, it's been miserable! Love Cork, beautiful part of the country 😁
Hey Dan, I'm applying a lot of your great tips to a document library. I created several site columns that I'm using to populate some file metadata. I'm leveraging Document sets as it helps maintain the metadata once and cascades to all files part of said document set. I was trying to organize my metadata by categories inspired by what you did in your list for the row details panel. Unfortunately, hitting new in a SharePoint library doesn't cut it and I don't see how I can modify the layout to create my categories. Any idea?
Can you cover how to make the ID Field in the list another column field data. I have a column field titled invoice number. I would like each each invoice number to be the ID field for the sharepoint list in each form - which would be a the identifier instead of ID #