3:29 when I literally watched my eyes fall out of my head... (wait...no that can't be right!). But very cool and stakeholder lieutenants to keep the piece(data sanity) is fantastic. Great content. You're an underrated content creator!
Thank you! I have been using Managed Metadata in our SP libraries & lists for years and never realized that users can create terms from the library/list without going first to Term Store. I’ve been reluctant to open the Term Store to less disciplined users. This may be the ticket!
Awesome job on the delivery. Love the style and energy. Superb job. I look forward to reaching this standard with my video presence. Ps looking forward to our Power Platform collab 😎
Thanks for sharing this, it really opened my eyes to better data collection. How about a video on using meta data on views/reporting? Grouping in views and how SP meta data can be used in Power Bi.
Thanks for the short summary. Can the data displayed be structured differently, i.e not using : as the separator? Are there any drawbacks with filtering, grouping by, and is it possible to apply styling to the options similar to a choice pill?
Out-of-the-box you can't style Managed Metadata like you can a choice pill, BUT Managed Metadata does support JSON styling if you want to get fancy and go that route: learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#supported-column-types You can do top level Group By (parent of the managed metadata. i.e. "Brand" ) but I haven't tried it with the child ("model"). Feel free to reach out on LinkedIn: www.linkedin.com/in/sean-astrakhan/
Hello 1:36 you said there’s a very good reason not to use Add Column on the list and you’d explain at the end but didn’t could you let me know please . Also how do users change the options in an easy way please
Great video, thank you. I've been grappling with the design of content management in SP to support a complex, but relatively small, department. I think I'll try to blend in some managed metadata to go with my usual list & lookup columns combo. SP is famously tricksy when it comes to keeping limitations in mind for any given feature. Do you have any rules of thumb to help prevent frustrations down the road? e.g. MM columns can't be the source for a lookup column, and can't readily be added to a calculated column formula.
Heyo! Glad it helped. I wouldn't say there are many rules of thumb specific to SharePoint, but rules of thumb for building in low code solutions in general. I'm happy to share more resources on that if you're interested.
@Untethered365 If you know a way for me to build cascading lookup columns, you could be my hero. I've requested an app that would add this functionality, but SP is new in our organization, and they're awfully cautious about approving app store requests.
I'd love to use Managed Metadata in a List, but cannot figure out how to manipulate it through Power Automate. Request if there is a better solution than 'Send an HTTP request to SharePoint', which I believe has been deprecated by my company's M-365 contract. If not, request what function resides in the purple 'fx: body(...)' box.
as a site collection admin and part of the sharepoint "owner" group of a particular site. I don't have the option to create more than one site level term group. The "new group" option isn't there. I am able to add term sets and terms and even rename the term group. Is there some other permission thing I'm not considering?
Great video, thanks. But a quick question: in your example how would you ensure users picked the child term rather than simply picking "Apple", "Samsung", etc?
I haven't tried that one but i don't remember an OOTB way to do it. A workaround could be a calc column that validates if the MM column has at least 2 values or something to that effect.
@SeanAstro I'm really not sure you can use a calculated column that way (happy to be proven wrong though!) My solution to a similar problem (i.e. two related choice columns) is to have one choice column with both values. e.g. "Apple - iPhone", "Apple - iPhone Mini", "Samsung - Galaxy S", "Samsung - Galaxy M", etc. It prevents "bad data" and is also easier to process in PowerApps/Flow.
@@chap666ish creative! Sounds perfect for your context. The only downside I see is if you get more and more nested it'll require making a lot of options, and you miss out on some UI perks like only displaying the child value (not full path) or having users choose their values.
@@Untethered365 Indeed. It's definitely not a replacement for hierarchical managed meta data(!) but it's handy for small-ish data sets and solves the problem of users only choosing the parent-level term.
I'm struggling with my managed metadata in a document library. The metadata is stored against the file, so if we send the file out to a developer (IT won't give access to third parties) when the file comes back the managed metadata is broken and overwrites the existing data against the document with blanks. If anyone has any tips on this I'd appreciate hearing them because we might have to default over to Choice columns to take the burden of re-adding metadata off my team 😔
A big problem with this is that there is now no simple way to filter your list by brand. For example, the way you have done it, there is no simple way to filter the list to show only the users who bought an Apple product. To filter the list to show only the users who bought an Apple product, you would need to add each individual Apple product to your filter. Getting around this problem would require that you add two tags for each item---both the lower-level tag and the higher-level tag. For example, as well as the 'Apple:iPhone' tag, you would also need to add the 'Apple' tag. But this really clutters up the options when you go to filter and also reintroduces the very problem you were trying to solve (because someone could add both the 'Apple:iPhone' tag and the 'Samsung' tag to a single row).
That's a great callout IF you have a lot of variations in your choices. If you don't then clicking twice for "Samsung:Galaxy" and "Samsung:Nexus" is a better alternative than inconsistent data. I agree it would've been a great addition to the video to reconsider MM if you have a lot of variations in choices. Thanks for sharing!
REALLY easy to follow thank you...But when I went through the steps and clicked 'ok'.... I click NEW and no options for a new column pops up like it does in your video...why is this! ???
And it IS possible to migrate a site column from a specific site collection to the Content type gallery. It will require a short PowerShell script, but it is better than not being able to use the site column on multiple site collections 😂
I'm here trying to still understand the benefit to Metadata. Maybe I have not heard of actual scenarios where this makes sense to me. I'm sure there are scenarios where they do and maybe I'll run into them as more experience comes my way. but the examples I've seen in video tutorials so far don't really make sense to me. I get so much more done, and faster, with simple validation. for example, in your first scenario, isn't it faster, easier, and more effective to enter a simple validation on the "phone model" columns to only show the relevant ones depending on the selection of the phones brand? (2 seperate sub menus and only show the relevant one). If im working on a big app that will be using complicated and long formulas many times (the same ones), then it makes sense to use something like classes, but I don't see how all these steps can save time when a validation takes 10 seconds. On your # 2, a simple "other" option with an extra "text" field and same validation as before will allow for user to enter other inputs not listed. I understand you still have to click 2 buttons into the choice column settings and add the new users "other" input into the choices yourself, but the metadata approach is no different; you definitely don't want users to have the freedom of adding choices that everyone else to see (as we all know what this will lead too... more work), so having approvers is the best practices choice here, making the process the same at that point.
I appreciate the detailed answer! How are you planning on making and maintaining 2 separate sub menus? When you say classes can you expand? Having approvers as "best practice" doesn't apply for non mission-critical data with ongoing choice changes based on the users themselves.
@@SeanAstro Yes, but the only way I found was to launcher a daily flow to store manager metadatas directory in a SharePoint List and call this list directory in the App. It works great but is quite complicated.
What a ridiculously and typically Microsoft unintuitive and complicated way to do such a barebones yet crucial thing. Between this, Teams, Lists, Loop, Planner For Loop In Teams, Teams For Planner in Project In Teams In Loop - MS is making organisational teamwork and secure file management an absolute joke. I wonder in the future how many times confidential information will be publicly available due to the new Microsoft Minefield way of working.
"Minefield" is absolutely the right word for it. Luckily, Lists & Teams is all just SharePoint behind the scenes but it is super tricky to make sense of it in combination with the other products.
You're a natural teacher, high quality lessons learned here, thank you!
Appreciate you!
I had no idea that "Managed Metadata" was even a thing in SP! wow!! 🔥🔥🔥🔥
Right! They lump it the bottom of the list of options but it's sooo helpful.
3:29 when I literally watched my eyes fall out of my head... (wait...no that can't be right!). But very cool and stakeholder lieutenants to keep the piece(data sanity) is fantastic. Great content. You're an underrated content creator!
😂😂 glad it helped!
Thank you! I've been trying to figure out what managed metadata list were for years! Great simple explanation.
Thank you! I have been using Managed Metadata in our SP libraries & lists for years and never realized that users can create terms from the library/list without going first to Term Store. I’ve been reluctant to open the Term Store to less disciplined users. This may be the ticket!
Glad it was helpful!
Awesome job on the delivery. Love the style and energy. Superb job. I look forward to reaching this standard with my video presence. Ps looking forward to our Power Platform collab 😎
Thanks! This one is rare in such high post production but I'll try and keep it up.
Thanks for sharing this, it really opened my eyes to better data collection. How about a video on using meta data on views/reporting? Grouping in views and how SP meta data can be used in Power Bi.
Grouping in Views is creative! I've been focusing on Dataverse videos but may switch to this topic soon :)
This is incredibly helpful!!!!!!!!!!!! Thank you so much, I've been looking for something similar for weeks. 🙌🏽
Glad to hear!
Thanks for the short summary. Can the data displayed be structured differently, i.e not using : as the separator? Are there any drawbacks with filtering, grouping by, and is it possible to apply styling to the options similar to a choice pill?
Out-of-the-box you can't style Managed Metadata like you can a choice pill, BUT Managed Metadata does support JSON styling if you want to get fancy and go that route:
learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#supported-column-types
You can do top level Group By (parent of the managed metadata. i.e. "Brand" ) but I haven't tried it with the child ("model"). Feel free to reach out on LinkedIn:
www.linkedin.com/in/sean-astrakhan/
Also terms are multi-language so you can for a given term value add the correspondent translated value for the same term in other languages :)
I didn't know that! Version 2 of this video needs that. Thanks!
Very interesting and presented! You have 1 more follower 👍👍👍 Thanks!
This is amazing !
Hello 1:36 you said there’s a very good reason not to use Add Column on the list and you’d explain at the end but didn’t could you let me know please . Also how do users change the options in an easy way please
It's in the free training link. We're releasing it next month if you want to sign up.
Great video, thank you. I've been grappling with the design of content management in SP to support a complex, but relatively small, department. I think I'll try to blend in some managed metadata to go with my usual list & lookup columns combo.
SP is famously tricksy when it comes to keeping limitations in mind for any given feature. Do you have any rules of thumb to help prevent frustrations down the road? e.g. MM columns can't be the source for a lookup column, and can't readily be added to a calculated column formula.
Heyo! Glad it helped. I wouldn't say there are many rules of thumb specific to SharePoint, but rules of thumb for building in low code solutions in general. I'm happy to share more resources on that if you're interested.
@Untethered365 If you know a way for me to build cascading lookup columns, you could be my hero. I've requested an app that would add this functionality, but SP is new in our organization, and they're awfully cautious about approving app store requests.
Loved it. One question
While adding data I clicked on Return to Classic. How can I get back to the normal previous view. Anyway I can disable it
You should be able to refresh or clear cache
I'd love to use Managed Metadata in a List, but cannot figure out how to manipulate it through Power Automate. Request if there is a better solution than 'Send an HTTP request to SharePoint', which I believe has been deprecated by my company's M-365 contract. If not, request what function resides in the purple 'fx: body(...)' box.
What if you'd like to separate Brand and Model with managed metadata? Or must they be chosen together at a go?
That's kind of the point is to have them nested but for display you don't have to show the whole path
I love this!
as a site collection admin and part of the sharepoint "owner" group of a particular site. I don't have the option to create more than one site level term group. The "new group" option isn't there. I am able to add term sets and terms and even rename the term group. Is there some other permission thing I'm not considering?
Great video, thanks. But a quick question: in your example how would you ensure users picked the child term rather than simply picking "Apple", "Samsung", etc?
I haven't tried that one but i don't remember an OOTB way to do it. A workaround could be a calc column that validates if the MM column has at least 2 values or something to that effect.
@SeanAstro I'm really not sure you can use a calculated column that way (happy to be proven wrong though!)
My solution to a similar problem (i.e. two related choice columns) is to have one choice column with both values. e.g. "Apple - iPhone", "Apple - iPhone Mini", "Samsung - Galaxy S", "Samsung - Galaxy M", etc. It prevents "bad data" and is also easier to process in PowerApps/Flow.
@@chap666ish creative! Sounds perfect for your context.
The only downside I see is if you get more and more nested it'll require making a lot of options, and you miss out on some UI perks like only displaying the child value (not full path) or having users choose their values.
@@Untethered365 Indeed. It's definitely not a replacement for hierarchical managed meta data(!) but it's handy for small-ish data sets and solves the problem of users only choosing the parent-level term.
I'm struggling with my managed metadata in a document library. The metadata is stored against the file, so if we send the file out to a developer (IT won't give access to third parties) when the file comes back the managed metadata is broken and overwrites the existing data against the document with blanks. If anyone has any tips on this I'd appreciate hearing them because we might have to default over to Choice columns to take the burden of re-adding metadata off my team 😔
I have list of 410 and need to do them in groups, is there a way to do it in bulk? coz if I do it one by one it'll take ages.
A big problem with this is that there is now no simple way to filter your list by brand. For example, the way you have done it, there is no simple way to filter the list to show only the users who bought an Apple product. To filter the list to show only the users who bought an Apple product, you would need to add each individual Apple product to your filter. Getting around this problem would require that you add two tags for each item---both the lower-level tag and the higher-level tag. For example, as well as the 'Apple:iPhone' tag, you would also need to add the 'Apple' tag. But this really clutters up the options when you go to filter and also reintroduces the very problem you were trying to solve (because someone could add both the 'Apple:iPhone' tag and the 'Samsung' tag to a single row).
That's a great callout IF you have a lot of variations in your choices. If you don't then clicking twice for "Samsung:Galaxy" and "Samsung:Nexus" is a better alternative than inconsistent data. I agree it would've been a great addition to the video to reconsider MM if you have a lot of variations in choices. Thanks for sharing!
Great video, thank you very much
Glad you liked it!
How would you create a group by brand view when using managed Metadata in the way you used it?
I'd have to tinker with it, if I get time I'll hop on it.
1:34 Add column vs. site column?
@@moyura2 video on that coming out tomorrow!
REALLY easy to follow thank you...But when I went through the steps and clicked 'ok'.... I click NEW and no options for a new column pops up like it does in your video...why is this! ???
It's just video editing most likely :)
Buy if you want to surface a managed metadata column in a canvas app, then there doesn't seem to be any control for that.
And it IS possible to migrate a site column from a specific site collection to the Content type gallery. It will require a short PowerShell script, but it is better than not being able to use the site column on multiple site collections 😂
Hey Kasper great thought - I've been dragging my feet on making a Content Type video but I may just pull the trigger :)
How do you add the column to the list ?
What about Power Apps?
I'm here trying to still understand the benefit to Metadata. Maybe I have not heard of actual scenarios where this makes sense to me. I'm sure there are scenarios where they do and maybe I'll run into them as more experience comes my way. but the examples I've seen in video tutorials so far don't really make sense to me. I get so much more done, and faster, with simple validation. for example, in your first scenario, isn't it faster, easier, and more effective to enter a simple validation on the "phone model" columns to only show the relevant ones depending on the selection of the phones brand? (2 seperate sub menus and only show the relevant one). If im working on a big app that will be using complicated and long formulas many times (the same ones), then it makes sense to use something like classes, but I don't see how all these steps can save time when a validation takes 10 seconds. On your # 2, a simple "other" option with an extra "text" field and same validation as before will allow for user to enter other inputs not listed. I understand you still have to click 2 buttons into the choice column settings and add the new users "other" input into the choices yourself, but the metadata approach is no different; you definitely don't want users to have the freedom of adding choices that everyone else to see (as we all know what this will lead too... more work), so having approvers is the best practices choice here, making the process the same at that point.
I appreciate the detailed answer! How are you planning on making and maintaining 2 separate sub menus? When you say classes can you expand? Having approvers as "best practice" doesn't apply for non mission-critical data with ongoing choice changes based on the users themselves.
I'm trying to apply this to my site pages.. but I can't seem to get it to work..
Any further details :)
How does this work if ure using power apps as the way to add data and not the sp form
I am also wondering about this very thing? I hope there’s a response
Has there been an answer to this question? I am interested as well.
any way to get in contact with you ?
Just be carefull as there is a 20 items limitation when you try to use managed metadata in a Powerapps forms.
Too bad...
Great call out! Did you find using them in Powerapps forms fairly straightforward?
@@SeanAstro Yes, but the only way I found was to launcher a daily flow to store manager metadatas directory in a SharePoint List and call this list directory in the App.
It works great but is quite complicated.
Wait this just help me to help another Fortune 500 😂
I hope they give you a cut of that fortune :)
What a ridiculously and typically Microsoft unintuitive and complicated way to do such a barebones yet crucial thing.
Between this, Teams, Lists, Loop, Planner For Loop In Teams, Teams For Planner in Project In Teams In Loop - MS is making organisational teamwork and secure file management an absolute joke. I wonder in the future how many times confidential information will be publicly available due to the new Microsoft Minefield way of working.
"Minefield" is absolutely the right word for it. Luckily, Lists & Teams is all just SharePoint behind the scenes but it is super tricky to make sense of it in combination with the other products.