 get things started and good morning to everyone hello how's everybody doing good morning sir what's up the mic here I you know we're talking about movies here briefly before we get started here but I had a rare occurrence here like I bought over the weekend well and arrived how retro sorry what's that there's an acronym there I didn't quite know so this is you can tell what it is this is obscure mid 80s this is that it's a it's a double album so I'm trying was trying to find their first time fruer and they morphed and became the band underworld and in the early 90s they had a couple really big singles and then they kind of changed the lineup and they are the modern underworld which is more dance music guitar driven with Carl Hyde and and Rick's Darren and Merson yeah well he left yet but after what two albums three albums or something like sure early on but but yeah so anyway well hello and welcome everyone to another episode of the Microsoft community office hours where we will be discussing all things Microsoft 365 if we must if we must that's what we are we're you know phone to do answering questions from the community my name is Christian Buckley of an office apps and services MVP and regional director based in Lehigh Utah and I'm the Microsoft go-to-market director at point and oh hey he joined earlier joining me today are Sean McDonough a consultant with Bitstream Foundry in Cincinnati Ohio and an office apps and services MVP Mike Nelson a solutions architects with pure storage in a cloud of data center management MVP based in Appleton Wisconsin Hal Haas-Dettler a senior field engineer with Roland Chorin Tower in Tucson Arizona and an office apps and services MVP Eric Riz founder and CEO of empty cubicle and an office apps and services MVP based out of Toronto Canada we have Sherry Oswald hello Microsoft certified trainer Microsoft Office Master and co-founder of power up learning in Colorado Springs Colorado and we have Dr. Neil Hoskinson a Microsoft Senior Program Manager and and if anything goes wrong with any Microsoft technology he's our punching bag yes hello Dr. Neil well it's great to see all the the happy smiling faces this morning any anything exciting going on today this week yeah virtual marathon hello that's right if you're not familiar to the Microsoft 365 virtual marathon going on this week and so I've got a session tomorrow I should probably look you should know that that's a very important thing to know yeah and check time zones when you're looking so that you know which time zone you should be you know in but it's free so people should go sign up and a lot of great content I've got tweet jam happening tomorrow as well my sessions on Wednesday I have a session was it yeah well tomorrow hopefully most of you I know Mike doesn't care about this stuff but it's the it's whether customers are still asking which tool to use when and so would I not care about that Christian I you know so I I so let me let me let me go backwards on that I'll claim that question back to do a telephony it's got nothing to do with SharePoint so well it could be SharePoint related and people have questions that they're confused about it's the question like well I've got SharePoint why do I need teams or I'm using teams why do I need SharePoint what's this Yammer thing still doing here when do I use one drive kind of all those questions and that was a question that was discussed a lot frequently and a Microsoft hated here in that there was the messaging that they came out with a couple years back which was the inner loop outer loop to help explain when you shift between tools yes another analogy yeah I actually liked that messaging but I like that I still use that depending on yeah so do I so with that I think it's let's do the official theme music for Mike's Microsoft 365 message center that's that that's an all-new low there for Christian I don't know even what about the disclaimer oh yeah we should we should start with the disclaimer here for people are watching the live stream so yes that's you know just make sure that legally we're covered here no puppies were harmed in the making of this webcast as far as we know all right okay so yeah so let's go through some new Microsoft message center updates along with a couple roadmap items that are compiled for today anybody know what the GCC is or the GCC high is Neil you can't answer this okay everybody knows you're all shaking your heads with a Sean looks confused as always but it's GCC is the government cloud right so you have a government cloud and then you have something called a GCC high which I guess is like you know it must be super secret classified yeah I did a lot of work with I did a lot of the Department of Defense so these are the people defending our country so yeah it's probably Skynet too right yeah the NSA bugging phones all that kind of fun stuff yep so they're making a whole bunch of stuff available on the roadmap this past week they like there's a barrage of things that are being enabled but they're only being enabled in the government cloud and they're things that I think that should be enabled for everybody but for some reason they're all GCC or GCC high they're not hitting the general the general public cloud you will they gotta fill this guy's a bone I'll tell you they they have such a little down version of Office 365 maybe yeah maybe it's a budget cycle where they they're trying to get you know some government cash flowing in and say I don't know but what they're doing is a couple things but I'll go over the message center thing and then I'll hit the roadmap a little bit later but the exchange admin center I don't know if everybody's used the EAC but sometimes it can be like really somewhat confusing and it's gone through years and years of iterations but it's gotten better they're actually creating a whole new portal now so it's gonna be like brand new they're taking all the classic out of there and they're actually gonna have the migration assistance so they're actually adding a tenant to tenant migration wizard and an automated G Suite migration wizard personalized dashboards and insights and all this other kind of phone stuff so it's really turning in from more of a hey we kind of hodgepodge this together from the on-prem exchange center admin and we put it together and now we're we're actually putting some really good functionality into it but once again they're only giving it to the GCC and the GCC high hopefully that will change so there's another thing that's coming down the pipe here that I wanted to come up with is that you can set an audit office with Microsoft Teams now so why did this take so long please help me understand this you're talking about an office product and they're now coming out with this update that allows you to set out of office within teams matters for out of office yeah I just I'm not quite understanding a collaborative tool that you could never set you could do that with Skype why couldn't you do it with teams and I guess yeah it's one of those things where I'm just kind of shaking my head so we are we finally seeing parody with Skype is that what we're talking about yeah yeah pretty much you know it just it just seems really weird it's kind of like this next one too because who knew that in Microsoft Forms what's what it's one of the biggest pet peeves you have with Microsoft Forms name one just name one pet peeves I know I love everything so the fact that you have quizzes and you can't post the score from the quiz questions into a SharePoint list it doesn't do the role I'm I'm going much more basic than that all right does anybody realize that you can't even change the font like from bold to italics to underline you can't add bullets you can't add numbering anything so basic in an editor you can't do that doesn't come purple yeah now they're actually adding the ability to do text formatting in Microsoft Forms I always I mean I have filled that I have created forms and it always kind of like upset me that I couldn't like I wanted to bold something oh no you can't bold I'm like what this is a Microsoft app I can't bold something in a Microsoft app come on why why doesn't just doesn't not just have that rich editor capability why can't I add an image or a if I want to have a short video like you can attach content yes so you can have post a link or attach content to go outside that but what if I want to is part of my quiz part of the test part of the survey you know point to like a short video on YouTube that explains the the topic or gives a background and then ask the question yeah these are all things that's what the subtitles for that's what the subtitles for to explain the depth of the question title and a subtitle I missed that yes you can use that in your 2020 productivity tips it is Wednesday by the way I was making sure you and I weren't competing with each other again all right keeping up with the same keeping up with the Joneses theme we're going on here they've actually put it a ability to prevent attendees from sharing video feeds and teams you know I think other collaboration tools have had this for like years the ability to turn off other people's video feeds as a presenter but you know like hey how you're having a bad hair day yeah right right yeah you can't you know so that's actually coming coming to be a real thing along here yeah question don't pick on the fall only challenged okay it's really just inappropriate there's a little bit there that's why I wasn't poking fun at Sean all right so and this one coming from the department of this meeting could have been an email exchange online we're gonna get back to that by the way yeah it is it's a huge department in Microsoft so by the Bill and Melinda Gates Foundation by the way so a new command let to make meeting shorter by default so they're actually created a PowerShell commandlet that will go through all of your meetings and make them shorter yeah so if you make a meeting 60 minutes it'll drop a few minutes off the ending of the meeting so when you go over you're even more over now I had to laugh at this one because I'm like really people do people even even even stick to team meeting times I mean they always everybody used to say hey you know what you start at 15 minutes past the hour you end up at 15 minutes to the hour and everybody seems more productive well now now you can set as an admin you can set a global policy to shorten everyone's events so is every word global policy Mike for eliminating the words I'm going to give you X minutes back now this is a huge yeah it's right next to the one where you're on mute so if you give me 15 minutes back it's because you didn't plan properly and now you messed up my whole day and possibly yeah and maybe even my month your thanks Mike does it like shorten every single meeting in the calendar so what if like for example if a lot of my meetings are set up by external people right like this one for example yeah you know this is this is set up by Christian so if I run this PowerShell command or this PowerShell policy thing is executed against my mailbox right which has my calendar items in it does it include shortening external events are just the ones I own you know it just says your events that's all the detail it gives it says with this command that you can end your events a few minutes early so I have a feeling it's only events that you create now does it say that does it say that in bold or so let me take the other position like I actually like this feature I know it's it's not a big mind blowing thing it's part of the so I read about this last week so I knew it was coming but there was an article that I've got I think I actually have it open somewhere in a browser looking at the various tips and things that I might add into my session this week around the kind of the wellness and you know the you know work from home changes the adaptations this is something it's not so much about the fact that it ends five minutes early it's that you know so then you get the five minute warning five minutes earlier it's just it's prompting people to it's trying to build in automation you don't have to do it you don't have to leverage that but it's prompting people to take a little more time to take breaks in between meetings the reality is that we schedule things back to back to back to back that's how my days are set up all of our days are set up and and there's often not enough time even with the five minute warning to adjust you know change direction get ready for that next meeting and so it's giving you another tool to to kind of force you to take that break to recognize hey I need to have a couple minutes to go refresh the ice cubes in my beverage container here sitting on my desk or well just get rid well yeah and they give an example here they said right so for example you can make all meetings under 60 minutes start late with a five minute break and then all meeting 60 minutes or over start late with a 10 minute break yeah so what they're saying is if you have back to back to back meetings you know you start with a five minute break so at least you get to go do those things but this is this is org wide this is for everyone in your organization and yeah some folks you know I see problems with this I mean I see I see an issue if an admin decides hey I'm gonna enable this for everybody not everybody's gonna be in line with this whole why is my meeting started 605 setting like the reminder like you can determine how much of a reminder you want by default why isn't that at the core of it it's a human problem you're trying to use technology to solve a people problem and that's you know you're just gonna be even more skewed down I'm just gonna start scheduling 65 minute meetings that'll solve that problem about 63 and a half or something in your favor collect 200 yeah so the meeting that the variation in time is set by the admin so you can put like two minutes in there you can put like 10 minutes in there you can do whatever but that could get I mean I don't know I wouldn't want to be the admin that actually if a month's thought I mean that that's gonna turn into a very long day yeah especially if it's like other five minutes yeah especially if it's like a global company wide policy because you might want people I mean as my CVP gonna be happy by suddenly cramp his meeting times and well probably actually but you know what I mean it's like because some people meetings have different purposes right yeah things are no deep engineering meetings where there's lots of discussion you need every single minute stand-ups you know stand-ups 10 minutes man you're 10 minutes in and you're 10 minute and you're out and that's it and you know you if you cut if you say oh we're gonna start at 10.03 you know you're gonna have people going I'm just gonna say three minutes and waste my time yeah I mean I manually actually when I create meetings with my customers are with internal meetings with my teams I actually don't I set the meeting for to start at five past the hour and end at five to the hour always 50 minute meeting I do that because it's horrible when I get to jump back to back to back and I've got I'm taking notes and documentation and then I get to the end of the day and I've been in like seven hours of meetings non-stop and all of a sudden I've got to convert all my notes into something that makes sense because I'll just forget what I wrote tomorrow you know I'll slap between now and then one of those things and you probably at some point have to use the bathroom in seven hours which is also true you know personal business maybe not I have a personal commode yeah you might have this is not chair I'm sitting on yeah it's a throne it's a throne yeah all right I got to get through these exclude okay so things that make you go let's be the judge tell us what the item is and then we'll okay all right this is this is any Mac hits we got any Mac heads no oh okay yeah yeah so I'm figures figures I know we hold on hold on your Santa there yeah sec let me let me get I just threw up a little bit in my mouth now I can both see and hear which is wonderful please I'm a hybrid right so I have a Mac sitting here and then I do everything on a PC so I do pull but so when I say this to you exclude specific files from OneDrive sync on Mac OS from a Mac perspective the the only thing is is that this policy goes by a file extension from Mac perspective there's no such thing as a file extension so I'm trying to understand I'm going hmm how are they gonna do this because from when you're looking at a Mac you don't have extensions on and Mac files don't usually save with an extension so how is one note gonna know what the extension is in order to exclude it I mean OneDrive how's it gonna know to go with to exclude anyone I don't know anything about max at all when you say they don't have extensions is it not that they don't have like they have like hidden extensions no I mean no it associates the file based off of the file type so it has an internal database which called the system library and that system library associates a specific signature of a file to an application so when you create like a word file there's no doc or doc x extension it just knows that it's a word file because it's inside of that internal database that associates yeah one drive sync engine for max able to read that database and therefore understand what it says this setting and lets you enter keywords to prevent the OneDrive sync app from uploading certain files to OneDrive or SharePoint now you can enter complete names such as setup.exe which makes no sense on a Mac because there's no such thing as an exe or use an asterisk as a wild character represent a series of characters such as star.pst so this is this is like a person who works on the windows team wrote this you know it just I don't get it all right okay well I I'm gonna I'm gonna volunteer for some homework I happen to know the head technical engineer in the Mac in Microsoft in Revind and he's kind of in he does all of the platform synchronization and testing work for every single version of current currently supported Mac OS's and devices so let me reach out to him let me reach out to him and ask him see if he knows anything about it okay cool yeah Mike I didn't I didn't know some of the background information that you were sharing there around how a file name is associated to a file and engines and such I mean for a friend of perspective when you when you open up Finder you see all the extensions and you see the kinds they don't call them extensions and it's called it's the kind field right so I got their own term naturally yes but there you look at the file itself it's there's no like name dot dot x dot x there is there is well if you turn them on yes here there is say by default they're not yeah there you go all right a couple more things got to get through this SharePoint and teams and I think we talked about this at one point there's a folder the folder can now be visible so a folder in a site is visibly connected to a channel so the teams release will make it easy to tell which folders within your SharePoint library have a teams channel associated with them additionally you'll be able to see this right from within the SharePoint user interface this new feature will roll out to teams desktop and web is that something sharing John that you know you see a lot of that people are like hey is there a team associated with this yeah there's like a little icon or something on it kind of like there'd be like a like something that's locked that's private you know you have a little padlock or something that there's a visual cue there because I've heard that question from people like they're confused about you know which is which and so I think that's a as long as it's not becoming like a MySpace type thing with little animated gifts all over SharePoint now yeah with all these different indicators to me there's the best practices if you have a team enabled SharePoint site the document library by default is used and a new folder is created every time a channel is created you don't add additional folders to that library you create another library that's my but don't mess with them but what this is getting at is that there's no visibility yeah the link between the two so when you're in SharePoint you don't know whether or not whether there's teams behind it a team's channel that's sitting behind that that library just and when you're in teams you don't know if there's a SharePoint what SharePoint library is associated that team yeah and I totally agree with that it'd be nice to have a little visual indicator like you're saying like the private channels have the little lock on it I'm I totally agree with that but it in you just shouldn't mix it up because if somebody comes in and creates a channel with the same name that somebody created a folder in your document library you're now going to get one of those nasty either it's not going to work it's going to fail or you're going to get that one of those really long nasty folder name so binary explosive together and boom exactly so I don't know I just I don't mess with that document library if it's the teams enabled SharePoint site but that's but that's me all right so we got a new SharePoint live presentation option coming and this one is really cool because you have the ability now to with desktop and window sharing you open up teams okay and you open up PowerPoint live and now in PowerPoint live you can embed your teams video so it's kind of like you know the whole green screen effect where you know if you're using like OBS OBS right yeah it's yeah it's the same thing but now you have to use teams and PowerPoint online together all right so it's not in a single app like I would think from a PowerPoint desktop app perspective you should be able to use this as well but they're saying it's only available in PowerPoint live on the web so just wait for PowerPoint live for the web pro yeah and there you go I think you mean do you mean business Christian or pro for well there's those are two different skews Eric well naturally I'm sorry I hate to get technical and then there's the small business skew of yeah anyway yeah okay I got to two roadmap items and then I'm done I'm out of your hair first the first one isn't again GCC GCC is only getting this I don't know why so that was another I just want to point out that was another slam on it what it is a follow-up it's definitely a slam it definitely is Microsoft teams live transcript for teams meetings okay so live transcripts is coming and you have the ability to see them live but you also have the ability to download them after the fact but only for GCC almost don't know why last thing exchange and outlook for business now this is I think this is really cool because if you work in an institution or business that allows for when you book a meeting if you're at Microsoft campus perfect example you book a meeting it's over in building 92 or it's over in building whatever the only thing is is you book that meeting you have to book walk time or you have to book shuttle time to get to that right well that's not part of the booking now they're giving you the ability to book time and travel and transportation along with a meeting so you book a meeting they're gonna give you the age you need transportation if your organization has you know the transportation resources set up you can book those along with it and you know have your time allocated correctly rather than trying to piece it all together I'm really surprised that Microsoft would come out with this this feature I mean if because insiders are well aware of this of the vast network of pneumatic tubes underneath Microsoft campus campus so you get in the pod you have to have your hands crossed across your chest for safety keep your hands in your side and feet crossed like you do when you go rafting right what about the transporter though you know only there's only a couple offices that have the transporter you know that's obviously reserved Satya's got one of course you know and a bad tree he just taps it goes baby up yeah yeah yeah yeah well one thing you know and it was I know it's not it's been out for like a well it's a few days it was in the updates was the delay of the shared channels really disappointed that that got pushed out anybody see that notification yep yeah so I think November yeah it's like they moved everything down I don't know if you follow and one thing I've noticed about the channel updates and not only because when you get the message center updates in 365 you're not the when you do that publicly you're not actually seeing all the channel updates there are channel updates that if you are you guys are in you know in 365 MVPs but there are channel updates that are only visible on the back end right there are some updates that the public can't see and some of them I've noticed when you start seeing all of these everything is getting pushed it's like I haven't seen anything hit a timeline because everything comes up and it's updated updated timeline updated timeline updated timeline it's like you know keep pushing till the end of the year folks we got stuff that was ready to go in February that's now pushed until May so they need to practice kind of the project management you know the 101 which is you know what is it whatever your estimate time estimate you know make it two and a half times yeah and that's the reality yeah 20% there isn't planner and everybody randomly changes the due dates on their tasks and planner instead of having Microsoft project where there's no history of that change so you don't know that was that the change like oh yeah yeah that was I was always the delivery data well well your other thing is put put yourself in my shoes right I'm I've run I'm in I'm in like ring zero dog for baby your feet you know your feet ten and a half I'm a 13 so I wouldn't fit I'm sorry well apparently everything's bigger in the US size does matter that we know we know when we project a date for potential shipping you know you got to remember that that every single person or most people inside Microsoft we get we get hammered with a dog food rings of stuff and then we get you know there's scenarios we get and this is how this is the right way to do it in my opinion when we test software and it breaks on our internal people why would we ship it we've got we've got to go slow we have to slow down I know there's the whole concept of you know fail fast fix fast but that only extends to so what you know to win a certain kind of paradigm that makes sense yeah so yeah there's some things that with the week we see it's like holy crap sorry for the language but let's just not do that to our customers right now well let's see we're already we've got 60 minutes left so we've got time to get through some questions again for anybody that's watching on Facebook in the live stream if you've got any questions we are monitoring the the questions so ask away but we've got a number of questions that come from the Microsoft Teams SharePoint M365 Azure communities on Facebook and we're going to go through as many as we can here so let's pick things off with question number what oh wait hey how in your homework do you want to do you want to share the update on your homework from last time do you still have that email open do we want to come back to that um my my dog ate it no we uh and I have it here okay so let me all that re-asked the questions this this question was let me find it here my notes um so Z could ask the question um he was tasked to gather Office 365 email filtering settings to be provided to an auditor what's the best way to gather this so a screenshot of the spam filters or malware malware filters um what are the other options to capture those well from the standpoint of just looking around there's nothing I could find it was really obvious about how to gather specific settings uh however there is quite a bit of stuff on how to manage the settings both by either a power show either using power so or by using a gpo and I increased that a couple of links for that which I'm going to see if I can actually paste into the chat here if you'll let me do it says paste and come bang there we go um and so the thing that is uh there's there's two different sets of power show looks like to be the way he's probably going to want to do this um I found a couple to two articles I've got uh that I have posted there both deal with uh using power show uh the first is uh for on-prem and the second one is I think that's the order I put him in I just see the one I just see the one link so far on there how no there's two links there's two just at least there's two links here it just shows us oh yeah okay it just shows us one bang blah but there's two links because it converts it to the titles now thank you Microsoft for doing that and then making it confusing excellent considering and so so with that there's considerable setting he can do as far as enabling and and changing filters so and I didn't get into far enough to see if he can actually do querying but I'm fairly certain that if you can set something you can query its settings so yeah and you can set and reset filters uh using using this methodology excellent and it looks like I say power show would be the way you want to go all right and uh let's see here so I pasted those over in the chat and all right so let's jump into question number one thanks Hal for the homework item community question number one vivix says hello team has anyone configured Microsoft teams group membership dynamically using another active directory security group or mail enabled security group Microsoft 365 group membership provides dynamic membership queries but does not provide any rule or query to map any security group any other way if someone has achieved it or from power out it doesn't sound like it I mean I've done it through m 365 groups but that's like he's saying you can't be dynamic with that usually with I mean I guess I need to understand dynamically how are they how are they how do they want the users added by it like ad attribute or I mean how does that person get dynamically added is it because they put a field in there that's like their office is financed and they are supposed to get automatically added to a group I do I need to understand that because I I'm almost sure if that's the case and there's got to be a way to do it through the graph api or through uh power shell all right says like everybody is just excited about that question but I yield my time thank you go I forgot that's a thing now sorry all right let's jump to question number two Rohit asks hi I am unable to see IIS server page after running shell script through custom script extension can someone help you broke it you broke it I mean you ran a shell script your IIS doesn't work anymore am I wrong no error messages will be useful anything in the viewer would be useful to help troubleshoot diagnosis but just based on that I mean what is the shell script what does it do was he trying to achieve maybe it's you know inside of the shell script it's an RM star so it's removing all your files I don't know what the shell script is doing would you say in general like that that would be bad or maybe it's getting giving root access to someone outside of your company and yeah so it could be anything from from from you know the service isn't running that there's so many possibilities here for what's broken that they need a little more context in terms of understand what that was going on here that should be it's can someone help absolutely someone can help we need more information yep this is for those that are dialing in what watching the lecture in the recording of this is like so these are unedited questions coming from the community and there are many of these that don't have adequate information for any kind of an answer yeah exactly yeah this is yeah which is fine so if Rohit if you're watching additional information post it again to out to the site and we'll you know we'll try to address it if there's additional information there all right um adam question number three uh one of the clients that I collaborate with via microsoft teams would like to know the footprint that is left on machines during and after the collaboration this ranges from simple one-to-one chats through to file sharing and meetings where no recordings are made is there a definitive source of information that can describe this that's a great question um that you know especially if you own you know auditing compliance and understanding that complete footprint of activities around teams where it we jump to the two output sources is always the the first answer the documents that we upload and work with um the files that we attach or the meetings and those are two the easy things and below that would be all the chats all the conversations but what is the total footprint yeah everything so with teams everything gets stored as most applications do under app data right and uh you know if you go to um the app data what's the easiest way to get to it uh are you do your percent app data percent right that'll that'll give you the the app data it'll take you to there so everything gets cached there um you can clear it there's um there's I don't know there's probably a way online if someone tells you how to clear it but that will store kind of like instant cache of chat that doesn't have to be retrieved from the services from the server or the the data store um it'll keep the very most recent things but that's pretty much as far as I'm aware that's pretty much all gets cached I can't claim to be the authority on that but um that cache can be cleared for sure so I I saw this question come in live and so was you know prompted in my notifications on on facebook and and what in and somebody went in pretty quick and provided I went looking for it because I had just found this from another conversation a compliance and auditing discussion uh and so I provided the link somebody had added to facebook so it's the location of data and teams link and on docs.microsoft but then uh it also had somebody go in and share the office 365 it pros link for teams desktop browser clients offline send that article um so both great resources to help you outline everything that is captured within the footprint so there you go and then by the way and the links to all of these things every question that we cover as well as any links that we share will be in the blog post down on buckleyplanet.com and I'll have it up later tonight but yeah that is so that's great to have you know these two links these for reference but yeah it's it's good to be familiar with this especially if you get into a compliance or regulatory requirement to provide to understand that footprint and and hey everybody we do have a question um from paul out on facebook so we've got a live question here says paul says hello all I wondered if anyone could offer advice or tips on walking down the power platform and ongoing governance we're looking to deploy power platform in a bank who have a lot of concerns around data leakage etc uh other than walking down the default environment or connectors and roles within power platform and creating new environments with the appropriate connectors what else should we be thinking about and any pointers to where you can find more info on best practices somebody got a dlp link seems that the obvious response I don't have one yeah I don't either I'll add this in and uh yeah let me google that for you no you're gonna google a thing are you is it being on google does it matter which one all right while we're looking that up great question paul and uh so we'll we'll see if we do we want to wait for that or are you guys looking or so I'm going to give you a gen genitalian to the Microsoft security practices oh crap it's a horrible link that's okay let me find a better one oh yeah uh sorry there we go that would be a bing what they call a bing puke or bing bing bang bong yeah browser vomited I'm sorry yeah that's awesome I guess I can delete the message is my chat right I can delete it yep yes you can you should well always have the memory though it's gone away thank you over in the the facebook comment comments it initially you know it converted it but uh yeah anyway that's that's awesome okay I mean that is the root of the security side for the the security compliance center for the Microsoft side but I hate to do a little bit a little bit taken to get guess what you need so that's that's a that's a great question though all right uh question number four maximillion says hi I want to try power bi in the cloud I need to collect data from two sass applications like google adwords and one visitor tracker moreover I need to load data from on-premises sql database what's your recommendations using power bi data gateway to load local data uh is it's only loading delta or pushing local data to azure sql or blob do I need azure data factory or analytics service or is it's enough to use power bi only for beginner or beginning what is your recommendation call john white so that's uh four ones oh he's five one nine the tigress folks yeah realistically what you're dealing with here is you're dealing with a architecture question because there's 10 different ways that you could you know create this data or be able to import this data um power bi is probably the answer for the manipulation and display display of the data but the input or the ingesting of the data you know should you use data gateway should you put it up in sql in a sql database should you do this should you do that that's all around what the data is you're going to be bringing in what the frequency of the data you're going to be bringing in um and you know if you use an azure service it's going to cost you more than you know just bringing it in directly through a local gateway um and then also you know what's your what's your final goal what's what's the whole goal of this is this something that's going to be like a living something that's going to be living forever or is it something that's just going to be a one-shot deal so there's a there's there's architectural questions around this you know um or design questions if you will yeah yeah and pretty much a uh microsoft uh partner or consultant would be able to assist you with that such as the ones that shon uh mentioned john wait the tigraph folks yeah yeah okay um question number five from seo uh anyone know any great syncing tools from local drives to share point including https connection please this is not a migration uh one drive going in fruit one drive sink yeah what's the obvious thing we're missing here exactly but i don't think this groove groove to exe yeah sorry yeah sorry point desktop exactly yeah this may just be an under misunderstanding because they may not know that one drive is a back end for share point um you know obviously one drive sink will do it for you but there are some third party tools out there that do it just as well you know or microsoft you know robo copy whatever you know if you really want to do something complex but uh just drop it into a folder that one drive sees and you're good to go still makes me laugh robo copy what's that still makes me laugh robo copy robo copy is i is one of the most awesome tools ever made yeah i might be the new howl i'm not able to chat i haven't i haven't answered for you but i'm very much at it stunted maybe i'll just copy these and send them to you in an email christian if i can't hey share you can also drop the link over in the facebook live stream and i can paste it in that way okay cool do you have the link for that because i don't i don't watch much i don't watch myself yeah well that would be helpful except i can't chat well if you go if you go to my if you go to my page to my profile and you can find it i said i could i could add the link over in the chat here but it wouldn't be so helpful no considering i can't chat i'm the new howl yes i'm the new howl all right uh question number six uh shana says i am not able to open powerpoint files uploaded in a team's channel when i click on the file it would just spin and do nothing what could be wrong the the amount of enthusiasm we have today for answering questions just is just blowing me away i haven't answered that one too i don't want to be the the my cog here but i'm wondering if it's if when she says she's a it's a ppt file that right there it has to be pptx to be displayed in a web browser you can't display a ppt in a web browser so i'm wondering if it's her file format she's not even saying she's trying to display it in the web browser though well she says the officer 65 right if it's in a if it's in a team's channel the default is it will open in embedded browser effectively within teams right with your team's client or if she's in teams through the browser it will also open in the browser i think that's a sherry's point so ppt does she mean ppt does she really mean pptx i haven't seen a ppt file in years we're talking about the application but yeah not since the evolutions conference 2009 or something so if we're we're assuming it's the appropriate it's a powerpoint file that that's in there i mean is there something is there a permissions issue that could be here with the the data you know she definitely she would be a she would be able to see it right because it would be security trimmed right hit f12 click on the console tab and look at what it says get a little scene a little shot behind the scenes of what's going on yeah and there's other things to think about here right is it does this occur in just this one channel does it occur in multiple channels within the same teams kind of um the same teams team if that makes sense um one browser multiple browsers powerpoints from sharepoint directly there's you know there's a number of when we think about you know obviously my my background from a sharepoint perspective is in support is an engineer so there's a number of things that i would want to understand you know to you not just say what's wrong but more about what are the other experiences and do some things work do some things not and try and kind of process of elimination basically that when i have an issue like that i mean that's the first thing that i go and do can i open a powerpoint file in any other team and any other channel well first another channel within that team another team entirely is it also happening with word docs with excel files you know other things is there a problem opening office applications which could indicate maybe there is something with the version of office that you're running you know who knows but that's that those are the things am i how am i logged into that tenant i'm sure this for those of us that use multiple tenants am i logged into a team with my microsoft community site my login versus my company uh login so you know all things that you could look at that could potentially impact that experience yep all right um yeah so that's another need more information yeah as i'm looking at the little purple circle i i totally am empathetic to her right all right question number seven uh dibblina says uh can we change contact info details of the guest user and azure ad sink users in azure ad there's a certain amount of certain amount of metadata you can change things you can't with the sync user is obviously you can't change things like the email address yes the you know the um upn bp at upn eventually essentially but there's some things you can change for sure i'd have to go and look at the detail what you kind of count but you can there's some things you can do for sure i'm looking it up and uh am i on mute no no okay i'm no i'm looking it up in the graph api right now i'm sure there's a way to do it um if anyway do the graph api i know you can't do it through the ui the portal ui so so folks i know it doesn't make for great television but sometimes we're looking up the answers live here on air and that's why you've got the look the little pauses um but uh yeah it also builds the drama i guess so that's good we need the music according to this inter jeopardy theme here exactly you know like so yeah yeah so there is a way to do it um to the graph api and uh i've got the link here put it out there yeah i mean primarily the the way that microsoft to say that you should do it is if you if you need to modify the properties of a user in azure ad that's a user that's being synced from on premises you just you make the change on premises yeah allow the sync but if it's a guest user that was created in azure ad um i don't know if they'd be able to modify that object well they should be able to well it's a difference between it's a difference between whether it's a synchronized user or yeah it's or in cloud user yeah is right back enabled as well yeah yeah you're right so yeah yeah all those things have to be considered okay uh question number eight gabrielle says uh anyone with share point on-prem skills mic uh web app yeah web app with anonymous access granted no policy site authorizes to entire entire site the library with unique permissions inheritance broken still i can only check the view permission uh the ad edit checkboxes are grayed out why for what web app synonymous no okay no policy site authorizes to the only thing i could come up with was creating a new permission level that you could assign that had that already but um um and again that's kind of need to know more information about the rest of the environment like well what are the permissions of the person trying to change the permissions so the other you know it depends well there's dependency on the version you know are we talking about an older version are they trying to look at an uh a file or something are they're underlying um windows permissions in play if it's a file i mean all sorts of different things that could potentially be an issue here i'm assuming that the whether talking about view permission and ad edit um that's on the ribbon right so it's so the interesting to know who the like gabrielle if this is you and you have what permissions do you have to that site in that location yeah because everything else that she describes is its view right and also if an anonymous access is enabled is she logging in with anonymous access or is she logging in as a person as a you know as a self what identity does she have when she's on that site yeah anonymous access and share point on prem is a really bad idea anyway i would avoid it like plague all right yeah that's so a little bit more information but we i i think it's just uh yeah all right i think we've answered that it is what it is yep uh number nine uh german ass i saw in the message center where microsoft announced they were increasing the interactive participant limit from 300 to 1000 the times time frame has been updated to end of april does anyone know how to confirm that the limit has been increased i don't know if 300 people to test and see if my tenant has received the upgrade oh i don't know if there's a way to do that or not um well all the documentation has been updated you know i actually don't know this question so microsoft announced it do they change the documentation so if i go to doc step microsoft and look this up do they change that once it's ga and been deployed fully or did they do that at the beginning of a rollout where your your tenant may be on a slower ring and it's not yet updated i don't think they do it until the entire ring is complete i mean to me that would make more sense but uh um because i mean why would you change the docs early for the early rings and then the folks that are on the later rings are going to be like how come i don't see this i don't see the ability to do this unless they put a put node you know or a header in there that says hey this is rolling out this is actively being rolled out um i don't know but i don't know there's a way to check uh if you've received something without actually like seeing a button created or seeing a checkbox or something you know something like that i i don't think there's a way to check i do know that that update um because i had a customer talking to ask me about this the other day and they were they were saying they were gonna start it in march and it would be complete by the end of april yeah how do you validate it i don't know um like you know to help to the house point i don't think there's a way to truly this has been a request for a long time of like in the message center updates there should be some kind of indicator of what has actually been updated on your tenant so you have that tenant view of that so we get the broad announcements we know that's going to happen within between march and april this new feature is going live uh and you should know the ring that you're on but there should be it would be great to have some indicator to show that hey this is live on my environment now yeah i mean and i know well i know nobody wants to raise support tickets but i know support can definitely tell you you know i i have a dashboard that i can look at that will show me which updates and which um uh you know features have rolled out across different tenants and i can do individual tenant lookouts but that's because i'm part of that organization um i don't think it's something that the individual tenants actually have one thing i would ask though is whether the tenant are they on the you know if they're on the regular update ring versus the delayed you know forget the what's the name of the thing you can be like you can you can delay your updates a little bit deliberately if you wish yeah and i forget the name of it i guess it would depend on what they are but i would i would i would expect that if they are part of the regular update ring they will already have this all the you know it's it's literally shit it's done and uh just had Keith asking where the recording will be uh so ah come on the other way to look at is think about the the roadmap if you look at the actual roadmap the roadmap will show you um items that are in development items that are currently rolling out and items that are fully launched so that's something else to think about i can't put the link to the roadmap in the chat window i think we all know it anyway but good for the and and by the way we lost Sean so i think he had to that was just abrupt oh so that didn't work but uh all right um i'll fix the link i just posted the uh a bad link i'll just go and grab it but um misleading information happening in the chat over on facebook um all right yeah so Sean had to depart early for a client call um and we were offset by thinking Neil was going to join late but we've had him the whole time so sorry that's all right just just threw us off uh let's see so question 10 another question from Zeke oh yeah sure he he really just wanted to watch Jeff Teeper's keynote because he just the keynote for the m 365 just started ah that's what's going on his other meeting that's right we'll call it that uh let's see all right so question 10 Zeke says anyone know how to repair a corrupted word file i have extracted it in open document dot x xml but don't know how to find a repair line two column blah blah blah so repair a corrupted word file line two column five hundred and thirty three thousand eight hundred thirty seven yeah definitely some line breaks missing um yeah i don't know it has a repair feature i assume he's tried that you have to assume they did how i mean that's just we can't make any assumptions though so yeah i would make us i sorry go ahead that's okay go ahead Neil i was i was gonna say you know if he's got if he's got document xml open then assuming that the text in that document isn't corrupt and it can actually access the you know the basic text of the document that will be in the xml file i would suggest the best way to do would be to just grab that file grab the you know copy and paste the data out of it into even something as simple as notepad and open it create a new word document and go go start from there depends on valuable the document the content of the document is if it's a very if it's exceptionally valuable content to me i'm going to do the best i can even if it takes a lot of manual effort to make that happen yeah and i would then i'd also be concerned about you know why did this happen how did this happen in my next steps how do i stop it happening again yeah there are third i'm sorry i haven't seen a corrupted document since the docx trends anybody else i mean he's tapping all the time in the doc files all right so that again that makes me wonder what format his file is in um and but like i said i put a link in the chat for how to um troubleshoot a document so i'm assuming it's a docx can give any access to the xml because the you know doc was a very proprietary format right i guess it's it's all about how much effort you want to put into the for me so how much effort how valuable is the content of that document and how much effort am i willing to do to recover it yeah i don't know that i had a corrupted file i'm trying to remember what it was but i mean one of the things that you also have is the resources the versioning is go back in the versioning yeah depending on where it was stored it can't open it you know yeah yeah all depends on that and there are third party tools that are created that will try and recover but usually i mean they'll recover a portion of it and then they want you to pay after that back um but uh yeah you're talking 53 000 some columns i'm sure that you'll hit that uh that blocker right away that you 10 times up yeah 533 000 yeah right question 11 peter says i am relatively new to sharepoint i hope my question makes sense i would like to use either tags or a custom column in documents to track the progress of reports by labeling them such as tags to be dictated to be uh uh to be proofed to be sent etc is it possible to have a dynamic folder in documents or elsewhere that could contain all reports of the tag to be proofed search is your friend it's a view so you create a you create that custom column then you create a view that filters for that yeah then i'm looking to put that in the chat too yeah so if you do build that i mean that's one of the the another reason why if you're if you're using SharePoint as the primary interface you can use the list app over in teams and do that which is just a SharePoint list uh as well but yes create that and then customize the view is question 12 connected to 11 uh yeah i was kind of wondering the same thing when i said yes yes yeah so i think sharing i think shari's idea of the list views and probably the absolutely right thing to do here you know i mentioned search search can be super helpful in a variety of ways but it will probably take a lot more work to build a search kind of custom search view versus a list view that has the right you know metadata um show view when metadata equals whatever that kind of thing a little known trick too that a lot of people don't know about is when you create a view let's say you have folders because they people love to use their folders and share my libraries you can still use those custom columns on any document in any folder and you can create a view that ignores the folders so that it would show a roll up even if they're nested in a bunch of files it'll show a roll up view of those attributes that you're filtering for in the view so it's in in the SharePoint settings um in the view down at the bottom just to show in folders you deselect it i think we should also comment uh as a group about uh christian's inability to copy and paste correctly for those last few questions so yeah there's another way to look at this as well as a as a as a kind of a beneficial piece of you know SharePoint has a i won't say powerful workflow engine built into it but it does have a workflow engine so it's worth considering workflow here when you're looking at you know tracking what items you know if you're looking at how many we need to dictate what's to be proved what should be sent workflow reporting is also an interesting feature that will give you some of that functionality yeah won't let you you can't look at view all items in a certain state but it was certainly something that you should maybe investigate just as a view to thinking about um uh you know how you track the status of of individual items yeah yeah do a lot of dynamic things like send out notifications when it's changed state um you know yeah when new items have been added um yeah there's a lot of creative things that you can do if you're trying to automate that workflow when it when it's approved it gets moved to the next stage the next step yeah yeah all right so uh i thought you said another way to look at it is that christian just doesn't care about the quality of his cut and paste uh so i have uh yeah i know eric you're you're you're talking a lot but no sound is coming out i know i'm not complaining i'm just stating a fact are we going to create like a swear jar for every time you have to say we're on mute but i wasn't on mute just using the wrong microphone let's see let's so i have corrected the error in my cut and paste of the list so the next one was stephanie is actually question 12 um so stephanie says my organization is planning the transition from our Drupal internet to a SharePoint online intranet may i ask how others are creating org wide calendars we have like we've had a few calendar questions over the last couple weeks we need a calendar that is viewable by all staff and is editable by a few it will include things like closings committee meetings upcoming trainings etc what's the best way to do that and SharePoint online um i could take that one if you want this is just my this is my baby this is the ones i love because let's make things easier for people have one centralized calendar that um again the permission groups have to be set up correctly and then anybody with an authenticated address can view it and then you can at the department level if you have other um departments or calendars that have to be managed and you want to centralize that information you just do a calendar overlay so you take that same calendar and you put it on top of your departmental calendars you can see the mail both and you can create color codes for those so uh again put a link in the chat for that one i love calendar overlays it's one of my favorite things yeah you shouldn't have to duplicate across 20 calendars the same information just so people can see it where they're working agreed if yeah there i i wrote something about this in my SharePoint 2010 book so yeah for those that are still using SharePoint 2010 isn't it getting to get uh isn't it out of um important doesn't mean people aren't still using it is that still a thing 2010 sounds a long ago it was a long time ago it was so like one digit away like now we're into the twos people yeah uh all right question 13 jury says what i call to any users when i call to any users the call drops immediately how to resolve the teams call dropping issue my first comment is that are you sure they aren't just hanging up on you that would be the first thing to verify Mike you don't like that fake advice and it's telephony related so yeah yeah this this happens to me too it annoys i'm holding my breath waiting for the answer on this one because it happens to me i'll join a call it goes bloop and it cuts it drops it right off and i'll join back and it goes bloop and then if i join from the browser then it'll it'll join it for some reason and the client it just immediately drops it since i joined a call or start a call so i would love to know one of you fabulous gentlemen have answered this question i like that with the telephony call and eric departs doesn't say goodbye just says he's leaving gone so i what i see in my head is the road runner with the little puff behind him too he's gone yeah so i you know i've not experienced so i don't know enough detail around this i mean where i've experienced um dropped audio or video it's usually network related issues i don't know that i've experienced this and just the telephony side oh oh he did leave a note this has got a hop okay and with a heart so you can't you can't rag on the guy for for when he leaves the heart symbol there so you know we heart you too eric yeah so um i yeah that's a punt for me on that question i mean other with network issues are there like known issues with call dropping telephony telephony punk telephony thing yeah i'm sorry now let's go like this i don't know yeah yeah so we need that meme that's what we need we need to have all of us doing this and i like the disclaimer i need to hit the button and have that visual all right next question please 14 hose says is there any extra cost for the company to assign a second admin role to an existing user in teams um do do i need to buy another license for a second admin role just assigning a second role like no your license is your license i mean that user has to be licensed yeah they can't be like on the free plan but i'm taken from an organization because they're talking about an organization standpoint for company so no you don't have to pay i don't know if there's a limit on the number of admins you can have but i know i have probably four admins on one tenant well there's also a difference in terms of admins like so if let's say you're a you can be a billing admin right so you get access to the costs or you can be a user admin so you can create users reset passwords that kind of thing but this is from teams this is from a teams admin though yeah but i don't think i think i think the model is pretty much the same i don't think i don't think there's any any like you have a specific license for a specific tank of admin and if i'm a you know because i okay if you can just i can just make everyone like equivalent of global admin yeah you could do that you could go and if you're small business and there's 10 of you and and there's things that you're doing you can make everyone a global admin well and i have a global admin and it's not licensed like i mean it's got the very lowest license you can have which is it really yeah yeah it doesn't have the apps or anything so it's like five bucks a month or something that actually that's actually interesting sharing you bring that up because from a security audit perspective one of the things that i've run into several times is people give the global admin or the owner because you have an owner right and owner is another permission right but people give them like a license for everything and and i'm like you need to have a global admin that has nothing okay because they don't need a global admin should not need any applications there should be nothing that should be assigned to a global admin or even the owner if that's their role is just that admin access yeah but if they're a another user again a small business it's more likely that they're gonna have multiple but that should be but that should be a still it should be like a from a security aspect it should be a separate user okay then what you log in as it's like me logging into a windows box i shouldn't log in as administrator i need to log in as myself and the only reason i have a license on is because it has to have email it has there are certain things i use it for that it has to receive an email for so i don't even i don't even do that when i set up mine i have it i have actually the global admin doesn't even have access to email i have all those emails set to me as a billing admin or as a you know a tenant admin or not a tenant admin but a uh in light in uh lighthouse it's a another role i can't remember for the tenants for the multiple tenants but as a global admin they got nothing and and it shouldn't be administrator at tenantname.com because that's too easily guessed right i'm sure there's a bunch of content that's out there but mike that sounds like a great blog post yeah you know of what the recommendations for setting that up yeah there's only five of us it's a small business i don't need you know i i don't know about an enterprise if you might need to have multiple people that where you kind of disseminate those duties on different accounts but it's just me and five other accounts so right i understand it's a small organization but you still need to protect yourself because you are a business so you know that's the first thing is that like you said administrator at xyz.com it's easy enough to figure out oh let's just try this admin administrator account and let's just take their address and put it in as a password or let's just and they don't have mfa set up so you know then it goes through brute force you know it's like it's like the people in my neighborhood they still have linksus as their router name or i've got okay i'm not going to name the name let's just call him tommy but it's his tommy's network and everybody knows who the guy is and it's like dude you didn't do the exact and he doesn't have it and it's not secured you can just tap right into it my kids when i shut the internet down mean amino mommy they'd pick up on his because i knew it was right next door yeah so well and that's that's that's obvious that's that's just a wi-fi portion of it and not to get off on a tangent here but i had my neighbor who's not necessarily technically uh you know adaptive to new technology bought a printer and these new hb printers automatically make themselves a wi-fi access point right with the hb printer name if you set up the cloud print because part of the and cloud print is checked by default when you go through the installation which i think is just incredibly stupid but they set it all up they had cloud print they had the access point they had no password on the access point i saw it pop up connected to it typed in a nice little word document saying hey i can see you you know i can see you through your windows i am watching you're watching the tv you know and his his wife was out uh working in the yard and i said oh yeah and and janet's out in the yard working you know and he's like freaked out just i mean he's like you know and i walk outside he's like you gotta help me you gotta help me somebody's like hacked into my network in my home network and everything like no that was me i'm done are you surprised by the restraining order mic i only got access to the printer that's it that's funny that just reminds me of like the old days where i so i worked for my first tech company back in 91 92 uh and we had a fax based uh system so we were a reseller of computer hardware and so we worked directly with hula packer in their facility out in rockland california and we managed their warehouses and all that and we resold equipment so people would globally like oh i bought a brand new monitor and there's a scratch in it send it back it would go all the way wherever it was in the world to rocklin like i don't know what that costs back in those old days of the huge crt monitors 80 pound monitor right anyway and then we would touch up the paint and then resell it but anyway uh but we would do this what was called broker fax and send out uh nightly we had the paradox database we had multiple phones and it would just roll out of all the items the new inventory every single night we'd send out to hundreds of resellers around the world um this this faxers i ran that service and we found that we we would uh if to our phone line get calls all the time long story shorter shorter uh is we just this this fax line kept calling repeated repeated to our phone line and so we ended up somebody in my team screaming like this is a this is not a fax line stop calling this and the people heard it through the fax line fax machine yes and they could hear it there was still audio in their fax machine they could hear it this little the sound but the voice come through distinctly of the person screaming and they called to complain about i think there was some not kind words used in his rant um but the person heard g13 no heard it through the fax machine had it swear at them and then called their company like what's going on and like gave them the right number they had the wrong number obviously but uh anyway just uh love that old fax technology uh all right let's see we've got a we've got a couple minutes left just over five minutes here they have to keep the speakers on on those old fax machines just like that because once upon a time it was a manual connection back in the days when you made your phone call with your voice and then you plugged your phone into a cradle that's where all that comes from and of course that in order to accommodate them the speakers have to stay on good old war games war games when you pick up the phone yep computer called him you had to put it on there and fax was fax was one of my special computer the computer was on it way back a number of years ago science was printing an imaging and uh the imaging point is that expectation loading again all right let's see uh question number 15 kemlash says sharepoint online has provided me options to embed yammer and twitter content easily how can i embed a public linkedin page feed this is weblink you have a web part for web links cherry there is a there is a web part right for the content viewer web part yeah content viewer yeah right yep wow you can do um it's just a web page and you put the url on the page right but but it it doesn't to me it doesn't clean it up because you've got the it puts the whole page right there's not a native header and then yeah you're not gonna get just the content yeah but you could also i've saw someone that did an rss feed so if you have a website that just says rss feeds of the articles which you can get from linkedin then there is is there and there's an rss rss web part for sharepoint or not well they used to be i don't know if it still is but it definitely was back in the day is there an rss feed for for posts and updates for linkedin i think there is i think you can there's an rss icon on your on your page that you can click and get a link to the rss feed i've not tapped into that now you're making me curious yeah yeah everybody's gonna go look and mic's gonna be wrong we're just gonna feed we're gonna feed christian all the tips for his session on of course no it's already it's already built all right last question i think this will be the last question but bo says i have a sharepoint online list the list has a column for every hour of the day so one through 24 i would like to minimize the width of the columns so that i can see most if not all of the columns without panning side to side it seems you can only drag the column width down to around one and a half inches and no further this ends up eating up a lot of screen real estate is there any simple work around for this i've got it folks buy an extra wide monitor oh thank you shrink the volume use your zoom settings and go down to like 50 percent yeah i did work too yeah so i don't know if you can do a json formatting or something on the list but that's not my jam i that's a complete guess so i don't know can you because you can create different list views or use you used to be able to using formatting but i don't do that i don't like it it breaks yeah so just going back to the previous question there is an rss feed link and sharepoint does still contain the rss feed viewer web part all right there you go and knowing's half the battle gee hi joe here's the i was working on it too here's the because i got i'm curious neil you're actually saying i was right holy christ yes doesn't happen often mike make sure again mike has mike secretly has all of the sharepoint answers come on yes it is yeah yeah so any other ideas of how so no judgment calls on on what he's trying to accomplish with sizing of the columns in 24 columns for every hour of the day it's like he has his reasons for doing that and outside of an extra wide monitor or reducing the font size so increase the visibility of that list is there a way to go in there and decrease the width of those seemingly 1.5 inch that seems rather large but is there a way to column so i would i would ask another question here um back to bow um which would be what is the actual um column format is it text is it numerical um because that might also affect the way that are the sizing that that's available for the column based on the based on the format and i would assume it's numeric integer right therefore it should be as small as it can possibly be but i think that would also have an impact in terms of how big it can be and which white space is allowed okay well and with that well we are i'm gonna one more thing christian sorry oh yeah the other option is consider the fact that the columns in a share point list ultimately still are just what html right that ultimately that's what gets rendered so you could also consider looking at a custom css style sheet for the site that might you know based on the based on the on the column uh the column has a has a uh name a value it might be able to modify the css rendering of that as well okay i'm done okay all right well thank you so much for that and thanks for everybody of course uh you know Eric Eric and Sean uh who uh who couldn't make it all the way through so uh it's great that uh that the four of you were able to stick with it um that means a lot you'll your bonus will be extra large this year but with that uh uh we'll be back next week of course for those that are watching the the recording or watch the livestream uh all of the uh a link list with all of the message center updates as well as every question that we discussed with all the links that we provided through the chat throughout we'll all be in a blog post out on buckleyplanet.com it'll be out this evening uh over on youtube and the collab talk page on youtube as well the recording will be there and so we'll share it through the various social channels you can continue to get in touch with this just reach out to us individually uh through social channels but if you have other questions you'd like to post you can DM me through the various places twitter facebook wherever you find me and uh we'll be sure to add the question to our list and we'll be back to tackle more of your community questions uh next monday at 8 am pacific and so with that thanks everybody and we'll see you again next week uh thank you have a good day