 It's just to turn the music down. I know, yeah, just so much. So thank you all for joining us this morning, this, I don't know, it was rainy morning. I'm sure it's raining somewhere. But welcome to another episode of Microsoft Community Office Hours, where we will be discussing all things Microsoft 365 and answering questions directly from you, the community. My name is Christian Buckley. I'm an Office Apps and Services MVP and Microsoft Regional Director and the Microsoft Go-To-Market Director at AvePoint and joining me as always, we've got the core team here today. Others, there's the Canadian holidays. We're missing some other folks and other people that have, I don't know, excuses like customer meetings or blah, blah, blah, I don't know. Isn't every day a Canadian holiday? And they're sorry. Sorry. Sorry. But we have Sean McDonough, Consultant with Bitstream Foundry in Cincinnati, Ohio and an Office Apps and Services MVP. Hal Haas-Dettler, a senior field engineer with Roland Shore and Tower in Tucson, Arizona. Also an Office Apps and Services MVP. And the odd man out today, not an Office Apps and Services MVP, but Mike Nelson, Solutions Architect with Pure Storage and a Cloud and Data Center Management MVP based in Appleton, Wisconsin. And good morning. Why is this title so much longer? Good morning. He likes, Michael likes it fluffed up. He wants, I- I never asked for anything fluffed up. I refuse to add the Esquire to the end. I don't think that it's a title that he's earned. I don't change the term. I don't like fluffing. Well, no, fluffing is, you know, I would not use that term except when you talk to people in marketing, i.e. Christian, you know, he puts a lot of fluff into things. Don't you? You flipper you. When it's in the job description and I'm paid to do it, I will do it. Here we go. Well, well, thank you so much for that. Sean knew what I was going for there. Oh, I know he would use going for as well. I just, I moved on. I rose above it. I'm a professional. So, but we are live streaming via Facebook and YouTube. And I think the Twitters, both of them. But if you have any questions, feel free to ask us. Are there? I don't know. It's a Twitterverse. So, you know, This is Snapchat, Instagram, TikTok. I wouldn't say I'm missing that. Take no, Telegram, Clubhouse now. You're missing, I mean, we should be able to go out to all those. And you as a marketing guys should know how to do that. Just, just get it done. I know, I just don't care. So. The honest approach. That's right. So, you know, I'm generally apathetic about most things, but I would list it for you, but I really don't care. So. And how quiet down you're saying too much. Yeah. Sorry. Sorry, sorry. I'll try that. I'm an idiot today. That's, there you go. Well, Hal was just saying under his voice, how, you know, he really wishes that we could go back the last week episode and look at it again. But that's just not possible. Some of it's possible. Will you ever be hidden from the public? Yes, the lost episode, the lost tapes. And why I know, Mike, you enjoyed that episode so much is because my voice was missing from the entire thing. Yep. Intervention. You can try it. This is, we are, it feels like we've done episode 60 before, but no, it's all new. New. Yeah. So we had some technical difficulties last week if for those that who caught it didn't catch it. We. Yeah, we. Yeah, we, we did it. Yeah. This is episode 60 and a third. 60 and three eight. This one's going to 11. Well, let's, let's just jump. Well, is there anything big that's going on? There is an event happening this week. Build Microsoft Build starts tomorrow, tomorrow. And it's free if you've not registered. Like I've pointed a bunch of people towards it. I've got my daughter who's learning Power BI. You're doing that a lot for her work. And, and I'm like, were you aware of this is going on? She's like, yeah, we can't afford to, to do any external training. I'm like, free. It's a good price. And now they've all signed up. They've all signed up. So my daughter, she's like, yeah, I saw about half a dozen sessions that I hope to, to sit through. So I'm excited that one of my children is interested in this technology that I'm involved in. So that's cool. Yeah. Yeah. That is good. All right. So yeah, anything else besides build that's happening? We have, oh, wait, yeah, duh. We have ESPC that's happening next week. And then we have the, the Microsoft 365 collaboration conference. Is that the name of it? That's happening in Florida the week after that. So we've got three weeks of events. One free. The former SharePoint conference. Correct. So for the acronym technically challenged folks, ESPC stands for? Well, it used to be stand for the European SharePoint conference, but now it is the European SharePoint Office 365 and Azure conference. ESPC. Yeah, all the letters in the middle are silent. Yeah, that's right. That's right. So ESPC 21 that's happening next week. And so I'm involved with that as well. So doing, in fact, I did an interview with the Nintex folks this morning for one of the sponsor interviews for the event. And then we had the white shirt on. That is correct. And that's why I mean for that interview, did they do that with video? Yes. And you were all red in the face? No, I adjusted the lighting. But it was very bright. We're going to cut it out in. So that's true. Yeah. Well, it's kind of funny because when I got on, it's only Christian and I, but he's wearing this white shirt. And he. I went to the dark side for this show. Yeah, have you ever seen one of those hot Cheetos? They almost look red. That's where his whole face looked like that. I mean, it was like, I was looking at him like. I turned the lighting back down to my normal settings and it just didn't look good. So I went and put on a black shirt. So yeah. Christian hot Cheeto. That's right. All right. Well, let's move forward. And should we do our theme music for Mike, for the message center updates? You need the disclaimer. Oh, that's right. We need the disclaimer. That's right. I forget. Well, the disclaimer. It should be in the disclaimer that we don't always use the disclaimer. That's all, folks. Sometimes we forget to use the disclaimer. He's got one job. One job. One job. All right. So now we can do the music. D-D-D-D-D-D-D-D-D-D-D-D-D-D-D-D-D. All right. And with that, over to Mike for message center updates. Thank you very much, Christian. It is the week of 524, which is coming up here at the Big Holiday Memorial Day. Hope everybody has a lot of good plans, taking off, going somewhere, getting out, now that some of the COVID things have kind of calmed down a little bit. Don't go too nuts. But go out and have some fun. It's a nice long weekend. So starting off on the message center from the, it's always a network problem department. There are network planner improvements that are coming. A new version of network planner. I'm not sure if anybody knows that this actually exists. But if you go into the team's admin center, there's something called network planner. And what it does is it tests the bandwidth requirements of your team clients to help you with planning your network. Now, this is a little bit confusing to me, because, I mean, every network is different, right? And it all depends on what you're doing at the time. And it always comes back to, it's a network issue. In the old days, we used to always say it's a DNS issue. I was going to say it's a DNS. Yeah, yeah. Well, it's network, right? There's plenty of questions out there. And I would argue that it's also a ball bearings issue. Yeah, but it's all ball bearings these days. And those spits are valves when they go on. You know, and, you know, anyways. So you can go out and use this network planner. And I'm really confused because, you know, it's like, I would not want to be the person who's like in charge of getting feedback on this product, on this feature. Because, I mean, you're going to have like, you know, everyone from the extreme small, little small network all the way up to the big, you know, the big enterprise networks with all these remote offices and everybody's connected via dedicated links or VPN or whatever, they're going to be running this thing. And they're going to be like, hey, this number is not right. You know, and to me, this is just a disaster. This is going to be something. So what's the purpose of it then? I mean, what's the intent? The intent is to give them, you know, some sense of, hey, Microsoft is telling us that our teams environment should work, you know, without any hiccups or flaws, you know, if we run this thing and it says our network is solid between here and here, point A and point B. And to me, I'm just like, how can you even, what algorithm goes behind that? You know, I don't know. I don't get it. Yeah, I think this is more of a, you know, how do they say it, more of a customer perception type of feature than an actual useful feature. But that's just me. All right, moving on from the two wrongs, don't make it a right department, which is a sub department of the nice tribe, but no, preventing issues with journaling and exchange online mailbox limits. Let me see if I can test your history knowledge here a little bit guys, is that, do you remember when we had a long conversation and it was a long conversation about something about, you know, a limit of 3,600 messages per hour of email and they were gonna limit that finally and we were all like, who generates 3,600 messages per hour? Do you guys remember that conversation? I try to block it, but I do remember, I do remember having a conversation about that, yeah. All right, thank you for bailing me on that one. I appreciate that question. But anyways, what they do, what they've done is the organizations will now journal and do what's called alternate journaling mailboxes. So they were taking and they were using these other mailboxes to kind of circumvent the whole limit of 3,600 messages per hour and they were bringing them or receiving them or sending them from an alternate journaling mailbox, which does not have a limit on it. So Microsoft is like, oh, we detected some tenants have done this and that's a no-no. They sent the servants and the force, huh? Yes, yes, yes, yes. So guess what, their hands getting slapped and journeying functionality. Dear diary, I do not like the limitations on the number of times my outlook. Dear diary, you won't believe what happened today. Microsoft extended to, okay. Yeah, okay. All right, hey, I've got one. Oh, hey, this is coming from the yes-how. There is a Santa Claus department, so yeah. So they are adjusting the version retention for Outlook data files, PSTs. You love PSTs, Hal. I saw that. I thought of you and the PST version retention policies are being changed to introduce and address concerns around the storage impact of PST versions and will ensure PST file versions no longer consume storage for extended periods. Yeah, and this is in OneDrive for Business and SharePoint online team sites, document libraries. So what they're doing is they're basically saying, yeah, they're basically saying, we're gonna limit this. This is gonna be a retention policy that you can, admins can download the latest version of the SharePoint management shell and start opting out of using this. And it'll allow you to set the limit on how many versions of the PST file that those services can have. So we know, of course, that the PST files are not to be placed on anything involving a network share because they corrupt it if you do that and that includes OneDrive. You're right, and they're saying with the service, the changes in service will always retain a minimum of 30 days worth of PST versions that can be restored from. So OneDrive, and Microsoft is actually saying that OneDrive for Business and SharePoint online will retain multiple versions of a PST file for 30 days. They're not saying, hey, we don't want you to do this. They're saying, well, we're just gonna limit this to 30 days instead of like forever. Well, if it's an archive, okay, but if it's an archive and you're using those files, that's not so good. So I'll have to look into that article some more. Yeah, I got something on my email and they, I thought they made the point that you shouldn't be storing PSTs and SharePoint OneDrive. Well, they even have a note on there that says these changes will have no impact on the actual PST file itself, which will continue to be available. Okay, it's just the version. Inrupted form. Yeah. Okay, so from the, who needs microchips? We don't need no stinking microchips department. The Headspace Mindfulness Content in Microsoft Viva Insights is here. What? Really? Here? Where? Get this. I do not comprehend this whole Microsoft Viva product line. We've eaten a lot of granola and taken hikes and stuff. I got it. Well, get this. You know what this thing is? It's this mindfulness content. It's a curated set of guided meditations and focus music which will allow users to start their day grounded, relax their mind before a big meeting and find focus before starting an important project. The call center bosses are gonna love that. And then the subliminal messages that are gonna go inside of it, that are gonna go right into your brain. Careful Mike. Can I, just tell me, can I buy advertising space in that? What the disclaimer of? This is a lawsuit waiting to happen. So I am actually, I'm a fan of the Headspace tools and it's one of those things where, look I've been working from home for over a decade and as happens with most people that you work for an extended amount of time from home is that you realize how bad of a job you do of separating work and family and other things. You work longer hours, you're staring at screens and all those kinds of things and suddenly you feel burnout. Different things on meetings, on reading and looking at the screens, things like that. So to get, it's for me, utilizing those tools is a great way for it to force me to kind of realize, you know I've been sitting here staring at the screen for four hours. I need to get up and walk around. Of course I have my dog that also helps with those reminders. But to do different things. So I started to pay attention to some of those. I like most people would turn those reminders on and would get them and then just delete or, you know. Dismiss it. Whatever, just dismiss it. But I started trying to pay attention to them and it, I felt better. It did relax me and allow me to focus more on like the next task. So it's, you know the mindfulness thing, you know I get it in an operations environment especially like in a support organization where you're measured on how, you know the mean time to resolution of tickets and opening the number of tickets and per hour and how much time you're spending on those. Like it's gonna be difficult to implement in those kinds of scenarios. But for most information workers, especially that are working from home, I think it's, it can be a benefit. I can just imagine seeing, walking into like a, an operation center and seeing, seeing some of the ops people just sitting back in your chair with their headphones on. Going like this, you know. Flashes red. Yeah, just going, yeah, getting ready for the day. It's not, it's not like they're smoking pot, Mike. That's a future enhancement. You don't know that. You don't know that. That's an add on and only it's for medicinal purposes in some states. Restricted by state. Yeah. I don't know. I just, I guess I haven't gotten into it too deep. So I'm, I'm, I'm, you know, kind of biased because of my own, you know, ignorance of it. So I just think it's kind of weird, this whole Viva platform and what they're doing with it. But that's just me. Well, that's just one piece of it. So I think there's, yeah. Viva's not all about, you know, hugs and meditation. 60% of it, yes. But the rest of the other 4% now. I still remember when I used to get notifications of my Apple watch, I would say, breathe. I'm like, you had to tell me to breathe? What if you've been doing it wrong, apparently. Yeah. Yeah. Okay. All right, moving on from the, it really cannot go away soon enough department. Finally, they have officially announced that IE 11 desktop app retires on Windows 10 on June 15th, 2022. It will not retire on server, okay? At that time, but Windows 10 will lose it. And what they're doing is they're announcing the edge mode for Microsoft Edge IE mode, which provides that legacy browser support within Edge. And really it's, the whole IE thing just has to go away. I mean, it's just, it's taking forever. I get it, there's some things. And now they came out with some kind of app that allows you to, the admin to go and scan a site. And if it requires IE 11, it'll tell it to use IE 11 in mode and in Edge. But, the time has come, it's just gotta go away. You know, I was thinking like, who still uses IE 11? But I remember there are a lot of grandmothers in the world. So. Yes. Well, not only that, there are apps that will call specifically IExplore.exe, that is not Edge, or MSEdge.exe, that is IExplore.exe. As a web developer, you still have to account for it. Yep. It's like, oh, just die. Die already. Yeah, exactly. Getting tired of it. Okay, so a couple of roadmap items that came up, but I thought were kind of interesting is that Microsoft Teams, you could now a coordinator, presenter or the, what do we call that? The person who's in charge of the meeting. What's the official term? Organizer. Organizer? Is it? Organizer, okay. Oh, Nils joined us. Hey, Neil. Hey, Neil. We're just now seeing you, I guess. Someone let me in the meeting. I can't see the screen. I did. Yeah, he's been here for a while, but yeah. Yeah, I can't see the screen. I apologize. I can't see the screen. I've got my copy over the top of it. So anyways, Microsoft Teams, the organizer can now lower all raised hands. And I can't tell you how many Teams meetings I've been on where they're like, oh, just raise your hand. And then you got all these little hands that show up. And then they ask another question. Say, oh, just raise your hand. And they still have hands up. Well, now the org can actually go in and lower all the hands. Sounds like a tool for repression to me. It sounds like something they should have had like a couple of years ago, to me. No, that's great, because you move on to topics. You want to clean slate and let people re-ask their questions. Yeah, that's a great question. Authoritarian mode. Oh, no. That great segue there, Sean, into my next one, by the way. Forcing people to have certain backgrounds behind them. You will comply. All right, on the roadmap, Microsoft Forms will now allow for a shortened URL and response link. Okay, so they use a URL shortener in the response for the forms, but get this. It's going to enable form short URL in government and DOD environments. Can somebody tell me what's wrong with this statement? Are there issues that happened with URL shorteners about three years ago, where people were hacking the URL and changing it to go to their own websites? And now the government and the DOD are going to allow URL shorteners to mine their data and send their people to, you know. But Microsoft only URL shorteners, right? Not third party. Doesn't say. There's no clarification. Yeah, I'd imagine it was Microsoft only. Yeah, it'd be interesting to go take a look at that. Don't say it. Okay. I bet it will soon. Yeah, I mean. Well, I can't see how Microsoft would release this and not have mitigated that potential risk, Mike. I just, I can't imagine a world where that would happen. I was shocked when I saw the roadmap item, but at the same time, I'm like, there's no explanation here. So I don't, you know, read into it, what you like. Yeah, Neil, what's going on with these Microsoft shenanigans? What's your take your official statement, please? Poor Neil. My lips are sealed. All right, that's it, sir, for me for this week. Thank you very much. Have a nice day. Bye-bye. Excellent. And then that's where we have the reverse, the da-da-da-da-da-da-da-da. Music or something. Eventually. So we don't, it's not a high production value, folks. We just, you know, we do the bare minimum here, but. Well, thanks. And so Dr. Neil, Neil, you're here now. So Neil Hodgson. Are you making fun of me? I would never make fun of you. Please come on. Now we have a Microsoft CEO program manager, Dr. Neil Hodgson joining us from the great state of Texas. Hello. Good morning, everyone. All right, so we do have a blend of my failed episode last week, of some questions that nobody saw, nobody heard. So some of the questions, I think six or seven of them, and then the rest new. So we're gonna get through as many as possible. Again, somebody watching on the live stream on Facebook or YouTube, feel free to ask a question, post it there. We'll try to get to those as well and insert those in. As always, you can go out to YouTube and collab talk page on YouTube and you can find our past recordings, as well as a link list of every question that we answer, every topic that we cover, including all of the message center updates that Mike provided. So each of those topics. So you can quickly jump to that point in the conversation. You don't have to wade through 90 minutes of recording. And then you can find these also out on buckleyplanet.com, out on my blog, which again, by late tonight, I should have the list posted and go from there. So with that, unless there's anything else, anything else before we get underway with the Q&A? No. Do you wanna tell people we're not gonna be here next week? Oh yeah, we're not gonna be here next week. All right, thank you. Let's move on to, yeah, so next week is, the 31st is Memorial Day, so we will be gone. And that's it, yeah. I know it's a similar holiday in Canada today. So that's why we don't have Canada folks joining the call. And then I don't know what excuse that Sharon and Sherry and Laura and others use for not showing up and Tracy. Well, so besides the fact it's like 9, 10 p.m. or whatever it is down in South Africa for Tracy. So we'll let that one go. She might be out riding her bike right now. But let's jump in with the first community question. Murali says, hi mates, can we save, sub-site, save as a site template? So save a sub-site as a site template. Means I would like to move a sub-site from a site collection to another site collection as a sub-site. I think we determine this is best handled by a migration tool. Some classic sites you can still save. Sub-site is a sort of template, but you're not gonna get all the data in it. It's a poor way to try and migrate a site from one site collection to another. Microsoft's got tools, third parties have got tools. That's what they're made for. Yeah, also saving, we mentioned saving site templates. Isn't, well, you can hack it, but if you've got publishing features enabled, you shouldn't do that. Yeah, unless you know the special URL. Yeah, so third party tools, that's really where, I mean, why the third party migration tools kind of rose to prominence. And of course, this was back when Microsoft provided very rudimentary migration capabilities and it was very much an admin, but cluster back behind the scenes. But if you wanted to move your, and redesign your site or site collection as you moved it over to a new environment, you had to use a third party tool to retain any of that as well as metadata and a bunch of other things which were lost in just that lift and shift to data move. So, yep. Lots of content out there in this very commoditized space. There's a lot of great guidance out there. I don't know if you guys have any recommendations of people to go and read, but there's just tons of content from the last decade of best practices above it. You can't throw a stick and not hit three articles or tools, I mean, it's, you can find it anywhere. I don't particularly recommend anyone in particular. Microsoft of course has their tool nowadays that'll let you move stuff around. After looking for free. And then anytime I look for migration stuff, I typically tend to reference the folks up north. Well, so I will reference, so my company AppPoint has a tool as well. But one of the things too, is that a lot of organizations realize that it's not as straightforward as they thought. And even if 80% of what you move, it really does migrations of that traditional, that 80, 20 rule, 80% of it will move over pretty smoothly. And then you spend the next six to 12 months on the other 20% iterating on that. But one of the things that your organizations that are saying, well, look, we don't have time. We don't have the expertise to go and do this. There are a lot of companies out there. My company does this, a lot of our partners do this, but provide that those migration services as well. Microsoft provides services around that. So there's a lot of help for migration. Not a new area, not a new topic. All right, question number two. Ron says, I'm running into an issue with the number of private channels in a team. I've actually seen a couple conversations about this out in the socials. I know the limit is 30 private teams, but these remain in a soft, deleted state. And I can't find a way to purge or permanently delete them. So talking about teams, folks, this is preventing me from adding any more private channels. Many are over six months old. Is there a way to permanently delete or hard delete deleted private channels in a team? Yeah, I know I see some of the initial responses from folks that are like, well, why do you have that many private channels? That's not what they asked. It's like, I love those attempts to try and guide somebody around their own question. It's like, they probably have thought of that to some extent, but you're not helping. Well, there's certain things too, is when you think about the architecture of all of your teams. When Microsoft announced the org-wide teams, and there are a lot of us out in the community that we're like, never do that. Don't use it. Like if you're using teams for that, you're using it wrong. Like that's why Yammer exists for those broader org-wide communities and the kind of discussions of people. But some orgs are like, nope, we don't want to have multiple tools. We want to do all this stuff within teams. And then they run into issues about usability of said org-wide teams. But this is something similar where I think initially people said, use it sparingly. It's great to have it, but use it sparingly. I don't know about the 30-channel limit. One of my answers back for this is, it's not an answer to the question, but is to make sure that Microsoft, if you have valid scenarios for more than 30, make sure you're providing that feedback back to Microsoft. So I don't know why it's fixed at 30. Why wouldn't be 300? Why wouldn't we, you're gonna provide the capability and people have valid reasons within their architecture to go and build out and use it that way. Why not allow that? You allow org-wide teams. So why would you not allow this as well? Let's make a mess of everything in every category. Yeah, I just dropped a link to the Limits and Specifications Dock for teams where they talk about soft and hard limits. So they go into all the teams and channels. And in fact, the number of private channels per team is 30, including deleted channels. Yeah, so. Which says deleted channels can be restored within 30 days. During these 30 days, a deleted channel continues to be counted towards the 200 channel or 30 private channel limit per team. After 30 days, a deleted channel and its content are permanently deleted and the channel no longer counts against the per team limit. So I guess the answer is wait a month. Yep, yeah. I don't know if there's a way that you can expedite that through support. I don't know. Don Kirkham just posted on Facebook. He says, people are paranoid that everyone on the team can see their stuff. If they're going to be that picky, just create a new team. There are ways to work around it, yeah. Yeah. That's when I just used my Dropbox. I'm joking, people. Come on. Right in the background question. But yeah, that's, but I think that's the answer there. I don't know if anybody again, if anybody's had an experience, if you'd need it like right now, you can't wait the 30 days for those old, those old channels to drop out, but just to contact support and they might be able to do something on the back end and clear that up for you. Or submit a user voice request to, maybe it creates some PowerShell Commandments that'll do that. Yeah. Or maybe engage in some self reflection and whether or not they have that many teams. Would you say get into your own head space? Yeah, yeah. Meditate on that one, Mike. Yeah. All right, question number three. David says, good morning. I have a team site and when I click on the three dots, the ellipses, the then open SharePoint, it opens the documents page instead of the homepage. Is there a way to point the open SharePoint to the homepage? I don't think so. Because that's all hard coded as far as I know. I mean, you can set a custom homepage on the SharePoint site within the pages library. But I'm guessing this isn't just using the default site URL, it's probably passing a reference for the library. Is this in, is it in SharePoint that the link is saying a team site? But is it in teams where you're linking to the SharePoint, open in SharePoint? Yeah. That's what I'm seeing. That's what I think it is, yeah. Yeah, just to clarify, we're not in SharePoint clicking on the ellipses to go to the home site or whatever you thought it was. That's how I read it as well, is that there's a file that's in Teams and which is stored in SharePoint and you click on that open in SharePoint and it goes to the library where that document lives. Yeah, you take Teams out of the picture. I mean, Neal's absolutely right, of course. You can set any page you want as a default in a SharePoint site, but when you put Teams as a layer on top of that, you're bound by the behavior that seems to be baked into Teams. Yeah. That baked in goodness. Excellent. Is that what we're calling it? I think so, that's the messaging that the directive that I've given by our Microsoft overlords, so yes. Okay. Question number four, Sebastian says, hi, kind of a noob question. I want to read a CSV file from SharePoint using Azure Databricks. Any ideas of how to accomplish this? Mike is talking to himself in his muted state. Sorry. Sorry, not sorry. I don't believe this. Yeah, Databricks is not my thing. Don't really know a lot about it. Might be a homework thing, but I'm not big. I don't know much about Databricks. I've never heard of it till this question. That's one of like, maybe, I think they're at 400 and some features now of Azure. So, yeah. Neil, have you had any experience with this? Well, Databricks is a transformational service. Like ETO. I think they're kind of, yeah. I think they would be better off using ADF as your data factory, because that can pick up from hundreds of different connectors. One of them's probably as a SharePoint site, just looking at the options now in the connectors. It's just a link. Yeah, it's the last question, by the way. So, Don also says, which would be my other answer too, create a tab within the team site homepage. So, yeah, if you're trying to get back to that the home SharePoint site of that's related to that team, and if it's something that you want to have front and center, add it as a tab up at the top. So, then you're not jumping back to the related libraries. You can make it kind of a standard tab across the team. Good suggestion, Don. Yes, ADF can definitely connect to a SharePoint online list, anyway, you can actually build custom connectors as well. I hold formats. You say CSV file in the question? Yeah, yeah. Yeah, well, okay, do you limited text format as a CSV file, right? Yep. Yeah, so it looks like ADF can do it, and I know ADF can talk to Databricks. And then what it's trying to do with the data, you can use both of those services probably to do the thing you want. Cool. I'll get on that today. I'll go test it out, come back with a thorough detail report for everyone. Written in crayon. Yeah, I'm all over that one. All right, question number five. Greg says, has anyone experienced a problem with teams not hearing an external audio device? So we did have this question last week. So I'm using a Focusrite Scarlet, and that was something that most of us had never heard of before, to feed audio as a source, and it's no longer working. It shows up as a mic input, and I even see levels, but when I do a call or test call, the other participant or Echo is not getting the audio. Last week we talked about compatible devices. Yeah, I was just saying, this sounds familiar. Yes, this is one of the repeat questions, of which the audience never heard, so yeah. Really the Scarlet, the Scarlet is just a microphone preamp. It allows for microphones that have an output of XLR or USB, it has a USB connection back, right? So the Scarlet specifically is just a, for XLR phantom power and preamp. So there's really no nothing funky there. If you can't see the Scarlet, it'll actually show up as a Focusrite in your audio. And if he's saying actually that you can see it, the source as a source inside of his, when you click on the little speaker icon, if you can actually see it as an input source, then you're having problems with Teams itself. And I mean, I've had audio and video problems with Teams and I've just had to uninstall and reinstall and sometimes I've had to do it twice. That's the only way it picks it up. Yeah, this is one of those things that we also talked about. Be very careful with your setup. If you're buying new devices or new preamp software, all those kinds of things is go into your research. If your primary communication tool will be through Teams, make sure that it works through that. And just about every product out there should have some community discussion around people with their Teams experience. Teams is pretty widely adopted now that you're seeing plenty of information back. So I know that there's, people go out and purchase the latest and greatest technologies, want to plug it in there, video cameras or mics, and then are frustrated when it doesn't work or doesn't work consistently with Teams. And so that's what you just wanna make sure that, you know, that it's approved for, it works with, it's compatible with Teams. Yeah, the corollary, never buy version 1.0 of anything. Yeah, depending on what you're doing, yeah. It's, that's why, it's another reason why I have, I've got multiple mics, but I have the one that works most consistently. It's the one that I leave plugged in. So I've got a more expensive mic that I use when I'm just doing in-studio recording, like music, but it does not work with Teams. All right, let's see. Question six from Gary. In Teams, my status bar shows I'm busy right now. I am not busy. I am not, and a number of people comment on this. It's like, of course not. You've got the time to chat within post questions to Facebook. So obviously not busy, but it says I'm not in a meeting. I'm not on a call. It doesn't seem to align with what I'm doing. Anyone have the secret key to- I do not like green eggs at all. Anyone have the secret key to unlocking the issue? Is it installed mobily? I mean- Well, so the first thing is that if you manually change your status, and cause I'll do this where I will manually go there and say, look, I'm out of office here. I want to show is out of office. I'm moving in between a couple of different things, or I'm doing a webinar on another platform or something, and I don't want to be interrupted, and I'll make that change, and then I'll go back in, I'll be in other meetings, and realize I never reset my status manually. And so that's one way that that happens. The key's off. For me, it's kind of like anything I have in my calendar. Yeah. It's going to show up as something I'm doing, and that could be pretty much anything that I've got connected to Teams throughout look. It just does, you know? Yep. Yeah, and a lot of people forget about their mobile client, and you do not have different statuses based on the client in use. You've got one status, and so if you've got something on your phone that's not on your desktop or vice versa, that might explain it as well. It would look everywhere. I like the two with the kind of house point. If you're, well, if I go in my outlook and I delete a calendar item, it's not refreshed yet in the calendar over on Teams, so Teams still thinks that meeting's happening, so that's another scenario what's happened where it's not refreshed. Yep. And it just kind of locks into that view. Yeah, I'm not sure what the process is, like how often it goes through and kind of checks that. I've seen delays where it's 30 minutes have gone by, it's still showing that deleted meeting, deleted it outlook, still showing over in the Teams my calendar, and therefore it changes my status. I'm not sure what that frequency of that refresh is. I would hate to see what a flow chart looks like for that status indicator for the ultimate determination of what gets shown, because I can only imagine all the different things and sources and timing and whatnot that have to be factored in. Somebody probably became an alcoholic coding all that. They could have been an alcoholic when they coded it, which is part of the problem. It just, it was messed up from the beginning. Why did I have to do anything with the code to become an alcoholic? I know. I know. I feel like you don't understand people, Sean. Ah. That's what my therapy says. All right, question number seven, Sven says, is it possible to give users of my Microsoft 365 Business Tenant a Teams-free license? They should only be able to use Microsoft Teams, nothing else, not even mail. No. I don't think so. No. Simple answer. No. Yeah, and I've got a couple of links which I'll put in the blog post about adding guests to a team. So you can invite anybody, they don't have to have a Teams license to go in there and participate for that activity, but to give them a license that's, I mean, I'm reading this as tied to my tenant. Like, is there a free version I give out and like, no. No, no. And the thing about it is I've seen people that have actually, they have their Azure AD account, and that's what they get their paid license through, right? But then they'll use their personal account and they'll get a free Teams license for that just on their own personal account. But that's totally different. That's not, the two are completely separate. And from a business aspect, you shouldn't even be entertaining that. So. Yeah, you would just, you could, again, they don't have to have a Teams license if you want somebody to participate in a meeting, but they'll just be viewed as an external user that you would have to allow for that and then invite in using that email. Now, for a live event, that's a little different. This is, we're talking about meetings now. Yeah, meetings. For live event. Live event, a guest user, well, no, that's gonna change, right? Cause that was a roadmap thing that I brought up a couple of weeks ago, was they're gonna allow for guest users to be presenters in live events. Before they couldn't do that. That was one of the limitations. When you had free license, you couldn't present. Now they're gonna allow that. So. Yep. But I think that the kind of the, I think the point of this question is that, so he's got his business tenant and wants to have people that are part of that business tenant, but not account tours. They're allotted licenses. Wanted to be able to hand out free, so Teams only. And he's like, nope, that's not how that looks. If you want that, and to be associated with your tenant, your business, then they will be paid licensees. Otherwise they'll be external users. Yeah. All right, question number eight, AuraFull says, how come some of my external contacts show up under contacts, but not others in Teams? Do I need to manually sync this with my Outlook contacts periodically? So that's a great question. It is because I've seen that happen as well. And it's just a matter of sometimes, I don't get the whole Outlook syncing contact thing to begin with, because sometimes, you know, you'll have that cache where you hit the two line and you, you know, it doesn't show up even though it's a contact. And, you know, it's, and I think the same thing is kind of spilling over into Teams too. So Hal, is it actually pulling from a centralized contact database? That I don't know right off hand what Teams is actually looking for an Outlook. I would assume it would have to be the contact list. But the gal. Don't forget. Yeah, but don't forget Outlook has got two different areas that it does things. If you start typing on the two line, that is a completely different, that's the auto complete cache and that and the contact list do nothing of each other. So, kind of... Hal, is that something you'd be willing to take us homework to find out where that's pulling from from Teams? I'll see. Okay. Yeah, that'd be good to have an answer to that. And for those that are joining and watching, so yeah, sometimes we, if we don't know an answer and we think, okay, there's value in us going and finding this and post this and we'll share it next week or put it in the blog post if Hal's able to find an answer pretty quick. Sometimes we just don't know. Right. Yep. Well, sometimes we might have the answer before we're even done with the live stream and go back to the, come back to the question. So, all right. The next question, number nine, Naan says, hello everyone, I'm set up a SharePoint site for my work regarding to the permission level. I see that restricted view was available in SharePoint's permission level, but when I add a user in that, they cannot access the SharePoint site. Anybody help me fix this error? So there's another one which we discussed at length last week in the lost tapes of the, restricted view is just a traversal permission. Allows you to traverse, right, Neil? So, like mountain climbing, that's what you're saying? Or maybe in words that other people understand. Okay. Okay. If you have restricted view, you can see different structures. You can navigate through directories, but you don't actually have permissions to content. Right, thank you. Is that simple enough? Yes. This is as simple as I am. I was just, for the benefit of people that didn't watch our last week's deleted episode, where we answered this already. To expand. I don't think I lost my connection by that point, so I don't even think I got my first crack at this yet. Sorry. There you go. Neil, were you gonna add something to that? Yeah, about the traversal, there's a, excuse me, there's a, the limited access permission is a traversal permission. Oh, yeah. The read, I'm not a restricted reader. Stricted view. Well, restricted read allow you to view pages and documents for publishing sites only. So it's some custom brew of permission levels for publishing sites. Yeah, but normally when you add someone to a, if add someone to a permission level in a list, it would by default give them limited access to the site for that exact purpose, that traversal permission. Yeah, as with anything, to understand first what you're trying to assign to the user, allow them to go and do, and then two, to understand the definitions, the various permission levels and custom permissions that have been set up to make sure you're assigning them to the right one. So this is one of those where it's working as designed, I think they're trying to give them access to something other than what they should have access to, where you want them to have a read-only or restricted read-only and create a custom permission level. Yeah, I included another link in the chat over to SharePoint Exchange, Stack Exchange, goes into a little more discussion of it. But if you notice the link that this person included actually goes to the discussion on Microsoft community sites and they're different, I think they're looking for an easier answer. They maybe don't want to craft their own permission level or permission set of permissions from permission levels, the constituent permission level. So I don't know, I don't think there's an easy answer to this one, but there is an answer. It's out there, something. It's out there. The truth is out there. The truth is out there. Maybe. SharePoint Next files. I have been watching all of the UFO videos this weekend. My wife told me something about that. They are now confirming that there's weirdness. Yeah. June 2nd they release, or June 22nd? I'm like that, they are gonna release all the classified files. Well, for the folks that don't know what this is, this was like the, what was it, like 60 minutes did a thing on it and there's been a lot of discussion around the individual, but it's the government, the US government has confirmed that they don't know who built them, what they are, but those three videos. But the other thing I understand, because the first complaint that everybody has is how grainy and poor quality those videos are. It's like, yeah, that's the one that was released. They have higher definition videos and they have more data. I've seen the one from the International Space Station. Oh yeah, of the thing that went within the site, yeah. I mean, I was like, wow, that's kind of, if I was on that space station, it'd be like, you know, next thing you know, you're gonna hear a knock on the pod bay door, how you're gonna, you know. Well, for all the doubters out there, it's the little things like decelerating, accelerating again or changing direction. Yeah, not some natural phenomenon. So again, I like the standpoint of some of the military types that are saying, look, I'm not saying that this is some aliens that are out there, I'm just saying that we don't know what it is and it is way beyond what we can do. Which- Does it obey what we physics? Yeah, little issues. Little ones. So. I just wish they'd come down and say hi. That's all. Hi. We're here. I just want to know what's up with all the- Mike wants his probe. I just want to know about, yeah, the hat, yeah, I was going there the same thing. I was like, I just want to know, it's like, what's with the anal probes? Hashtag don't- That's nasty. Hashtag don't probe me, bro. You guys are nasty. Well, Christian and I just kind of run in the same batter at times. Now that's a T-shirt idea. Hashtag don't probe me, bro. Yeah. We can send you tons of T-shirts, yeah. And for those that, by the way, on this topic, if you've not seen the SNL episodes, that it's, is it Kate McKinnon of where it's the, with the Brian Gosling and- She's sitting in a chair. Slouching down of the, have you seen that one, Sean? No, we can't have them. So they are fantastic. There's multiple, multiple episodes where everybody's cracking up and Kate's just fantastic in it. We're talking about- He makes Gosling stand up and she gets behind Gosling and she's like showing him how they did the probe on her. But it's like, it's like two other witnesses, they're talking about their alien encounter was beautiful and there was a bright light and I felt love and warmth. And she's just like, well, that's not what I experienced. And then goes through this horrible experience. It's like, I wasn't dealing with the high-class aliens. I got like the lower level guys that were, yeah, it's worth checking out. So funny stuff. Big apple. All right. Alan Neela just looking at it, it's like, what are you guys, what is this? Hashtag don't probe me, bro. Yeah. All right, question number 10. Just a tad on the homework before we get to the next one. There appears to be some issues without happening. I've added a couple of links about people who don't see things and then a couple of links about how to add them if you don't see them. But it does appear as those are some issues between teams and outlook about getting all the contacts in. Any known resolution or are they just acknowledging that there's an issue? There's a user voice on the issue. So it's something that's being looked at apparently. Okay. Included the user voice link. Thank you for that homework. See, we just, you know, close out the homework as well. All right. All right, question number 10. Carmelo asks, I want to ask the group some questions. I would like to add a SharePoint server to an already existing domain. I installed the SQL server as a local admin than when I got to install the prereqs for SharePoint. It tells me that the app fabric configuration is not exact. I state that the installation of the prerequisites was done entirely without internet access. Is there a guide that allows me to configure app fabric correctly? Is there a guide on SharePoint offline installation? And so, I know this is one that we talked about last week and I've got the links that I'll include the blog post both to the installation prereqs for network share and for installing SharePoint 2019 offline. So I've got those links. So yes, there is guidance there. Anything else you guys want to say on that one to close out? App fabric is a product of the devil. Okay. And I'd suggest CU six or beyond if you're trying to do anything with it right out of the gate, patch it up. That adds background, garbage collection and all sorts of other stuff. So it makes app fabric much more resilient. So what's going on there if they're trying to install and saying that app fabric configuration is not exact? Is it just like they've got an older version they need to update that or what could be causing that issue? I'm not exactly sure, Neil. Well, I'm just looking at some, there's a whole bunch of blogs on this. It looks like, no, that's not it. You might actually trip across one of mine from years back. That's kind of a classic. Try that first. I don't know specifically, but I mean, you shouldn't have to configure app fabric. SharePoint, they install or should do it, I'll follow you. Right. Anything that could be interesting is whether there's any lockdown on the server itself so it can install properly. Oh, like GPO? Yeah. So, Carmelo, if you're not your domain admin, you may wanna actually have a conversation with them or run an RSOP to figure out if there are any GPOs acting against you. But app fabric, for anyone familiar with SharePoint and installing, app fabric is to SharePoint 2013 and beyond what the user profile service was to SharePoint 2010, which is an admin nightmare. Oh, the other thing to check is that if you're doing an offline install, make sure you've got the exact correct version of app fabric because there are multiple versions out there. SharePoint one's a little different. I think that we provided there the install pre-rex from network share. Yep. Okay, question 11. Nucle says, I was using Azure Pass and had set up two Azure VMs. Later, I had to change the subscription to Pay Go, Pay As You Go. Now I am unable to access my VMs. Please help. Yeah, this is one that we had. Oh, and the crying emoji after that, just did. Yeah. Yes. Yeah. I hope this is a question we had last week here. This is a similar question. I think this is similar to, but it's a new question. Yeah, so if anybody doesn't know what Azure Pass is, Azure Pass is basically something that was given out to students, user groups and things like that to give them access to Azure for credits, like $100 a month or whatever. So you create an Azure subscription, use the Azure Pass. And then once the Azure Pass ran out, it actually converts to a pay as you go. So there's no interaction required by the user to do that. Microsoft automatically doesn't. And the resources that are contained in that subscription, nothing happens to them unless they don't pay their bill. You know, they get a bill for the first pay as you go a month and they don't pay it, then obviously it goes into a suspended state. So I don't understand why they say they can't start their VMs because they're not able to access. Well, okay, so even accessing them, nothing changes in the sub, right? Microsoft doesn't take anything away when they switch to pay as you go. I mean, they want you to have those resources because then they get the charger form. So I'm not sure why. The change in subscription more than likely had nothing to do with the change in their access. Well, let's talk about the VMs. I mean, once they, the question is, what does it mean by access? Was it normally like removing it into them? Or are they, because they will power down once the Azure Pass expires. So they will go offline. Not unless it's converted to pay as you go. And if the user follows the instructions that they get from Microsoft, because Microsoft will send them and say their subscription is almost expired, it'll be converted to pay as you go. If they follow the instructions in that email, then nothing will happen. They won't power down because the subscription gets automatically flipped. If they don't follow the instructions in that email, then yes, that probably will happen. I haven't had it happen, but it probably will happen. So it's a support call to find out if they didn't meet the timeframe or if they didn't follow the steps properly. Because then if they don't put it, even when you put an Azure Pass in, you have to have a credit card. Azure requires you to sign up with a credit card no matter what. And if that credit card comes back and it's not, it's declined or it doesn't have, you can't, they can't charge to it, then yeah, you're gonna go and just suspend it. And they're gonna power everything down. So let's say they missed that window or they had a problem with the credit card. They dial into that. Is there a timeframe before that, those VMs are gone? 30 days. They get 30 days to rectify it and then it goes, because 30 days is a live recycle bin. Microsoft has another internal recycle bin for a time period after that, but they go into a state where you have to contact support to recover them. All right, question number 12 from John. Hi, sorry, this is such a basic question. I belong to a Zoom. Oh yeah, this is an interesting question. I belong to a Zoom screenwriting class of nine people. Every week, three to four people send emails with attachments of part of their screenplays for the class reads. I'm wondering if we can start a Teams group where we post the scripts with any follow-up comments in one stream. It would save sending all the emails, collate comments in one place, allow other documents to be uploaded on the stream and keep the scripts in one place. I haven't used Teams yet, but wonder how practical this is for people on the free Teams plan. We only need to post documents with comments as we're using Zoom for meetings. Can we do everything online so people don't have to download the app? Well, you can use Microsoft Word. Well, collaboration mode. Yeah, in shared in one drive, that's another way of doing that. But yeah, with the, so for the free Teams, can't you just also use free Teams just in the browser? Yeah. You'd have to sign up for the free version, but you don't have to download the desktop. You could do everything within the browser and then do exactly what they're talking about. Yeah. We don't know what kind of, what they're using for the, it doesn't say in here, I don't think what kind of documents they're using for their screenwriting. You know, is it a Word document? Is it a, you know, what's being used for that? Is it a notepad? I don't know. But that kind of depends. I mean, if you're going to use it in Teams and you use the Word link, you're going to use Word online, right? That's the only way you can do it for folks that don't have Word installed locally. Well, I don't know if they have Word or not, but they should be able to, you know, but that's a good point is like if you're sharing files, hopefully they've all, you know, agreed on a certain format for that. But, you know, you can, you know, also you can upload multiple document types that most of which have readers and share that one place. But the basic, the answer to the question is that, yes, you can use the free version and upload these documents and then have a conversation around those things. And you could even, we talked about this, you could even create a tab. If you have a recurring Zoom meeting, you can actually have a link to that invite up in a tab or create it however often that you meet for that week and have it all in one place. So you can actually, you know, do a, you make it even easier to facilitate those discussions and have a link to the Zoom as a tab within Teams. I just always liked, that's one of the best things about Teams is having all the relevant tools that you're using for a project all in one place. So, you know, if you have, but to your point too, is if you're centralizing the scripts, you could just have like a shared one note, also as a tab, and have everybody just adding there. And so they can use that online, you know, just in the browser or they can have the desktop version that's synced with their script, their tab within one note. So, one note. One note's pretty, one note's pretty too, right? Yep. They have a free version of that, so. Correct. All right, let's see question number 13. YNAND says, my search functionality was working 100%. Now it says we could not find a match. This is a Teams question. So, my Teams search functionality was working 100%. Now it says we could not find a match. How do I resolve it? I don't think you read that question correctly, Christian. Should I have been yelling? Because all gaps- Because you guys are yelling. We could not find a match. Is that what Teams does? Is put it all in gaps? So, we could not find a match? It just, that feels very shouty. Yeah, so it doesn't feel right. Why are you yelling at me, Teams? Why, stop. That's why people need headspace because of all the yelling that happens with system messages. Or to switch out of old secretary mode. So, could find a match, why is that? My first thought was change your search terms. Or put the document back that you were trying to find. So, let me ask you this, does Teams have, in their search, and I haven't looked at this, but does it have, I mean you can use everything like operators and all that other kind of stuff, like other search, where you can do and ors, quotes around full set, what you, full content. You have three words, you put quotes around it, that kind of thing. Does Teams work on that type of basis? Or is it more just for text? It's just gonna search for a word. I think it's straight Microsoft search, isn't it? Yeah, I think so. I don't know that, I don't know. And if it is, you would be able to use basic operators, exact terms with quotes, things like that. I don't know that it supports full KQL. That's typically thought of with classic SharePoint search. I don't think modern search goes there, but. If you put, I just tested the quotes. If you put quotes around it, it does limit it to the actual search for the phrase, and doesn't break, doesn't word break. So those. So presumably you can use some there. I have never used a search function in Teams, so I don't know. I've never had to search for anything in Teams. Sorry. Yeah, I don't know. Yeah. Oh, there's one of those. Sorry, it does support things like, like if you put like, I just searched for one of our roles in that senior customer engineer. I searched for senior customer engineer in quotes, I said that's the test I did to limit it. A search for senior customer engineer, nothing quotes, and it found, she found a lot more results. Now I started putting like minus engineer, senior customer minus engineer, and it's excluding engineer from the search. So it looks like there is some stuff up there. That's cool. So to answer this question, it sounds like, well, one, if you have very specific restrictive, call or search terms that make it broader, and maybe you'll find that, or two, you'll change up the terminology. If you're looking for a specific document or something that's out there, what another reason it could no longer be found is because the permissions to that file could have been changed or the file could have been removed or deleted. If there's, so this is one of those need more information about the results that you're not seeing there. Like for example, if I search for something and pull up five different conversations, then I'm talking to somebody else on that topic and I go back and do the exact same search term and it's now not finding those five conversations. Could it be that your access to that team or that channel has been removed or restricted? I mean, there's a lot of stuff that can happen in a live environment that could change, seemingly change your access to a file or a conversation. So, yeah. I dropped a link in the chat. It goes through some search scenarios, but covers search for messages and more in teams. So, yeah. Love that link, traditional link. Speaking of URL shortness, exactly. Are you saying people with limited detection spans are going to be challenged by this one? Well, if you take, if you sit there and read it, take out the percent 20, which are just spaces, right? And you try and read all the text that's in that URL. So, folks, just jot that down very quickly. Yep. All right, question number 14. John says, how is everyone sharing recorded meetings with outside guests these days? YouTube. Yeah. One drive and stream, I get it. Stream not so much. What are they changing stream to now? Aren't they switching that or was? Stream still exists, it's still there. Yeah, but by default, I think they're putting them in SharePoint libraries. Yeah, they're putting them in SharePoint libraries now. But one drive, whatever video service you'd like, sir, because it's basically a MP4 file, right? Depends on the audience, yeah. Yeah, so. Have a video. Yeah, so there's something like all, if I am sharing something externally, if I don't care that people that I don't intend to show it to see it, I might put it in an unlisted YouTube site and so that I can share that link out. And if other people discover it somehow, that's fine. But if it's something that you want to restrict, who can see it? You can put it in your one drive and share that link out and make it only those that you invite people to see or you can make it even more restricted and put it within your organization or your SharePoint and own those people who have the correct permissions to see it. But stream does a lot of that and there's nothing wrong with stream as well and more restricted, internal and enterprise view of that content, then stream is a good place for that as well. So you've got multiple options there depending on your use case. Not that I want, like I know people that use Vimeo as well. That's another place where they will. You gotta pay that, pay for that though, right? Yep, for those people that just don't wanna use YouTube for any reason and have, but it also is more controlled so they can, if they want it more secure. But yeah, it's paid. You can live broadcast it on Twitch. There you go. Yeah, there you go. That's right. Question number 15, Juan asked, I have a SharePoint document library when I try to give direct access or share a subfolder, I get the error failed to grant access. Does anyone have this issue before? Cause clearly Juan just trying to give access to it so how he failed to grant access, I have no idea. It's not his failure. It's not your fault Juan. There are all sorts of links out there for you and for various scenarios, everything from trying to grant access to new folders, admins granting access that the folder has too many items and I mean, we could list them or you could SharePoint document library quote failed to grant access unquote, you'll get a bunch of them. So, but it's gonna depend on the specifics. There we go. That's where I need to have the sound effect ready to go. The ding, ding, ding, ding. Juan said it depends. That's the default answer for half the questions asked but, yeah. But yeah. Yeah, there's a few different reasons why. All right, 16, Manish says, hi, I have an enterprise requirement where I need to deploy a software to multiple tenants so multiple organizations registered with my enterprise. So basically, I need to provide these orgs, software as a service, service. Can you please provide me the best way to deploy software releases to multiple tenants in one go? I would be more inclined towards DevOps approach here but please suggest me that there's a better approach. Just the idea is I don't want to do the software deployments by going to individual tenant and there are more than 100 of tenants. I'm talking about here, thanks so much. I don't understand why, well, I guess there's not enough information and I don't understand the whole DevOps approach. All you're doing is you're providing a software catalog. Am I missing something here? I mean, you just, I, the first place my mind went is, if you are offering software as a service through your company, are you in some sort of app store which supports updating logic? Because I understand the requirement in the position. You certainly don't want to keep sending email that people update your software to the latest version but the Microsoft app store, it all comes down to the type of software they're publishing. It can be a marketplace. They can publish to the marketplace. Exactly. It depends. I mean, if it's going to be a Windows store app or it's going to be a marketplace app because you can actually have private marketplaces as well. You can have private offers inside of the Microsoft marketplace. A lot of different options there. And classically in the SharePoint space, we've got the SharePoint store where depending on the technology used to build your application, you can put it out there. There's all sorts of controls that software publishers love to have. Licensing support, monetary support, all that kind of stuff. So I would say the first thing to do, Manish is to figure out if your organization has a presence in one of these. And if not, I would highly suggest getting your stuff approved for listing in one of them because it is a process. They're not going to just let anything in. And Azure DevOps has it built in. I mean, I understand, I'm not understanding, you need more information because Azure DevOps does have the ability to publish directly to a marketplace or to an app store. But you have to have that all set up. That all has to be, you have to be approved by Microsoft. You have to sign a paperwork. You have to do all that fun stuff. I was reading this more as Manish works for an MSP. So they've got, I read this, they've got potentially hundreds of tenants that are there because they're purchasing solutions or they're purchasing or they're getting their Microsoft 365 through this MSP. Is there a centralized way to go and deploy the solution? It's like, well, the first thing, it's for the core services, the Microsoft 365 and the updates that happen there. That all happens as part of the service. And there are some MSP, I said nuances to that depending on the level of service that they're providing. But if your value add as an MSP is to add these other solutions, whether your own or third party solutions, that's part of what your clients are paying for. Is there a centralized way to go and deploy that? So there's the create the apps, like you can create a marketplace for any of your customers within that subscribe that use your MSP. You can have your MSP XYZ marketplace with all of the solutions that have been approved by you, the MSP, and they could all go to those. Or they could be a marketplace that's created for one or multiple, you know, customers that are consuming that and have access to that other approved marketplace. But is there a way for me as the MSP to say I've created this new app, I want to deploy it to all 500 of my customers within my service and to deploy that broadly? I'd like to check. I don't know if that is a feature in Lighthouse or not. I don't know if Azure Lighthouse allows you to, I know you can notify all of your tenants through Lighthouse. You can have like a, you know, a notification blast to all of your tenants, but I don't know about you can actually click a button to deploy software. I know on a specific tenant basis, you know, that's something like Intune app publishing would also support and you can mandate an upgrade or force it depending on what sort of MDM enrollment you've got. Yeah, well Windows 10 or MDM because Intune covers Windows 10 now, so. But I don't know how many tenants that goes across. So is that a homework item or? I don't know if it's a homework item because we need more information. I mean, it's, I think it's something that Manish has to go out and do his homework on, but I would specifically look into Marketplace. I'd look in to see what your organization, like you said, what if your organization already has something set up as a Marketplace provider or an app store provider from a developer aspect. I'd look into Azure Lighthouse to see if that helps you at all. And then I'd look into Intune. Maybe Intune's gonna solve it. If you're just, if you're, if you're when he talks about tenants as he actually, are they managing all the end points at the tenant? Because if they are, then Intune is probably the best way to go because you have control of all the end points. Right. You know, so. Okay. Let's see, we can squeeze one or two more questions in here. Number 17 from Ashik says, how to add a column and a SharePoint list in which you can upload a document such as a PDF. We get a variation of this question. Yeah. Every couple of weeks. There's an option to add an image column, but no file upload column. Yeah. I don't think there is. I mean, I don't remember the answer to this, but. A lot of lists, if it's just a standard SP list, you can have an attachments column. And so some lists, not all of them, but certainly some of them. Yeah, if they're set up any number, you know, document library support, a single attachment, SharePoint lists, multiple attachments, but you know, that's. Can you have an attachment column though, in that list? Can you actually show that document library and then have an attachment column? That's what I think that's you're asking. So I mean, sorry, a file upload column, or you click on the little paper clip and it asks you, you know, pops up the box asking for a file location. Well, the thing is with a list, the attachments are treated somewhat specifically. They're not standard SP fields. Cause what this would imply is that they want kind of an unstructured binary upload field. And anyone who knows anything about SQL server behind the scenes knows that, you know, SharePoint is heavily optimized to make the best use of SQL server. You're not going to be able to upload those sorts of fields directly into SharePoint lists. They're all part of that attachments column, right Neil? Yeah, I mean, they are, but there is a column where it does give you a button to upload. Right. A file. You're not going to be able to create multiple columns of type attachment and have multiple fields. Cause it's, the way I'm looking at this, and maybe I'm way off base here, that's not unusual. The way I'm looking at it is they have a document library and they have the names of the documents. Okay. But they put the names without any actual file attachment. You see what I'm saying? And then they want a little attachment thing where users can click on that and then actually upload the document under that name that they pre-created. I don't think you can pre-create in a document library. I don't think you can pre-create a name unless you upload a document to it. I'll click on the new document. Okay, do you see what I'm saying though is that they have a pre-defined list and then they add a column of just paper clips and being able to click on that and the user can upload into that pre-defined list into that pre-defined name. So a standard SharePoint list supports the type of behavior you're talking about and you can upload an attachment. It's provided that the list is configured to enable attachments because that's not a firm requirement. And it's not on by default? It's not on by default? I believe it's on by default. Okay. But a document library kind of flips things on the end. You've got to have a document which is the single attachment and then the list item is built. Okay. All right. Support that. Okay. A standard SharePoint list will support this behavior but again, if you're trying to work with the field data it's not a standard field like a multi-line text field or an integer field or something you might build. There's like any number of attachments zero to any number can be associated with that list item. Got you. Okay. All right, well gentlemen, we are at time so appreciate all of your input again this week. Nighting flies. Are you having fun? Yeah. Yeah, butter. And then there's this, yes. No, no, really. Happy Monday, Christian. Just sharing the, spreading the love wherever we go. So thanks again for everybody that's watching and if you're watching on the, one of our recorded sessions. Again, you can find all this out on YouTube and the collab talk channel, all of our past recordings. This was episode 60. We'll be back again in two weeks. So next week for us is a holiday here in the U.S. And so we'll be back after that in the first Monday in June and doing this again at eight AM Pacific. And again, this is 60 and three eighths. That's right. This wasn't 60. It's 60 and then just the asterisk. That's right, just to explain what happened last week which is a failure of me and the technology. I'm gonna lump us together in that. We had there was failure to communicate. That's right. Exactly. So, well, thanks a lot. Thanks everybody. So again, to Sean, Mike, Hal, Neil and everybody else that didn't make it today are dead to us for two weeks. Yeah. So, all right. Thanks. Great week, gentlemen. Thanks a lot, everybody. Bye. Bye. Bye.