 I guess I should unmute there for the beginning, but welcome everybody to another episode of Office Hours, where we'll be discussing all things Microsoft 365 and answering questions from the community. My name is Christian Buckley. I'm an Office Apps and Services MVP and a Microsoft Regional Director, and I'm on the Microsoft Go-To-Market Director at App Point. Joining me today, and I'm going to try and go by order of the dam and joined this, but we have, so Neil Hoskinson was first to the lineup here, but dialing in all the way from Kim Kuhn, it's rough to be Neil today, this week, or the next two weeks. What on earth is he doing here? Yeah, then we have Mike Nelson, a solution architect at Pure Storage and a cloud and data center management MVP based in Appleton, Wisconsin. We also have Hal Hostetler, a senior field engineer with Roland Shorten Tower in Tucson, Arizona, and an Office Apps and Services MVP. We were then joined to take the order, yeah, Sherry, then a Microsoft Certified Trainer, Microsoft Office Master and Co-Founder for Power Up Learning in Colorado Springs, Colorado. And then we had Sean McDonough joining us as a consultant with Bitstream Foundry in Cincinnati, Ohio, and an Office Apps and Services MVP. I had like a breath mint 20 minutes ago. I'm still salivating too much, so apologize for that stumble. We might have Eric Riz and or Mark Rackley join us later. I think Sharon's out. I'm not sure if Tracy's gonna make it, but we'll move forward, we'll do our best. How's everybody doing? Yeah. It's Monday. I was doing better on Friday. It's always Monday when we connect and talk and do this. Right there. Yeah, I suppose so. I had a great weekend, I could relax in Cancun, but now I'm working in Cancun for a week. Well, probably till Friday morning. The life of a Microsoft consultant. I'm not a consultant. You're an internal consultant, Neil. The life of a Microsoft employee. Change, but find a scene, what's a good scene for? So I kind of like the space, the UNSC, there we go. Do you know why you're working in Cancun, Neil? Because you can. Sorry, say again, Sherry. Why are you working in Cancun? Because you can. Because I can. Because you can, right? It's actually cheaper to book two weeks in the vacation resolve than it was to book one. Oh, wow. I thought, okay, that works. So discount with our travel club thing. So if you increase the amount of time that you're in Cancun, does it get cheaper and cheaper until eventually they're paying you to live? Does that work? Paying to Pliny. I can ask. Yeah. Yeah, just if you stay for four weeks, will it be half the cost? Just as I said. Is that homework? Yeah. Anything else going on this week? Anything else exciting happening? No, you just had RD get over with it last week, didn't you? That's right. So I had the MVP summit two weeks ago, RD summit last week. And yeah, some really good sessions. There were, you know, a number that were duplicates of the MVP summit, but the ones especially that were RD led on kind of special topics. I mean, it's just always fantastic. We had a great session. Obviously I can't get into details of any of the stuff that we went through, but there were good sessions at both events around community development, community building and support for conferences and webinars and hybrid events and that kind of stuff. So it's always great to hear from other experts out in the field. Yeah. Yeah, I don't know how everyone else is, but you know, since a lot of conferences have gone virtual, I find it very hard to a lot time and stick to it to catch conference sessions. Yeah. I mean, I've got like high priority client work and it just trumps things. And I can't, you know, that physical act of going to a location actually got me enough distance, both mentally and physically, that I could focus on the conference, but I can't seem to do that anymore. Yeah, I would agree with that. And one of the points that came up, we were having a discussion just about this last week because a conference that we're actually putting on was like going virtual and folks were like, it's not the same, you know, it's really hard to be able to do this for three days straight. So we're splitting it up over three or four hours per day, but it's going to stretch over two weeks rather than just, you know, and to be honest, I got asked to do a session for, and there's a PowerShell, the PowerShell Summit, I don't know if you're familiar with that, but it's a big thing that happens every year. Sounds cool. Yeah, it's actually a replacement for Microsoft, used to have it, now a group runs it out of Minnesota, but the PowerShell and DevOps Summit. And the thing about it was is that their conversation was around, they're actually, they're charging, you know, they're charging. Yeah, so to register, it's a fee. And my question was, it's gotten to a point now where, you know, for a virtual event, you're charging people for the rights to view your content after the fact. And I said, you know, a quote on Twitter came out and said, it's pretty much just like Netflix. So virtual conferences are turning into Netflix that you're paying ahead of time to be able to watch the content after. You know, and to me, that makes very little sense in my mind, it just says, otherwise what are you paying for? What, I mean, there's no special access. There's no, you know, events like live music and places, you know, all the stuff that you get when you're an in-person event. And no swag. No swag. Yeah. A per view power show. Exactly, exactly. So I'm trying to understand the justification for charging for something like that. And so far, everybody I've talked to, they really haven't given me any valid reasoning. I mean, it's not, to me, it's not valid. I hear you, Mike. I don't know if anybody else has any opinions on that, but it just, it was, it got to an actual argument. So it was quite interesting. Well, Mike, do you want to take us through? Do you have any community center updates? Of course, I do, Chris. We don't want Chris to do it again. Yeah, how did it go? How did it go, by the way? It went beautifully, Mike. It went over like a lead break. All right. We'll have a couple of garlic think buses if anybody needs one. All right, folks, I'm back. We're going to be talking a little bit about SharePoint. First of all, my favorite topic, not. And the thing about it is that they've come out with SharePoint release that will give scenario based site templates. So this is really cool because one of the things I've always fought with is when I go into SharePoint and I want to create a site and I'm like, I'm really stupid at SharePoint. I'm really stupid at creating really cool sites in SharePoint. You usually have to end up paying, really, really, really, really smart people like Sherry and Sean, a lot of money to create a really cool site for you. And I'm just giving them a hard time. I don't mean that. But now they've actually come out with just a whole bunch of other sites. So communication site templates, you can go department, leadership connections, learning central, which I think will be a big hit because a lot of folks use SharePoint for the learning aspect. Employee onboarding, showcase, spotlight, an event. So if you have an event, you can spotlight it. Otherwise people were just using the basic, I think it was a blank or something or a basic or a team site. Yeah, then they'd have to take widgets out and the web parts out and they'd have to move things around and all that other kind of stuff. They've also created team site templates for event planning. I think they've always had a project management one, but they say project management here. Training in courses, training in development and team collaboration. So I think this is kind of big, especially for folks that are just trying to create a cool site that matches what they're trying to do. And I think it took a little bit too long for Microsoft to come out with this, but I think it's good. So the one question I have is, how's it different than the FAB 40? Then the FAB, what is the, I don't know what the FAB 40 flashback. Microsoft came out with 40 combination of site templates, add-ins, things like that, that gave you many pre-canned functions on top of SharePoint. So like project management, expense tracking, all sorts of things like that. The only problem became when somebody went to upgrade, the FAB 40 did not upgrade, or at least you'd need to do a lot of work with it. So it's kind of- It was too much scripting, it was too much scripting behind the scenes, it didn't upgrade yet. And just for, in defense of Microsoft around it, when they released that, they told everybody that that was going to be the case, that it was a temporary fix. People have been pushing- Well, they never meant it. They never meant it before, why now? Well, I put a link in the chat about the SharePoint Lookbook. Have you all seen that? I mean, okay. So the Lookbook, I was looking at a couple of solutions for a project I'm working on right now, and I downloaded and they're like, install this on your site, it comes with all these web parts. And you go in there and the main page is a bunch of screenshots. It's like, they're not the actual web parts or like placeholder content. Like, how is this helpful? Now I have to still build this. And I was about ready to scrap the project site that I was creating and was going to replace it with that. I'm glad I didn't scrap it because I'm like, oh yeah, I should have used this. And I'm like, I'm glad I didn't use this because there's no content in it. So yeah, it's pretty, but you have to know what you have to, how to build what they have, so. Yeah, and I think that this might be a little bit different because they're actually embedding this into the SharePoint online and mobile app. So it's like the default templates you got, they're just adding to the default templates. So my assumption is, it says it's embedded that once those are, if you upgrade, they'll get upgraded along with everything else. Obviously, I don't know the specifics around it. They're very vague about it. Maybe one of our SharePoint folks could find out more. I was just doing a search here. So this is a new announcement? Because I had breaking news for me. I was on vacation, so I missed it apparently. Breaking news, yes, yes it is. Okay, I'm gonna check it out. All right, so moving on, we're gonna talk a little bit about Teams. Everybody loves Teams. They have the organizational wide backgrounds. Now I know we've talked about this before in one of these little things that I do every time we get together, but it's kind of weird that they re-announced this. They tagged it as a new announcement, but I don't think it's really new, but I think what they did was they clarified it because now they're saying, in order for these organizational wide backgrounds, where you assign backgrounds that the entire org has to use, they're requiring an advanced communications license. So in order to use the organizational wide background, the only way you can is if you have an advanced communications license. So Teams free, no, you can't do it. You know, and some of these EDUs that don't have that license won't be able to utilize as well. I don't think that's a good thing. I think it's something that they should give to people for free. I mean, all it is is you're just introducing a background that everyone is required to use. You know, how big of a deal is that? But I guess, and I looked at the license and the license is like five bucks per extra per license. And that's a cost that some people just won't absorb. So. For some that's their entire Office 365 subscription cost. Yeah, exactly. Question for nonprofits. Yeah, they're don't even pay that much. Yeah, yeah. Just to me is something that is just so trivial that it should not cost anything. But I don't know the reason why. We're also gonna allow anonymous presenters and team live events. Why? I have no idea, but they're gonna allow anonymous present, you to create a Teams live event and then say, okay, this person's gonna come in as an anonymous and they'll be able to present. I don't understand that at all. Sure, they so be blacked out. Has the black box just over their eyes? Yeah. Yeah, the entire face. I mean, I understand like the capability of being able to add in people that weren't the, you know, specified at the beginning presenters. And if that's the intention, I don't know what other controls are in place. I mean, if I could go in, if I have a meeting and I've got, you know, Mike, you and I are presenting and we see that, hey, Hal and Sean are in there and be able to let's add them as presenters. Well, I get that ability. You don't have that ability now. So it's not anonymous like we don't know who they are because that's just makes no sense. I think it means anonymous mean not pre-established as a presenter. Well, and you very well maybe right Christian, but there is no definition in the, in the notification that this, you know, of this feature being rolled out. So all they're saying, all they're saying. Speak the worst and pump it up. Yeah, yeah. I mean, it's very vague, you know, your meeting organizers will now be able to schedule an anonymous presenter for a Teams live meeting when using the Teams desktop app. The anonymous presenter must also use a Teams desktop app. To me that's, it's very vague. I think you could be very right. I don't know. Anonymous meaning they don't have an account in your tenant. There's a few different flavors of anonymous there. Yeah. Yeah. All right. I like the backstripe and the garbled voice scenario. The garbled just lower the... So anyone in witness protection could actually present a live event. Anyone know that? That's right. That's right. That's right. Getting back to backgrounds a little bit. You can get customized backgrounds in Teams meeting. His video is coming to mobile devices. So this has been one of the most asked for things on the roadmap for Teams is being able to add, you know, some kind of background for a mobile device because you never could do that. So now you can walk around with your phone and be on a Teams meeting and it's gonna be all, whatever background you want behind you, which I think is gonna be kind of weird because depending on where you go, I don't know. I'm not convinced that this is something that's gonna play out well for some people, but we'll see. When I'm dialed in on my phone with a lower bandwidth connection, what I want to do is use up more of that bandwidth. Yeah. Yeah. So not really. Exactly. So I don't know, I got a question for the group. Did anyone here know that OneDrive, the OneDrive application that you load on your desktop has always been just a 32-bit app? It's never been a 64-bit app. I did not know that. So now they've actually released a 64-bit update and OneDrive will be 64-bit. Now I always thought OneDrive was 64, but so that's kind of a big deal because they're talking about speed enhancements and everything being 64-bit native. So do we have to do something to move over to that version? It's in preview right now. So if you want to jump on it, you can download it and install it. Otherwise it'll be rolling out and it'll be a sync app update. So it'll automatically pull OneDrive out and then drop the 64-bit in. Well, one person just run the 32-bit app two instances of it. There you go. It says twice as good. So if I run four instances, then it should just be twice as fast. Now I was just gonna suggest that one person who I know I saw a post out in some of the Facebook communities, Hans Brender, who's an MVP, who's kind of Mr. OneDrive. Mr. OneDrive, yeah. And so he had an article, I didn't read it. So I remembered that at one point that I knew it was only 32-bit when I saw his post. So I was aware of that update, but that would be a great place to go with questions. So I'll probably get back to Hans and ask if there's anything else I need to do to be prepared for to make them move over to 64. Cause usually it's a separate application and usually with things like that, there's like no migration path. It's just a different application. Right. Do you remember at a time when Microsoft recommended that even though you were running a 64-bit Windows, they recommended just using 32-bit Office app? Yeah, 32-bit Office had a lot more features to it and things, left things that were broken from the 64-bit version of Office. Right. So then they changed that story a little bit, right? And they started saying, oh yeah, you can use 64-bit. It's the same as a 32-bit, but that meant for specific applications, obviously, because the OneDrive stayed 32-bit, but like Word and Excel and PowerPoint and so on and so forth, all 164-bit. Prior to that, we had the thunk layer for 16-bit. Yeah. 32-bit. Yeah, exactly, exactly. All right, lastly, something that's in development that showed up on the roadmap, which I think is like uber cool and has a lot to do with authentication. So in Azure Active Directory right now, you can do a authentication that allows just to be IP-based, right? So you can say that this user can only log in from this IP address or this group of users can only log in from this IP range, if you will. Now they're actually adding to that and what they're doing is they're allowing for GPS. So you can say that in this conditional access policy, you can say this group of people or this person can only log in if they are in this GPS-coordinated area. So like geolocation, right? They have to be physically in this branch office in order to connect to Azure, okay? And that is huge when you think about it, saying that, well, the only way you're gonna be able to work on this project is you have to be in the office or you have to be here at this location and that's the only way that you'll be able to connect. How are they gonna implement that? They're using name location GPS. So they're actually using GPS coordinates. They have to allow location services on the device you're using and it'll coordinate where you are from a GPS perspective and say, yep, they're within the parameters. So they can give it a allow or deny to, I shouldn't say to access, but to the objects or the resources. That's wild. Yeah, it is, really. This reminds me of back in my telecom days and back with Pacific Bell Wireless before they rebranded a singular. So in our office, they is basically you walk outside the building with your mobile, your company phone. And there was a dead spot or ring around the building and they did that too. Yeah, that's geo-fencing, yeah, yeah. And right now, this thing is only gonna be, just so everybody's, I'm clear on this, is that it's only gonna be available if you use the Microsoft Authenticator app, all right? Because that Microsoft Authenticator app is gonna supply that GPS information. That's in the initial deployment of this. It is being, the plan is to upgrade that in the short term to be able to allow any device like a laptop or a desktop, anything that has location services on it. Awesome. Well, thanks, Mike. Hey, Mike, and I just thought too, can you send me just the, each of the items that you went through and we'll include them, we'll line item them in the blog post as well. Yeah, no problem. So for anybody that's watching, of course, there's, you'll be able to go out and we'll have the recording of this entire session out on YouTube later, and it'll be in a blog post on buckleyplanet.com, but in each of those locations, you'll be able to see an itemized list of every topic, every question that we cover and we answer. We're attempt to answer, and which is a good time for the disclaimer. Yeah. That we attempt to answer some things. There we go. That reminds me, Dave, you highlighted Joel's thing that I sent to you guys in email about the telephony question. I saw that notebook. So what? You didn't get that Christian? What were you talking about? Mike sent us out. I sent you and Sean an email, Joel, is it Joel? What's his last name? Joel Olson. Olson, yeah, he is running a webinar to answer any telephony questions around M365. I didn't see that. Oh, that's awesome. We thought we might promote that since we don't answer any telephony questions. We'll need to hijack. We'll need to get in there with a bunch of really messy telephony questions. But yeah, no, hey, a couple of the videos that I did where I pulled in some of the telephony, the Skype MVPs are some of the most viewed of my video interviews. So people, there's a certain, certainly a desire for answers around telephony questions. So. I'm glad they're getting them somewhere because it ain't here. Yeah. And I think I kept this one telephony free, but this week's community questions here in episode 55, we're gonna kick things off with a team's question from Pablo, who says, I administer a 100 plus person team. Someone deleted a channel that I was lucky as able to restore. I have a setting that doesn't allow members to do that. So it must have been an owner. There are eight of those. How can I see who deleted the channel short of asking them all? Is there an audit log I can see? Somebody wants to invoke wrath of God. So there are in Compliance Center. I believe it has that info. I don't have it open. I'll put it, I'll put a link in the chat. Okay. How to view the audit log. Oh, then it got, oh, I see Mike, the telephony had as well. The trick on the audit log is it has to be enabled first. So you can't like, oh, somebody deleted it. I'm gonna go turn on the audit log and then find out because it doesn't back track it. It's from that point forward. So. But at least at this point, it's a unified switch versus per workload. I don't have to turn it on and off. I defer to you. John on the technical side, thank you. I know where the on button is, that's about it. Yeah, so that's one of those things. And of course it's that capability is augmented by third-party tools that make it easier to go in and set up and to turn on and off features like this. But so yes, Mike, if you have the auditing capability, if you have that turned on, you should have visibility into who deleted a channel. Who done it? It used to be, he had to turn the audit log on by PowerShell only for him correctly, but I'm not sure if that's still the case. That's to double check that in order to get the compliance reporting and that kind of thing to come through. Right. Yeah, well, assuming that if you have eight admins, if you're that big of an organization, hopefully you're tracking that kind of thing. If not, you need to quickly kind of go in and assess your entire environment. If you don't have that turned on for that large of an organization. He didn't say admins. He said owners. True. Which, you know, and share point, of course, is all the difference in the world. Well, if someone has the ability to delete, it should be able to log that event and track that. Yeah, oftentimes auditing is your only true course of knowing who did what, especially for permissions changes. And here's an interesting thing too. Just a thought, if you're in an organization and someone's done this and the admins reached out saying who did it and nobody fesses up and is that what's going on here? It's like, I'm just going to have to go in. I'm going to log in. I'm going to find it. If it's being tracked, if the auditing has turned on for the organization, they're going to know who did it. Why would you hide that information? Like, look, I screwed up. I accidentally deleted it. Well, you could fake them out, like my parents used to do and say, I know who did it. We're just waiting for you to fess up. And then somebody says, yeah, and see who reacts to that. And then you know who did it. But yeah. And then flinched. You've had children, Sherry. That's kind of the experience. That's right. Well, I had my kids completely convinced. I could see every text message they sent. And it's because I used to make them put their phones in my office at night. And then I knew all their passwords. They didn't know, but I couldn't see everything. I did because they had to, in order to charge it, it had to be in my office. Yeah, that's funny. All right, question number two, Joseph Assa. We're trying to keep our critical issues at a minimum. And one of them is keeping office 365 up to date. Most of our office updates will run perfectly fine automatically. However, a select few will often get stuck and will need an admin account to allow the update, meaning we have to keep logging onto devices and updating them manually each week. Why do some of these updates and as the small few users get stuck randomly? Permissions, confused. Pretty much has to be permissions. Yeah. Well, I'm confused. Don't go exactly where. Yeah, because office works in the context of the user. It doesn't work in the context of an administrator. Everything is based off of current user. So I don't, I'm trying to understand why some users would get stuck and others would not. It has nothing to do with an administrator permission. Well, do office updates go through the Windows Update service? No, no. Because that's kind of a privileged context. Okay. No, they do not. They have their own channel. They have their own distribution. So it's, that's what I'm confused about. I mean, I can understand that they're having problems. Maybe they locked down the specific users or certain users to a point on the machines where they can open up a browser. Maybe it's in kiosk mode or something like that. I don't know, but. That was my first thought. I said, if there's another profile, they're logged in a different profile. But still, the update is to their profile. Yeah, it's based off of their user permissions when it's installed. Now, if an admin installed the office as a custom setup and maybe had something in there that was custom created, it's possible that the user cannot update that. Because you know, you can do a custom office setup and add your own stuff to it, obviously, so. Yeah. That sounds like the likely scenario here. It's just weird that it would be some users and not all. I just, I'm not clear on that. I mean, I've had users they don't trust and they've been, they've had their permissions yanked. Yeah. All right, question number three. D asks, can someone tell me if there's a way to change the text size in the little dialogue boxes? I'm not even sure if I'm using the right word. I'm talking about the little boxes that open up when you go to the main search bar and type in something like paragraph settings. I'm visually impaired and I can't read what they say. These have access. Windows 10 needs to have access. There's a link in the chat board. She's visually impaired. I would think she probably would know about that, but. There's a quick one, of course, being shortcut cherry. Windows plus will temporarily magnify whatever's on your screen and then you can window minus and that will reduce it back. If you don't want to, it's just one thing that you can't see at a certain time. But if visually impaired, I put a bunch of links for you for the different options. Or zoom it. Sysinternals. Oh yeah, zoom it's good too. I recommend for everybody, regardless of what they're doing or they need the magnifying glass, get the Sysinternals tools, because there's a number of very handy dandy things in there. It's a free download from Microsoft. Now that they acquired it from Microsoft. Yeah, you don't even have to, and Bruce too, but you don't even have to download it. You can run it online now. You can run any of the Systernals online. Yeah, but I threw a link in the chat. Yeah, no, that's cool. I will. So these are these, I just learned something there. Are these Windows toys? Like I found the color picker and I'm very excited about that. The power toy. That's a power toy. Yeah, that's different than Systernals. Systernals is actually a whole bunch of utilities. It's more around functional utilities. And there's a couple, I guess, like BG Info and stuff like that would be considered kind of toyish, but they're really utilities. Yeah, for detecting process problems, memory issues. Auto runs. I use auto runs. Auto runs is a good one, yeah. As well as permissions. If you've got a very difficult granular permission problem, you can, you know, watch the various requests and where they see you. I've seen presenters use them at this, I didn't know where it came from. I think you can download it, but. They're invaluable, yeah. Yeah, Process Explorer is my tool of choice as a PFE all the time. Yep. All right, question number four. Shalundra says, is there any way to restore deleted SharePoint 2013 designer workflows? The first thing you should notice is that it says designer 2013. SharePoint 2013. What year is it? It's 2021. It's a very old product. It's a valid question, not in respect, though. Invalid because of the supportability, but if it doesn't work, you're not gonna get it. The key thing with SharePoint 2013 designer workflows is did you save it as a template before you published it? If you did, you can republish the template. Now, the question is you probably can't pull back the state of any existing workflows that were in flight when you deleted it, but you could certainly get the workflow process back, but you must have packaged it as a template in order to do that. If you didn't, you're done. Or if you've got a backup tool that happens to grab the workflows, those are always kind of dark art things, but those are the other way. Potentially. Yeah, because it's, yeah, if you had, I guess, yeah, it's the scope of the backup, whether it included whatever that is, where that is, and how recently it was deleted. When I worked at IDERA, the initial backup application for SharePoint that they wrote did a custom object model walk, and they would pull as much as they could, but they didn't get 100% coverage because the workflow exposure is very hit or miss, so. You could get XAML, but not instance data and all kinds of stuff like that. All right, jumping over to question number five from Josh. I have a document library with roughly 100 documents, each representing an employee record. I would like to know what is the most efficient way to apply item level permissions to these 100 documents? So that, and Sean, we're getting answers out of the facial, like, even before we get there. Well, let me finish the question. So apply the most efficient way to apply item level permissions to these 100 documents so that each employee only sees their file, but without having to manually apply permissions to each document. So we get a variation of this kind of question, like every single week. Take a breath, Sean, take a breath. Write a flow or Power Automate. I mean, if you wanna do it automated, you're gonna need to run it in the context of an admin or a privileged user, but they could assign the, look at who the employee is, assuming you've got a consistent way to look them up and set permissions that way, but per item permissions, 100 documents isn't nearly as bad as it could be. If you were saying 5,000, 100,000 documents and you want item level permissions on them, I'd say there's gotta be a better, more performant way to do that, but. So you can build a script, I mean, you can have a Power App, so basically script it as part of your new employee onboarding process that it goes through a number of steps and assigns unique permissions to this doc as it's created or creates the doc on the fly, you complete it through a form, dumps the information into that doc and it applies to permissions. It's an interesting one, because all along that path, there's various points in time, which you upload the document, then you set the permission. There's a short period of time at which that document's gonna be open and inherit from the document library. Now I'm not saying anyone's gonna be specifically hunting for those documents or even gonna be quick enough to find it, but it's not 100% filled with what if someone else builds a flow on there that's running and looking for a Power App that's looking for documents with inherited permissions. Just takes one, someone, bit rogue. It almost seems to me like the permissions need to be somehow applied to the document before it moves. Like, you know, what was the, what was the, when we used to have the concept of the document center where you would upload a document to like a holding folder and no one else could see it except the system. And then the system would look at the metadata on the document and apply specific rules and then transfer it to the right location. If you wanna be super secure or I'll say super secure, wanna be a little bit more hardy then that's probably a way to do it. But I think as long as Christian and your description works perfectly well, as long as you've not got something else in there that's able to scan that or not upload, run Xflow or something, could be an issue. What was that old thing? Was it the drop-off library they did that? That's it. Yeah, drop-off library. Is it content organizer now? Content organizer. Yeah, something like that. I created an entire documentation solution around that and all the metadata. I did that for a client as well. Yep. And it was cool. Actually created a desktop icon and they would just drag docs and literally just drop them into that folder and they would get processed to some degree. So did that solve your insomnia, Sherry? No. Because stuff would get stuck in limbo because they would drag and drop and they wouldn't fill out the required properties and they'd be stuck and then I left that organization because I was a contractor and of course my account was the one that got the notifications and things were stuck in the queue. And I went back about four months later and there was like 10,000 notifications and I was like, somebody need to be looking at this account, you guys. So yeah. I just remembered, back when I used to do the, like 20 SharePoint features you should know or you probably should be using but don't or something like that. I had a variation of that presentation which I've had, it's funny, out of my uploads in SlideShare, I've had probably half a million views of just that, that deck and the several different versions of it. But yeah, the old drop-off libraries and the solution that I built around that, that was part of that. So that's going back 2010, 2011, 2012. Yeah, these were 2010, it was a 2010 environment. Yeah. Yeah, fun stuff. Very cool. All right. Question number six, Dallas asks, is it possible to embed report graphs from Dynamics 365 into a SharePoint online page? You can put anything on a page with a web address. Yeah, but under those transportable, can you consume them that way or do you have to, Ms. Orway, to dynamically add those, share those from Dynamics 365 or are you just grabbing images? No oblo, Dynamics 365. I second that. Yeah. Dynamics is the new telephony. I think the technical term for that is, no, yeah. Disclaimer. Disclaimer. You'd have to punch on that one. Yeah, oh yeah, I'm sorry. That's right, let me cue the disclaimer here. Sorry, Dallas. Of what year, the quality of the guidance that we're providing, occasionally. All right, question number seven, Andy. I'm trying to create a sort of virtual inventory of around 100 applications. That's that 100 number. We're just rounding everything to 100 today. Sort of virtual inventory of around 100 application forms with links directly to the different companies, PDF of the form application online. I was wondering, is there at all, possible to set up a page? Stop, stop, stop, emphasis now. Is there at all possible to set up a hyperlink email to with the PDF of whichever form on the cell, the PDF will also be a hyperlink before the email. This was, by the way, this question, if you can't tell, I think it was translated. So I don't know what the original language was. That's why it's a little bit odd in the wording here. I'm currently experimenting with several programs and so far I've already a list of all the forms already created. I know I can create the list of links that go to the app, but I would rather have a list of links where I can simply click email and it gets attached to emails. The email templates with the one attached to each one. That'd be tedious to create with 100 of them though. Yes, it would, but it would work. Yeah. Could be a PowerApp. Well, I did something similar with a SharePoint workflow and I put the preceding content for the link and then a unique identifier for a page. It was to filter for a page in SharePoint. So whenever they would add a record, I had a page that was filtered by that. And I don't know if you could do that and create a little calculated field that has it already in there. I don't know, I don't know. Probably not, probably not because it would have to attach it to an email, right? Yeah, I don't know, any way to correlate between each of the different documents to each of the different companies, you'd have to manually go and set that up. One time, the first time, set that up and then you'd have that automated link but there's not an automated way to go and do that a hundred times. Missed mail merge. Can we have one big shrug, a mogie? Like. Yeah. Yeah. All right, sorry. Well, at least we can capture you doing it, Mike and then that will be the professional picture. That's what we're missing here is we need to pull more memes of us like text. Text, above and below, so. Do that if an original screen shot you. All right, there we go. Okay, sorry, Andy. Jumping to question number eight with Harry. I'm going to be an admin of five Office 365 tenants. So right now, if we could all take off our hats and lower the flag to half staff for Harry, I'm so sorry. That means five logins, et cetera, et cetera. What is an easy way, an easy way to administer these tenants in Windows 10 using five edge profiles or five virtual desktops or is there an application to do that more easily? There's an application to do that more easily and it's built right into the admin center now. So they actually have multi tenant administration capability built right into admin center. So you no longer have to do anything outside of that. You can easily switch between tenants just by clicking up in the corner and selecting your tenant name. And then you can flip that off between all of the tenants that you manage, that you are a global administrator or the admin administrator too. Does it work well? Because I know in other like profile switching scenarios it doesn't seem to stick, it keeps reverting back. I don't know. Well, in the admin center I've done it. I have three tenants that I manage and I haven't had no problems with it. But I think it also uses the same basis that I don't know if anybody's familiar with Azure Lighthouse. It uses the same type of technology that Lighthouse uses to switch between tenants. So it's a little bit different than like profiles, anything like that. It's actually switching directly to the tenant context. So. And that's with three different accounts, Mike, or one account? No. Well, you log in once and then you have access to whatever tenants that you can administer just by hitting a dropdown in the upper left-hand corner. So does it log you out and log you back in? There's a new account or does it always a single login is like a guest admin? Not gonna be a guest admin, well, like a super account that. Yeah. See, I have the same account. So I don't know because I use a control account. I use the dot on Microsoft.com with the company name for my three tenants. And I have the same login for all three tenants. So that's a good question. I don't know if you have different logins, maybe there is a problem with that. I don't know. Yeah, I know my McDonough online account, my Bitstream Foundry account, I've got a bunch of different, I'm still shown at that organization, but they're all entirely different accounts and I've got to log out and in. Oh, mine, I just flipped through them because I use this. Like I said, I use the same account for all of them. That makes sense to me. Log in, log out, you'd have to. Yeah. I don't know. I finally gave up on it trying to recognize how it was logged in and I created different profiles on my computer and I log out. As one user, I log in as the other user and then let it cache because then I tried to use Chrome and I was getting like my C drive was full. I'm like, I don't keep anything on my C drive and I realized all these Chrome profiles Profiles were bloating up my hard drive. So that was a new discovery a couple of weeks ago. So yeah, don't go crazy with those either apparently. My Plex server just chews up system drive space with all the stuff it throws into a profile. It's ridiculous. Yeah. It's like it's just a log in. They're just like passwords. It shouldn't be that hard, but yeah. So I'm intrigued though, Sean, for one little thing. I don't want to drag this one out. If you, let's see you're logging in with, you know, Sean at contoso.Microsoft.com, right? It's one of the better names. How can you have that Contoso domain registered with three different tenants? I can handle that. I'm sorry. I'm sorry. I was just, you could be added as a guest. Correct. In those tenants. Yeah. Can I guess being admin? Yes. Yes. Okay. I can be. All right. That makes sense. So that's what I am. That's what I am. Is I have my on Microsoft.com account for all three tenants and I am a guest in two of those tenants and I am an admin, a global admin in those two as a guest. That makes more sense. I wasn't aware you could promote a guest to a global admin. Yeah. I don't think you've always been able to do that. Yeah. But they did add that. There we go. Yeah. Maybe there's a component of making this feature work. I guess it must have been, how to have been. Yeah, but it's still not as seamless as I think everyone would like it to be. It is a bit of a hassle to log in and out. In instances where you need to do that. All right. Question number nine, Murray asked. I have come across an issue whereby site admin with full control that have synced to their local drive are not able to edit files whether they are checked out or not. It seems to be similar to the forum post provides a link to that link there. I have read through the issue and other sites but not yet been able to establish how to resolve this issue. Is it a checkbox that has missed when syncing to the local drive or is it a permission state that needs to be changed? Or is it simply that site admin should not sync to their local drive? Going everybody speak up at once. Yeah, really. No. All I can think of is when you try to save to a local and it says you don't have permission to save here when you try and save to the desktop wherever they're syncing to. It must be blocking them from being able to save that to that local drive folder. I don't know. I wasn't going to say anything, but y'all were quiet. So I thought, well, I'll throw this out there and see what happens. Yeah, I've had my own issues with file sync. And again, like four or five different accounts that I actively have running with different OneDrive storage. And it's not as simple as just being able to go to a location because there's synchronization with online. And then there's the local cache and copies live in various different places. When you use it with SharePoint, for instance, that local working area is slightly different. So I do not feel qualified to even comment on this. I mean, I've had a similar issue where like the sync was still active. It was like underway. And so it would limit my ability to go in and edit. I could read, but I couldn't edit because the sync was underway or something. I don't know. It was just, you know, went back a couple of hours later and had no problem getting to those files. I wonder if they use the, you know, right click on it and say, always keep on this device. Maybe it's sitting in the files on demand and that they didn't get demanded yet. I don't know. Well, to work with it locally, you would have to, even if it's just in the cache. If they're using the desktop client. Right, yeah. So I go to the C user profile, one drive, go to that root folder and then try and right click and say, always keep on this device and maybe that'll push it, nudge a little bit. Good morning. It's Monday, give me coffee. I don't know. It seems like this kind of day, I don't know. Christian setting us up for failure with these questions. It's like, now just think back again, Rackley's comment about, it's like, what's the deal with these questions? I'm like, I know Mark prefers the softballs, but hey, these are, these are for folks that are watching this, the recording of the live stream too, is that these are raw questions that we're pulling. We're not doing spelling correct on anything. I'm not changing the grammar of anything. I'm cutting and pasting these from a number of different Facebook community pages from, and there's actually seven or eight that are from Microsoft Tech community unanswered questions as well. So these are, that's the point is, is to do this at live events. We used to do the, you know, what the stump, the experts. We were chumps, stump to chump. Stump to chump. Stump to chump. Yep. Let's see, all right, question 10, Tom. Yeah, I'm just, do you see how smoothly I just moved on from Murray's question there? Question 10, Tom says, current setup as we have a Teams channel, including the channel calendar tab, meaning any event put in that calendar will be sent to every member of the channel, nice and easy. The problem is now that we're starting to have more in-person meetings and other kinds of external meetings, such as Zoom calls, the platform of which we shall not speak, that everyone in the channel needs to be invited to. By default, creating an event that calendar sends out an associated link for a Teams call, which adds some confusion when we're not actually intending to have a Teams call for that meeting. Is there a way of not sending out Teams call info for meetings created within the Teams app? And in particular for a specific channel, I suppose a workaround could be to create the meeting in the group calendar on Outlook and then inviting the group, but then you can't be channel specific, any help would be appreciated. Yeah, that's an interesting dilemma. So my, because that's my first response. If you don't, if you want to just do a meeting invite and not have them, then send it via Outlook. Yes. But the problem is then you can't dedicate that to specific channels, discussion, all the activity. It's an interesting edge case. Like how would you go about solving this? I mean, any other ideas? Well, meeting in a channel is a passive meeting anyway. You know, it just shows up. It doesn't actively invite people and they don't have to RSVP. If you send it through Outlook, it's there. I don't know. That's the only way is to send it through Outlook and put the actual link in there and not put it in the channel. I don't know. Why would you create it? Why would you create a calendar in Teams and then not use Teams for the meeting? That's what I think is weird. Yeah, it's kind of implicit. Yeah. My opinion. Well, if that's the place, yeah. Maybe that's part of the interpretation of the question. If they're using that channel calendar as the way to manage all the activities and they want it visible within that calendar, that's why they're using Teams to create all of those meetings. But if it's linked to a group, you should be able to create it in the group calendar. The problem is that it's not channel-specific. So there's a way of getting it to all the right people, but it's not the way that they work. Basically, what they're asking for, I think, is to, Sean, your point, is this edge case scenario where I create a meeting within Teams but I'm able to remove the online portion of that. I mean, my only other thought would be to put in the headline, put in the description of the meeting invite, like no team meeting or no online meeting, and just make it kind of the protocol of the company. When you see this, then that means that there's no team meeting. It's just... So Teams is hosting a party and it's not welcome at its own party. Correct, but then it would show up in the right calendar, all the members of the channel would see it and you'd have that benefit. If you're talking about a small subset of meetings, the majority of them are Teams meetings, then having that, it's like your naming convention for, where you add in a prefix or a suffix so that you have a standardized way of naming files. It'd be the same thing for meetings and just come up with a prefix for those that are created within Teams but not online meetings. Yeah, well, in channel meetings, you can't have external people, so maybe they're wanting other people outside included too, I don't know. I don't know. I read it as the core issue is managing centrally in that channel calendar and that would be the quickest and easiest workaround for that is add a prefix to the description. Yeah, I don't know if someone mentioned this, I got a bit distracted for a minute and I don't think this is even possible, but it might be a nice idea for a request. Imagine if you could use a channel calendar as like old school exchange resource and invite the channel calendar to a meeting that you sell via a different channel, via a different process, maybe through Outlook, like we used to do back in the day, right? Or invite meeting room, invite XYZ, whatever it might be. Invite the printer to the meeting. Yeah. Because then it'd show up, assume it would auto-invite, auto-accept, given the chat, well, I guess it wouldn't be busy. Because it's just a calendar. It might be an interesting thought, I just thought. Interesting. I have an interesting thought every now and again. Very few of them are related to IT. If you're allowed to share, yeah. Well, I know you just said Neil here for his good looks. You know. Oh, I was just going to add in, so a couple of comments over on Facebook with the live stream. So Keith Richie had been making some comments about Fab 40 and said, die, Fab 40, die. That is one of those. Yeah, and I just liked it. And Paul Swider just jumped in and he says, we need Fab 40 for Power Apps portals now. And then he put in ducking, you know, ducking. I love Paul. Asking for a friend. Asking for a friend. Asking for a friend. I had somebody make a reference to Clippy, you know, that if I'm 40 and Clippy are kind of in that same purgatory, I think there's more love for calm and not forgotten. Yeah, well, let's jump to question number 11. Tony asks anybody have any idea what is going on in the outlook for Android mobile since the last. Oh, hey, it's a telephony question sort of since the last few updates, a whole bunch of accounts don't sync. No notifications and random emails don't load in. Has anyone else seen that or is it? Is that a second device accounts across multiple devices? I don't know that it's systemic, Tony. Make sure you've got lots of room on your phone. Outlook for both Android and iOS are a bit of memory logs. Yeah. Yeah, I don't I don't know. I mean, you can go in and look and see if there's been any. Well, I mean, I think this is more of a user specific problem that I kind of global. Yeah, I mean the only problem. The only thing I've ever had to do on my mobile devices, you know, I'll change my account password and I'll have to go in and, you know, resupply credentials. But, you know, that's a one time thing. And the only other question is have they updated it recently? You know, the app might be out of date and causing an issue. So it's possible that, you know, like you say, Jerry, you know, we possible you ship a bug, right? You know, look for Android. So how many people are affected by this? Maybe there's been a patch recently. I don't know. That's probably stretching it. I don't use an Android sort of testing. Well, I have a number of reports of anything, so. Yeah, and I think there's some feedback somewhere. I update my apps periodically and some people don't. They don't know that you have sometimes you have to go in there and actually say, oh, there's 46 updates. Please. Yes. Thank you so much. So. They just install and forget. They set and forget. Maybe it's like, oh, no, 46 updates. Thank you, sir. May I have another? Thank you, sir. May I have another? Well, I had a Windows phone and I always said I loved my Windows phone. I still love my Windows phone, but apps stopped working, right? And before that, I was like, all I needed was tripping, you know, my outlook that, you know, I'm not an app junkie, but then I got an Android. Now I'm an app junkie. Like it's ridiculous. All the apps that are out there just to order food. Chick-fil-A, Panera bread. Yeah. Sorry. I didn't I didn't BK McDonald's. You name it. Yes, absolutely. Yeah, you used the water burger app last night. My husband and cheese and broccoli soup from Panera bread. It's fabulous. Yeah, we just went through the airport in Houston. My husband's never had a water burger. Like, oh, and I said, honey, this is like the In-N-Out burger of Texas. You got it. If we're here, you got to have a water burger. He liked it. So I'm getting hungry. It's my lunch time. Yeah, it's getting. Can we stop talking about food? Didn't have breakfast now. I'm just thinking, yeah, just if we're talking burger places, you know, so there's two that I highly recommend. I mean, one, I'm a huge fan is since I was a kid out of L.A. Tommy's Burger and there's a little Tommy's Burger stand down in Provo just south of here. And so every time I go down and visit my son, who lives down there and I will force him to go get the double chili cheeseburger. Twist my arm. I know it's rough. It's fantastic. But then I'm I'm a Carl's Jr. double Western bacon cheeseburger guy. It's like the it's like eating Wonder Bread, you know, a version of hamburgers. And it's just so unhealthy, but so delicious. I like the six dollar burger. My favorite there is the really big Carl. The six dollar burger with their bread and butter pickles. We're torturing Sean on purpose. My mouth is watering here. So good. I'm a burger. I'm a burger guy. So I just I just love that. Yeah, they open it in and out here. And they're the line is like people waiting two hours. I'm like, I'm sorry. There's no reason for the way two hours for a cheeseburger. You know, I love my in and out. I do, but not two hours worth. Oh, they're good. They're fresh. They're not the best burger, but they're they're tasty. They're and again, it's fresh tasting. Hate the fries. Absolutely hate the fries. Really? Shakes are good. Hate the fries. No, I don't like that. You got to do them. You got to do animal style. Well, you do animal style, plus you do them dark. And what they do dark is they they overcook them when they're dark. I need that. Oh, that's what I'm missing. I didn't realize that. OK, that's that's that's one of the off the menus. You got to you got to Google off the menu or the secret menu. Yeah. Yeah. OK, there are any hours around and the Neapolitan just love that place, Sean. I burgers back then, yeah, they were really good. They disappeared from around here. I don't know, but Rutgers will five guys kind of replaced. I know it's different, but it's replaced by breakfast. Five guys. You can't think in the middle. We did a 10 minute. Rutgers has great cheeseburgers. How did how did we get in the hammockers here? I blame Sean. My it's my fault. I was talking about I still blame you to stop. OK, let's jump to question number 12. Focus, people. Theo asks, does anyone have a method for forcing a SharePoint list to alphabetize by a certain column? I've done the A to the Z sort and SharePoint. But as I add new list items, the sort doesn't automatically hold. Also, I want the sort to appear similarly in teams. Is there a potential JSON based solution? You don't sort the list. You might sort of view, first of all, yeah, and then. That's specific to the view, right? Yeah, so. As you've added in, I mean, you're going to view it. It's also a default view. Yeah, you might have to refresh the window if you're on that view. Just hit refresh F F five is the shortcut. Yeah, and see if it fixes it. Otherwise, setting it to the Android. Are we missing something else of his request? Because that's the first thought. Yeah, that's a pretty basic place. Well, yeah, he's basically column sorting in the list view that he has not column sorting when he applies to that initial first time you click it. Hey, we answered a question. The thing is, I don't know if there's the same teams because I've got to go to my teams channel SharePoint list. The view, I don't know what views teams use. Shooter McGavin. They should use a default view, right? Yeah, default view. But isn't it isn't that relatively new that it can support the other SharePoint views, though? Now, that's a query string parameter. If you want a different view. So I think it's just teams, though, the teams client. I believe it until teams client. If you click on files, teams client and the channel, you can, or maybe you can, maybe there's a channel setting to choose a view. It's been a while. Yeah, you'd be, I think, sticking it some way to it. That's in that super secret Microsoft Teams application that Neil uses that has all the special features that regular people don't have. We're not a high enough rank in the mason's yet for that. Some of them you don't want. I did put a link in the chat for how to create views. So that helps whomever didn't know they could. It's always helpful. That's kind of it. So still look at the default view based on Sherry's response. Sherry's response, sorry. Yeah. So the question that stands is whether it will stick inside of teams. How does teams treat it differently? Or is this new ability, is it there? So I'm going to take it as homework. Because I read about it. I saw something. I couldn't find it. Just did a quick search. I'll go and track that down. In teams though, you have the views in the upper right-hand corner. So you can change your view, but I think it's grabbing the default view, by default. By default, yeah. Because that's default. It's just so random that they would name the default view and then that would show up that would have defaulted, I know. Department of redundancy. Crazy. All right, let's see. Question 13, Hillet says, hello, I'm building a SharePoint site. Mike, this question's for you, so listen in. I'm sorry, I'm speaking to the SharePoint question. In the site, there's a document library that contains different procedures. I would like to know if there's an option for every user that reads a procedure to mark that he was reading it. I thought to open a private list for every user that there he could mark all the procedures he was reading. Every record there will be related to a procedure from the library of the procedures. Is this possible? How can I open a private list for every user? I'm trying to figure out his business challenge here. Mike, is the fact that he wants people to acknowledge they've read it or that they've checked it out and they're reading it? I've got a learning system almost. Sounds like more of a workflow process than a SharePoint process. Yeah, the only thing is the SharePoint review workflow is what comes to mind so that you sign it to every person and then it would keep track in the workflow of who had actually done that. Mike, or Sean, I'm seeing you nod at my idea. I mean, that's one way to skin it, yeah. Because for SOPs, I've worked with many organizations before who just wanted to ensure that a document was reviewed by somebody and so they would want to track it that way for compliance purposes. So something like Power Automate or SharePoint workflow or something, just the approval workflow, like you said, SharePoint work as well. I hadn't considered that, but that's an interesting way to skin it where you would probably have very little extra work if you build a group of everybody in it and simply assign it to them. Yeah. Let's SharePoint do the heavy lifting. Yeah. Do they have the review workflow in modern now or no? They deprecated the 2010 workflows, right? They deprecated 2010. Yeah, 11 years later. So 11 years ago. Yeah, I know. Yeah, 2010. I'm over it. Totally, yeah. 2010's off now. So it's not an approval workflow. It was just like a review. So people had to review and say they, you know, and acknowledge they reviewed it. Yeah, it had its origins actually in WSS. It wasn't even a SharePoint workflow. It was a, you know, you had the three state kind of thing that you could set was real low level. Well, let's jump to question number 14. Alma says, is there a way to get a combined report for unique visitors of SharePoint online sites and Microsoft Teams? How do you get metrics of total SPO usage and MS Teams? Neal's got the answer. There you go, Neal. You got volunteer told. That was funny. Since I go tell the internet kicks me out every 19 minutes. Oh, that was weird. I'm not really sure if in the Microsoft M365 Admin Center, if they have reports for SPO, I don't think they, from a reporting aspect, I'm going into the Admin Center now. And I mean, it's usually just around compliance and security. So I don't think there's any native way to do it. SharePoint reporting has always been pretty crappy. Well, what you could do is, I mean, and I've done this, I've done this for clients, is take the, you know, you can export the raw data and bring it into Power BI. And you'll create your stuff there. Yeah, I mean, Power BI has the connector to pull that information. So it's easy to do. I'm in there right now and I can see that. I can separate out SharePoint and Teams data for the active users, activations, files stored, you know, all that kind of stuff. But I mean, if you want something that's more custom when you're talking around metrics of total SharePoint usage and MS Teams, is it, you know, combined report for unique visitors? You're not going to get that from, you know, the canned reports that they give you. Plenty of third party tools, but. Yeah, there are plenty, yeah. Yeah, I've seen it in TyGraph, so. Yeah. You know, this exact thing, but. But I mean, like I said, I've taken it, and just did the Power BI connector right to 365 and be able to pull the data and do whatever you want with it. Right, yeah. Yeah, all the activity reports, de-dupe it, then you'd have your unique users in that given time. Yeah. So, yep. All right, question 15. Puneet, is there a way to convert CSV to Excel in order to consume the file in Azure Data Factory? Is this a trick question? Yeah. Open the CSV file in Excel, save it as an XLS. Yep. I've done that before. Surely we're missing something. We are definitely missing something. Yeah, also ADF should be able to pull in CSV directs anyway. Cut out the middleman, sure. Couldn't I create a Power App that we could? Yeah, that too. Yeah, but what is it sourced by? Yeah. Mm-hmm. Yeah. So, yeah. So that's pretty easy problem to solve. Plus there's some other detail. That's sourced out. That's the question as posted. I have a hard time believing nobody else actually tried to answer that question. Unanswered question, Microsoft Team, Microsoft Tech Community. Wow. Maybe they thought it was a joke. Yeah. Or don't wanna get punked, I don't know. Question 16 from Christopher. Running into an issue, so very orderly in his question here, setting. So it's a document library with incoming email settings turned on. The problem, how to extract a particular string from the body of an email or how to extract the body of the email so that I can target that string. It's using SharePoint Designer 2013, on SharePoint 2016, have access to SharePoint 2010 and 2013 workflows and no third-party apps. Does designer support regular expressions in some form? Cause regex would be the thing to get at that. Most directly I'm thinking if there's any kind of variations, but I don't know if there's any step in designer in the workflows that supports regex. By the way, sorry, Keith just mentioned to you, 2010 ends today. The support ending today is April 12th? All existing instances explode. That would be cool. That would be cool. I would actually pay to watch that on a live stream. Yeah, really, might get your popcorn and just. Yep. April 13th, this is April 13th, 2021. All right, tomorrow, yeah. Keith cracked himself as well. Yeah, cause it wouldn't be good to end on a nice round number, the 13th. That's just that number just feels right. But it is Tuesday, Microsoft Tech Tuesday, right? Yeah, correct. Yeah, so any other thoughts on this question? Yeah, it's an interesting one. So we're saying how to extract a particular string from the body of an email. Is he looking for the same string from every email that's going into the document library to make sure it's present? Or is he looking for a different string each time? Yes. One of those things probably. Yeah, definitely one. Because you can use, you could potentially, if you just want to find does this item contain or do items in this library contain this particular string? Why don't you just use library search? Turns out he wants to do it afterwards because library search will tell him all the documents or the emails in the list that contain that particular string. Yeah, so it comes down to what does he mean when he wants to, what's the use for extractively? Another one of those examples of being able to ask follow up questions, clarify. So nice. And there's, if you imagine this scenario and this is imagine if you're, okay, this might get a little bit questionable. Just mute me if he does. It could be somebody looking for social security numbers, someone looking for credit card numbers with emails that have come in, people responding to them nefarious emails. You know, your Nigerian uncles left you $10 million, at least to me about details. I'm pretty sure it's not, Christopher, that's no disrespect. I'm pretty sure it's not that. I'm sure there's a genuine business case here, but we just can't really geek out what the business case actually is. You know, I've said this before, I'll say it again, when the Crown Prince of Nigeria reaches out to you personally for help, you help. Yeah, yeah. It's only $5,000 that he just needs temporarily to help him out of this jam. And then you get $10 million. Who would not go for that? All right. Question number 17, and how are we on time? Well, we've got a few moments. Ian says, is it possible to block guest access in teams and through SharePoint permissions only allow guest access for a single team for a small number of guest users? I'm not hopeful. That's a great way to round out the question. That really makes it easier to respond, you know, because we could just kind of like, oh, you know. I hope he's lost. Ian wasn't hopeful in the first place for any guidance or help, so. Block guest access in teams through SharePoint permissions. Number one, you shouldn't be messing with teams, especially not teams channels by modifying SharePoint permissions at the back end. That's not a good plan. Sometimes it might seem like the only plan, but it's not a good plan. Won't we allow access for guest access for a single team? It's all or nothing, isn't it? Yeah, it doesn't matter about granular. Yeah. Unless they had a separate tenant, were they allowed like a federated tenant that they would allow external access to? I know a lot of organizations do that. They don't want them in their real environment. They create like a .NET, so the .com kind of entity, show that one. Oh, it's like an old school DMZ. Yeah. Yep. Otherwise, yeah, I mean, if you have external access set up but just tightly control teams that can enable that as part of your provisioning process, for example, and then enable a team with external users that are possible. And if you want a further limit, then create a private channel within that externally accessible team, because only there's the limitation. It'd be great if you had a private channel that you could invite external people that don't have access to everything else, but you have to have access to the team to get access to the private channel. Yeah, it'd be good to have that either end, so you could have that private versus kind of, almost like public only. The shared channels resolve that? So I don't know what's been talked about publicly, what's the capability, but doesn't that resolve that? If I have a shared channel, and I think that with the shared channel, I think the thinking is, again, it's not out there yet, it's just being talked about whether the current thinking is that it's, you can have external people that aren't members of the team. I mean, that's the idea. You wanna be able to share it and communicate with people in other tenants. Yeah, I don't know, anyway. Yeah, don't know. Boy, we are so helpful today. So thank you for watching. I'm trying to think of any, is there any kind of conditional access policy that supports only like FT's versus guests? I don't know, teams there's a few of them, but I don't know whether they have that scenario. Might be worth a look. Well, if your users are defined, if your users and guests are defined outside of, I mean, in Azure Active Directory, which they have to be as part of 365, then you should be able to assign them separately in any app that uses Azure Active Directory. So what Neil is saying, yes, that definitely should be possible because AAD is the backbone of all the authentication for M365, so. Yeah, I'm just looking at it. To Shari's point earlier, I can see AAD premium licenses. There's a scenario under Matt Solzman's blog that talks about how to apply conditional access policies via Azure AD for teams, but it's an all on nothing scenario. You either have access to teams or you don't. You might need an Azure AAD P2 to do that as well. A P1 subscription may not do it. Well, I think we can squeeze in one last question here. Maybe we can provide some help here. Question number 18, Jesper. OMG, anyone here who are able to give some advice that is useful? Well, that, that bit. Yes, our number. Post-disclaimer, post-disclaimer. Says the issue, I had a free subscription in which I created a VM. I then had to change my security info to my mail and wasn't able to log into the Azure portal for 30 days. Contact Microsoft, no luck getting around the 30 days cool off. Anyhow, the 30 days cooled down and finished, but my free subscription has expired now. I can't transfer the resources because this subscription is disabled. Anyone who knows what to do. There are files I need to get from this VM. I was told by Microsoft that I could get access to my VM up until the 28th of April, which obviously wasn't true. Okay, so a couple of things going on here, right? Try and unpack this. First of all is that just by changing your email, okay, that is assigned to the free subscription account, you would absolutely be able to change that with Microsoft support. I've done it before several times. It does require a long authentication process to verify you are who you are, okay? But they will do that. And so I'm not really sure what steps were taken to get that. Obviously didn't go through the support first. What made the changes through whatever online automated capability? But even if you did it after the fact, support can then take the steps to authenticate you, which I've actually had to provide a driver's license at one point just to say I am who I am. And then they switched the account and I was able to access the account after that. So I don't know how far they took it. If they said, hey, I gotta get to whatever. The second part is that there's an automatic 30 day recycle bin on every resource, right? And so you have 30 days after the fact. Now, if you were matching up the free subscription time to the 30 day recycle on the BM, that should have probably told you that you're not gonna make it in time once you're at the cool off period happens. Now, I don't understand, I mean, I've heard of this cool off period. I've never experienced this cool off period, but I've always just had the account changed. So I'm not really familiar with that. But I just, I can't understand, even though it's a free subscription, it's you can tell Microsoft, improve to Microsoft, you are who you are. They're not gonna not allow you to get at whatever you created up in Azure unless they say, you cannot tell us for sure that you are who you are. So we can't give you access to somebody else's stuff. I can get that. But the thing that comes back to is about the free sub. Any free sub that's been disabled past the trial, okay? They're talking about a trial sub because you can get a free sub that lasts forever. You can create a VM and free subscriptions don't die, okay? They don't die anymore. It's not a timeout period anymore, okay? So that and that went into effect. Yeah, that was back in early 2020, where they changed it where free subs lasts forever. You can always create certain things in free subscriptions. But the thing that I'm still not clarified on is that Microsoft or they should have researched it a bit and found out that you can take a free sub, switch it to pay as you go. And all of your stuff just magically comes back to you. I mean, everything that you created in the free sub will come back, even if it's up to the 30 day recycle time. So if you tell them that you have this subscription ID, you want to convert it to pay as you go, then they will do that. You give them a credit card and you can get your information off the VM and then you can cancel the pay as you go subscription. So they still have the ability to do that. They probably still have the ability to do that is to open a support case with Microsoft, give them the subscription ID and say that they want to convert it to a pay as you go. And Microsoft looks that up to see if the data is still available. If it is, they convert it, user gets their data off, user cancels the pay as you go. All right, we'll think, you know. Yeah, that's great. Well, we're at time. Thanks for that detailed answer, Mike. And thanks everybody else on the panel for joining today and those that watch in the live stream or on the recording. Again, we'll be back next week. Some of us will, some of us are bailing again, Neil. But he's dead on Cancun, so it's understandable. But we'll be back every Monday at 8 a.m. Pacific. And again, this episode 55, it'll be up on YouTube in the next day as well as at unbuckleyplanet.com. You can find all of our past recordings there as well. And every one of those blog posts have, every question that we've answered, we've responded to. Sometimes I tweet out individual responses with links back, but so you don't have to wade through all 90 minutes of the recording. You can actually jump right to the topic that is of interest. Or you can listen to the entire thing and get all that fascinating talk about hamburgers. Yeah, yeah. Good stuff, I know. Yeah, it's the hamburger edition. Well, thanks a lot, everybody. We'll see you guys next week. Have a great week, everyone.