 I don't want to just keep listening to that song and let that go for a while, but we are live. Hello everyone, good morning. Good morning, Christian. Good morning. Excellent, well, to kick things off, so hello and welcome to another episode of Microsoft Community Office Hours where we will be discussing all things Microsoft 365 and answering questions from the community. My name is Christian Buckley, I am an Office Apps and Services MVP and Microsoft Regional Director and the Microsoft Go-To-Market Director at AvePoint and I'm dialing in from Lehigh, Utah, yay, and from the bunker, the basement. Joining me today, Sean McDonough, a consultant with Bitstream. Yeah, see, like just doing the other, the announcements of the panel just that leaves a bad taste in my mouth. I don't know, today, yeah. Just Sean, just Sean. We'll get you a minute. I'm struggling. Sean McDonough, a consultant with Bitstream Foundry in Cincinnati, Ohio and Office Apps and Services MVP. Mike Nelson, a Solutions Architect with Pure Storage and a Cloud and Data Center Management MVP based in Appleton, Wisconsin. Hal Haas-Dettler, Senior Field Engineer with Roland Shore and Tower in Tucson, Arizona and an Office Apps and Services MVP. It's the running theme here every week. Eric Riz, Founder and CEO of MT-Cubicle and Office Apps and Services MVP based out of Toronto, Tanaidia, our 51st state here in the U.S. Welcome and we also have Sharon Weaver, Founder and CEO of Smarter Consulting and a Microsoft Region Director based in Lonex, Kansas. And I think we have Sherry gonna join a little bit late. I think she said she would dial in. So I will introduce her right at the beginning here. She should be joining a Microsoft Certified Trainer, Microsoft Office Master and Co-Founder of Power-Up Learning in Colorado Springs, Colorado. And I'm not sure where Neil is. Neil might be late as well. Neil Hodgkinson with Microsoft may or may not join us today. I got an other reply from him. Is he still on vacation or something? No, no, he's home. He should be back. So yeah. Oh, he's still sending out his automatic key. Yeah, well that could be a strategy at work. Yes. I don't know if he should be introducing him ahead of time because I mean when Sean didn't show up for so many sessions. I know. He didn't even introduce him once. So via email, Mike. I said that he was dead to us. He was dead to us, but this morning. We need to observe the moment of silence there. But everyone, I officially unshunned Sean this morning via email. So here's that. I think I just made it in under the wire. I was going to wake up next time with a horse's head next to me. Or a dead fish in here. Yeah, exactly. Yeah, something real. And by the way, I mean, Christian, just so you know, Eric, Canada won't be the 51st state. It'll be the 52nd state because you're going to move back after DC becomes a state. So you'll be now 52nd. That's fair. I don't know, Puerto Rico as well. It could be 53rd. I know you kind of missed that window to be 51st. I know. Well, right. Well, let's kick things off unless there's anything else. Oh, well, wait, so this week. I just remember events and stuff. What are we doing here? Everybody's. Yeah. We have a Teams Nation that's happening, a big event happening this week as well. I don't think there's anything else this week. That's the big one that's going on. For those that don't know, if you go out and do a search for Teams Nation as one word, and I think it's teamsnation.rocks. teamsnation.rocks. Ford slash register, I'll put it in this chat. OK. Is that ROX? I may or may not be doing a session on Wednesday. ROCKS. I know, Eric, they missed out on that opportunity as well. Yeah, the other one's a porn site. Right after this session is the M365 user group, if anybody'd like to jump. That's right. I get those emails every week. I just think, wow, and it conflicts with the other meetings. And he deletes them. That's right. I do. There's nothing else to ignore. You think he does that, or does he have a rule set up? I see them. No, it's manually. I leave it manual so that I can do it with disdain. Yes. With intent and disdain. All right, so with that, hey, Mike, anything going on in the world of Microsoft 365 Message Center? Oh, there is so much going on, Christian. I just don't have enough time to do it all. So here are the highlights from the past week. Which department? Yeah, another event going on that you may not be aware of is Microsoft Build. Microsoft Build will be going on May 25 to the 27th. If you're interested at all in any of the developer kind of things, APIs. I know they got some Power Automate sessions as well. So if you're at all interested in that, I encourage you to go sign up for Build. Hey, Mike, what were your thoughts on Build last year being the first one online, done online? Because part of it, I don't remember what the, I was never, I'm not a Build target audience member for that. It's a developer centric. However, the numbers last year were amazing. Microsoft, of course, loved that. I think it's over 200,000 people that participated. Yeah, it's crazy. Yeah, it was crazy big. And the thing about it is, is Build is always a sold out event, right? So it's always whenever it was in person, it was sold out. And that's why they started doing some hybrid of Build over the last couple of years. But the thing about Build was when it was done last year, it was after Microsoft already had a couple of virtual events in their back pocket. And they were starting to learn from their mistakes, I think, as many of us were when we started to hold events and they were virtual and we didn't know, we knew what we were doing, but we didn't know what we were doing because there's so many different nuances about holding virtual events, as we all know now. But Microsoft, you know, you did a pretty good job. And I enjoyed it. I actually, you know, I enjoy Build. I actually enjoy it more than an ignite, to be honest with you. And that's just because it's very, very technical. I call it the TechEd of the old days, if you will. I don't know if you guys remember TechEd, New Orleans and stuff like that. I mean, that was a time when you got so deep into the weeds, it was so much fun. But now they've kind of, you know, the whole, you know, they have a degree of marketing that's involved now. And I don't know, it's just different. Yeah. So moving on, reminder, Skype for Business Online will retire July 31st. So everyone that's using Skype for Business, whoever you are, you know, the five people in the world that still are. Yeah, retire. Put a bullet in it. Yeah, put a bullet in it. July 31st. It will be end of life, DOA, shot in the head, all of them. All right. So violent on this Monday morning. Wow. Angry, he's angry. Why are you so angry? Don't be angry. No. We're all friends here. All right, got an update for you on teams. Everybody loves teams. I guess everybody loves teams. Large gallery viewing together mode for web meetings will now be available in Edge and Chrome browsers. I guess it wasn't available before. I know we talked about it before, but they're calling out specifically Edge and Chrome. Obviously Edge is made from Chrome now, as we all know. And that'll be available. It'll be coming out as a roadmap. The updated rollout timeline will be early June now. Speaking of together mode, together mode is now generally available. They've actually taken the preview label off of something. So together mode preview label will be taken off coming up here at the end of May. And you will no longer will see that little preview tag. It is now. Is that the only change though? It's just that the preview tag is gone. Is there anything, is there any final features added? It's an event because the removal of the preview label indicates that the all together mode capabilities will be functional and available to your organization. When you get the preview label in there, that means, hey, something can go wrong. We're not, you know, don't. Okay, from here on out. So according to Mike, nothing will go wrong. So if you have any issues with it, what's Mike? What's your email? According to me. Ah, Christian, Christian. I just missed Captain Literal here. Yeah, yeah. So finishing off together mode, road map edition coming May calendar 2021, which is now, right? They say they have a roadmap edition called together mode for VDI. Okay, no real details on it, you know, kind of like a one line. Yeah, it's coming, but what's the difference between together mode for Windows desktop and together mode for VDI? Because VDI is just a Windows desktop, a virtual Windows desktop. I'm not, I'm not getting the whole. They're throwing something out there, trying to, because they didn't have any other major announcements coming out. Steve, it sticks against the wall. That feature team wanted to be mentioned in some media somewhere. That's right. That's right. That's from the, oh yeah, the department, let's throw it against the wall and see what sticks. That's what it is. Hey, cool new feature. They actually have one cool new feature that I found, they've been putting out at least one. Oh look, you'll be able to dictate emails on your iPhone and iPad. So now the speech to text to dictate email messages will be available in the ENUS or the US language. And, you know, it's getting rolled out in mid-May. So, dictation is already available on the Windows and Mac, right? But iPhone and iPad, you'll be able to do it now. So think about what this means, right? You'll be able to sit there with your iPhone in front of you instead of saying, hey Siri, you know, do this. You can say, start dictating it. I mean, think about this, right? That's right. It's just super to me, super to me. It would help me dictate small island nations. Yeah. Well, somebody I was talking to about this last, somebody I was talking to about this last week is they brought up, hey, does this mean that if you have carplay, you know, with iOS and you have a carplay and you have the ability to dictate an email directly through your carplay? I don't know. Yes, yes. So what, so it's an important feature. When I'm driving 75 miles an hour and want to pen a letter to the editor for something. As you are angry. Of course. No, it's on my angriest when I'm driving at 75 and that's when I want to respond to letters through letters to the editor. And now I can do that using my iPhone while looking at my map and changing my Spotify playlist. I can dictate that all of that. And watching the movie. And well, yeah, and watching the movie. Don't forget to eat Christian. You look a little, you know. Well, that's, that's, I think that was assumed that the burger would be in the lap and the drinks. Sandwich in one hand, drink in the other. That's right. Drive like this. That's why you have knees, my friend. Knees, yeah. I think it's actually kind of cool because I mean, you think about it, you see people walking around talking to their phones and now they're not actually talking to people. They're just dictating emails. You know. Or they're crazy. Yeah. All right. That's right. All right. Moving on. So lists, everybody likes lists, right? We talked about lists in SharePoint and then you have Microsoft lists, right? And now they're gonna give you the ability to export those lists to CSV format. So they rolled out the capability to export Microsoft lists to CSVs to all environments. It rolled out second half of April, 2021 but it's now fully available in all environments. And the thing is, the kicker here, the reason why I'm bringing this up, because everybody's like, well, why are you bringing this up, Mike? It's like they said it's rolled out. They have one sentence here, you gotta hear this. We apologize for not announcing this feature in advance. So they rolled out something but they didn't tell anybody about it. And now they, you know, somebody said, hey, what's this? And they said, oh yeah, we forgot to tell people. So now you have the ability on your Windows machines to export to Excel button has been changed to say export. And then you have two options underneath it, which is Excel workbooks and then CSV, which is new. So that saves me a step. I no longer have to convert my Excel to CSV. It goes straight to CSV. Yeah, that's right. This just came up last week or week before last. It's come up a couple of times where people have asked that question about how to move that, how to share that out. So this is great to be able to see that. Of course, where is that button? Is it right next to save? Is it in a confusing location that's gonna cause people to have unintended behavior? Of course it is. Clicking on things. Okay. Of course it is. That's what I expect. I'm on the back of your monitor. Yeah, so two things about it. On Macs, it's only the export to CSV option is available on a Mac. I don't know why they got Office for Mac. Why can't they do Excel? But who knows? And the feature is only supported inside lists, not inside document libraries. So that probably means something to Sherry and Sean, but I really don't have a clue. So that's fine. We'll move on. Announcing new options for custom sensitive information types. This is kind of interesting because it calls out something that I have always had a problem with. And it's just the ability to add, when you do custom, excuse me, sensitive information types, they call them SITs. And when you use SITs, it's like when you put in classified company information, you put a label on a document in Office 365, it's data classification. And I did a big stretch where I was working around information protection and data classification. And one of the things was is that you could not, you could add things to a custom dictionary where you had custom words that businesses use, that are like specific to that business. The only thing is, is once you put that word in, you couldn't edit it. It made no sense to me. There's no way to edit it. Now you can actually go in and edit the custom dictionaries. So that to me is kind of big just because I used to be so involved in that. But before, you actually had to go into Regex and you'd have to go in and do all this stuff. If you typed a word wrong, say you typed in the word date and you typed in DAT, app or something, instead of DATE, you couldn't edit it. So every time you mistyped it, the dictionary said, oh, it was good. It's a new global standard. Exactly, exactly. So coming new, launch your portal, using the SharePoint portal launch scheduler. Sean, did you guys, do you know about this? No. Oh man, come on. Sharon's excited about it. So, what's the impact there, Sharon? Well, I'm kind of watching the portal stuff. I mean, it's definitely been pieces of information, but it's this idea of essentially allowing other people to log into something specific from outside your tenant. So I'm waiting to see more info, but there's basically portals around Power Platform and SharePoint that I'm excited to see where that's headed. Yeah, so the SharePoint portal launch scheduler will allow you to coordinate and schedule launch details for high traffic sites. What it does is it basically allows you to create a portal in SharePoint or create a site and then schedule the launch where it becomes live at 8 a.m. Pacific on Monday or whatever. Actually, what they're probably doing, well, it's that, but the guidance has always been, especially if something is expected to be highly trafficked to roll out in stages with different user groups to allow the auto-scaling algorithms to spin up new virtual server instances for the farm. Well, yeah, and that's the portal launch scheduler. According to this, I'm reading this from the release, is the portal launch scheduler enables site owners to batch groups of users into waves. Oh, yeah, that makes sense. During the launch of each wave, you can gather user feedback, monitor portal performance, and pause the launch to resolve issues before proceeding with the next wave. So that's kind of cool. And then it also will add the scheduler provides an automatic redirect for existing sites if needed. So that's kind of cool. That is cool. I'm gonna close up with a couple of roadmap items that I saw, Microsoft Teams Power Automate Templates will now be added to Teams templates. So all the folks that love to do Power Automate stuff, now it'll be actually added to the Teams templates and that's gonna be coming out pretty soon. You'll be able to create right within Team a predefined channel and pre-installed apps. You'll be able to throw Power Automate code right in there and be able to run it just as a template inside of Teams. Microsoft Teams live transcript in unscheduled team meetings. So that's kind of unusual. I mean, I thought live transcript is really based around understanding a person's voice and language. You know how in PowerPoint, if we want to use the ability to do captions or transcript, you had to kind of, you know, it was better if you trained it, but now they're allowing you to do it unscheduled team meetings, which means you can have people that are talking that live transcript is gonna, I guess, do the best it can, right? I saw people talking about this weekend about the speaker attribution as well, which is really cool. So you can have, if you've got the feature turned on, you're in a live meeting, a lot of people. And so it actually, as it captures the live transcript there as well and tries to identify and, you know, right there's part of the transcript. So if you're reading along, and it's not just having to follow which box lights up, which profile who's talking has it right through the screen. And I think it'll be interesting just to try it out. I mean, even for our podcast here, you know, our Get Together, if we actually turned on live transcript just to see how, you know, it came out of what was actually said and what was actually, you know, because when you get someone who has a little Canadian slang to their voice, it might not come through just right, right? I'm thinking this is another feature that is gonna require some work in Scotland. Yeah. Just a guess. There we go. It's happening in real time. It's happening, people. It's happening. All right, I'm gonna close it up. Group assignments in Microsoft Teams. This is, I think this is a feature that they're targeting at students, you know, teachers and students in education. I think they should be targeting it for everybody. What they're doing is they're gonna create something in coming out in August, September timeframe of this year that'll allow the new group assignment feature so you can organize your students. It could be project team members into groups so they can work together to create, collaborate and submit the same work like a whiteboard file or a Word document. And then each student in the group gets the credit and recognition for having turned in their work. I think that'd be great for project teams, you know, and being able to, you know, whiteboard something and then turn it into, you know, the person who's in charge of the project from a business perspective, but they're really focusing it towards students and teachers. You know, there are a lot of unrelated, I'll go ahead, Eric. Sorry, Chris. Unrelated, but isn't, isn't when a bunch of students hand in the same paper called plagiarism? Working as a group, Eric. Just like, just like we're supposed to be doing on this call, Eric, you know? Got it. Working as a group. You mean just like we're supposed to be doing on this call. In theory. Oh man. All right, Christian, I yield my time. Yeah, I was just gonna say that, you know, there's actually a lot that's happening, of course, in the education sector. I don't field some of the questions that I see that are out there just because historically, none of us have, you know, work in that space enough to know all of what's happening in education and with those license types. But there's, you know, a lot of the features, a lot of the capabilities, especially around meetings and teams are being pushed forward because of the education sector. So it's a cool space. I don't understand why they're pigeonholing it though. It's kind of like the whole whiteboard thing is that they kind of pigeon, remember I talked about that last week is a licensing on the whiteboard, they're pigeonholing it to a specific, you know, persona of people. So the whiteboard you can only get with a certain set of licenses now, which makes no sense, you know? And now if they pigeonhole this to say, oh, it's only for students and teachers, why, why, why, I mean. Well, that's the kind of feedback. That's true. They're limiting their support liability, let's be honest. Yeah. But that's, you know, so that's where you need to provide your feedback back to Microsoft to provide them, go on user voice or in Microsoft tech community and let them know, hey, this feature that's available to EDU, it needs to be in commercial. Like we need to have this within the enterprise. Yeah. Well said. All right. We should just give it a Christian and Christian can pass it on. We could just do that. So. Because he's an RD. He's up here, we're down here. Well, Sharon too, he just. Yep, oh, Sharon, I'm sorry. Pick it on me. Sean, what's the link that you just shared? Is that something relevant to the topic? It was about transcribing, I said. They might have problems in Scottish. It's a Siri video that is rather humorous and not safe for work. Okay, not safe for work. Okay, so just so you call that out right away. NSFW. So people are like clicking on it right now. Christian, did you run the disclaimer before the show? I did not run the disclaimer, but here it is now. We're not covered. We're not covered. You gotta add something there about, you know, links that Sean gonna post may not be suitable for small children. That's right. Small children. I know those four-year-old, officer 365 youths. Quite a big part of our. Yes, but those, those large children, the eight-year-olds that are over six-four, they're fine. Just small children. Okay, well, with that, six-four, what are you talking about? Wow. I see, so Mr. Paul Swider is watching and just made a comment here. Sorry if I missed this a couple of minutes. Oh, it's only two minutes back. Says there's a new AI ML company that does speech to text. They can even remove the unwanted ums for speakers automatically now. Yeah, so in real time, it's got it out there. Post it in the chat. In rev.com, so let me do that. I don't watch the live feed at the same time that you're doing this because it gets me all messed up. Yeah, I know. There's a link that he shared there. Just commit that to memory right there. What kind of link is that? I know. Well, it's because it's from Facebook. It's because it's Facebook attached all the crap to it. So they're going to take all my personal information and you're going to harvest it? Of course they are, yes. All right. No, no, no, you're going to pay them to take your personal information. Yeah, that's right. All right, well, let's thank you for that, Mike. Once again, for all those that are tuning in, there is nothing else important out of Microsoft Message Center except for the things that Mike has shared. Everything else is irrelevant. Because if it were important, Mike would have shared it. So if he did share it. I claim no responsibility. If he shared it. I do want to be excited about that came out of the Message Center is the SharePoint site templates. I've been waiting on that for a long time and I'm really excited. So if you don't know about it. Mike has deemed it as not important though, Sharon. No, we talked about it last week. It was actually released last week. If you would keep up on what I'm talking about, Christian, and you know, then we wouldn't, you know. I understand. Mike, you know, I've got the headphones in. It's not for this show. When you're talking, I'm listening to music off to the side. I've got a game going on my phone. I mean, that says other stuff. I can't be just how to sit there like, you know, he's just listening to music, kicking back, you know, drinking his coffee. Well, he's waiting. How, how waits to pounce? You want to know a topic? Then he's actually, most people don't know this, but how's actually listening to music. He's just watching the transcription go at the bottom of the screen. Captions, he doesn't actually hear what we're saying. Nice. I like that. I always have to be prepared for a legendary howl tirade. That's right. Absolutely. That's right. Well, let's jump in on these community questions. For those that are watching again, we are live streaming on Facebook and YouTube this week. Feel free to ask a question. I am monitoring live. There are questions that come in as we did with Paul's. And with that. Ask anything. Ask anything. Whether we have an answer or whether we'll be helpful. Yes. Well, community question number one, John says, we had a few carryovers from last week that we didn't get to. This is one of them. John says, I've uploaded a few files in SharePoint and after a few minutes, deleted all contents except column name from Excel. But after some time when I am loading those files in SharePoint, it still shows content. Why? Do you understand what he's experiencing there? I don't. But then again, I'm known to be slow. Sharon, does that make sense to you? Either saying that he emptied all the information out of Excel or he deleted everything out of the list. Maybe he did it in QuickView and then didn't close it out something properly. I'm confused by the question also. OK. Yeah. So I was confused, too. But I mean, my assumption was by mentioning, yeah. So in SharePoint, whether it's a if he. Well, I wonder if he's creating a list from an Excel file and then afterwards he cleared the content but then it's still showing the content. But sometimes if you have it in QuickEdit mode. So one of the things that people don't realize is that if you have something in QuickEdit mode until you hit exit, any changes you make are pretty much irrelevant. So it's possible that maybe somehow they're not managing QuickEdit mode correctly. That's the only thing I can come up with. There's Sherry. And there is Sherry. And Sherry, thanks for joining. We already introduced you earlier. So we won't go through all that formality. We'll just jump right in there. So Sherry Oswald, everyone, hello. And so I think that is, yeah, sufficient. We're all confused by the question. But I think that is a good answer of what could that possibly be. And let's jump to question number two. Something fresh and new and we'll just move on. We'll rise above it because we're professionals. So what you're saying is I haven't missed much. No, no. Because Mike was going on and on and on about message center updates. Oh. No, so Stefan says, hello, can you summarize or combine PDF documents in SharePoint? And he's got a long example, but that's just, I'm just gonna leave it there. No, but I put a link in there. You can go out to Adobe, they'll freely combine them. Well, that's actually something if it's, yeah. So if that's the issue is that you're creating PDFs and you wanna combine them, yes, go to Adobe to do that. If you are scanning items and wanna add multiple in, then you can use the Office app for that. And so you can create a PDF and add multiple files together if you're scanning or clicking photos of or adding from multiple sources. You can do that right from your mobile device. Or get Acrobat. Yeah, I don't know if there's an Acrobat plugin that you could do a Power Automate flow that would do it automatically because it sounds like what's happening is they've got pieces coming in over time, which sounds to me screams workflow because there's a process behind it. So, and I know that there are actions in Power Automate that coordinate with Acrobat. I just don't know if there's one that could potentially, you could put it on a time where you could say when there's something new to put it together. And I don't know the answer to that, but I do know you can do it in Acrobat. Yeah, you can manually do that in Acrobat. Yeah, so as items come in, you can have it, if it doesn't automatically communicate with it, you can have it go into a folder and that you can manually go in and add those pages in to that PDF and save it in another location. So, I'm actually, go ahead here. There's a Band-Aid too. You could sync that library using OneDrive and then use Acrobat locally and combine them and it would synchronize up to SharePoint too. Right. Yeah, I'm actually anti-Adobe, so there's probably third party options that are available as well. I mean, I don't like Adobe because they just take your money and lots of money. Lots of money. Yeah, lots of money. I'm happy with Trapper Software Products as far as PDF manipulation goes. Yeah, you can create PDFs with Office, but I don't know if you can do any merging. No, no, there's a couple of QPDF. You can do it with that. You can do, you know, but it's, I just don't like Adobe. I don't like giving Adobe my money. Just like some people say they don't like giving Microsoft their money, but they have to. Or Google or whatever, yeah. Yeah, yeah. I know every year I have this conversation with my wife who's a designer. I'd be like, which Adobe products do you really need? Because they're not cheap. Those annual renewals are just crazy. I need Adobe Cloud and I love it, so. I don't know if anybody saw. Yeah, I have the Creative Cloud as well. Yeah, I don't know if anybody read the article. It was just in ARS Technica, if anybody follows that. But there was an article in there about a guy who actually got, if you have an annual Creative Cloud and you cut it off early, you still have to pay them, okay, for up to 50% of the remaining months that you don't even use it. It's in the agreement, yep. I know, but it's crazy. I mean, it's like having a subscription and, you know, oh, I don't use the whole thing. You know what it is, Mike? It's like trying to quit your local gym. That's what it is. Yeah, yeah. But why would I pay Adobe for something I'm not even gonna use? I mean, it doesn't make sense. Yes. Well, and it's all or nothing. Like, I actually, I'm trying to figure out how to clean out my hard drive because it's all bloated. And when I installed Creative Cloud, there's all media encoder and all this stuff. I don't need any of that. But you bought it, you pay for it. So you can have it if you want it. And you have to sign the agreement to Christian's point, it's in the agreement, right? Better be there. When you have the Salt Lick at your desk, you're going to feel bloated. Am I off topic? All right, let's jump to question number three. You need better eupanism, man. You really gotta come up with some better music. I was literally talking about a Salt Lick. If it were socially acceptable. What are you, a deer? I would have a Salt Lick at my desk. So I don't have a sweet tooth, I have a salt tooth. I'm married to a cattle rancher and yeah. All I can think of is the bigger cow. Nevermind. Okay, nevermind. All right, question number three from Andrew says, here's a question that has been asked of me and my company. I need to share two Excel files in 365 through various email accounts, which can be edited or fill in the boxes, but not saved locally. So no download and not printed. Can you tell me if SharePoint can be done? Because the SharePoint used for this. Two Excel files shared via email, but that can be edited, but not saved and not printed. Can't you just do that in Excel online? Yeah, you can do that in Excel. I believe Excel has multiple features that will allow you to limit what people can do inside of Excel, specifically. Yeah, I dropped the link, prevent download, but allow online editing. So really it just comes down to setting the user only to read or view only permission in SharePoint. Wow, Sean comes back and he's like contributing, man. He's like, well, yeah, I gotta make up for this. I've got to, you know, extract that. Excel has a ton of features that people don't realize. Excel is kind of like a little mini application that has a ton of options. And I don't think people realize how much you could do in Excel directly. It's like all the Office products, bloat. Yeah, yeah. And for those again that are following along and are wondering, the links will also be in the follow up blog post for all the questions as we cover, so you'll be able to go to Buckley Planet and find the recording as well as that link list. And I'll paste that. Are you following along into this? And I will paste all of that over into YouTube as well. We have an audience. I thought it was just us. Sometimes. Just swider, I swider. Yeah. All right, great. All right, so question number four, Fiona and Hal has already jumped in with the link there. But Fiona asks that someone has logged into my Outlook account and I can't log into my Outlook account. I Googled it and it tells you to change your password. They send you a code. When I get the code, the email showing is not mine. I don't know what I should do. Has anyone got some advice of what to do please? That's essentially a call Microsoft support. Yeah. I'm really stuck with the reset code isn't for the email, but how did you get the email if you didn't? Well, there's two different. It's an online reset code. Yeah, because there's two different places, right? So in your Microsoft account, you can set up the phone number or MFA, but then you can actually go in and change the email address, but it won't allow you to change the email address and the verifying phone number at the same time. So I think that's where it's coming in. Somebody hijacked our account, went in and changed the email address for the owner of the account, but they can't go in and change the verification phone number. So that's my best guess too. Call Microsoft. Yeah, yeah. Hire a hit man. Expensive. That's an easy way out. Expensive, expensive. It's so expensive. Hal is speaking from experience. Yeah. Well, look at that hat. I mean, something's going on here, folks. Nervous. Hal's making me a nervous Christian. All right. I'll have to stop. There, got better. So question number five, Patricia, I'm a beginner with SharePoint. Right now, yeah, I'm assuming. I'm her side of the mic. Patrick, okay. Yes. Patry Goose. Patry Goose. I'm a beginner with SharePoint. Right now, I'm creating a side for my team where a site where published different files. The team is using iPads. This is obviously translated over in Facebook, folks. So it's a little bit rough on the translation. But following this, I would love to create the notification and send it on mobile devices each time I will publish any files. Is there any opportunity to do this? So sending notifications every time files are published. I know that there is one option. With it, I can send notification by email, but I don't want it. I want notification on the app. So SharePoint app or the Teams app, I think is the question. So let's talk about the difference between them. So this person has only talked about SharePoint, not about Teams. So there's updates to a list or library and new files are being added. Is there a way for notifications via the app? I mean, you can do a Power Automate. That's what I was thinking. But I don't know if there's nothing native that I'm... I don't know. I'm not as smart as you guys on that stuff, so... There's alerts on the library and the owner of the library can set them for other people. But that's not the difference. But that's the emails. He's looking for updates on the app itself. Or they, whoever they are. The alerts send emails. I don't know if they send updates in the apps. I haven't played with the apps on the mobile devices lately in terms of updates. I do know in Teams and in Power Apps, you can publish, you can have pop-ups that happen essentially. I know in Teams you can do that and I know in Power Automate, or using a Power App, it might be... I mean, if they really wanted to go beyond that, they might have to use a Power App for it. But I'm not sure. That's a good question. I might have to go play with that a little bit and see if you can do it in the app or not. I don't know. Homework. Homework. She just volunteered for homework. That's what I heard as well. Yeah, I'll test it out because I'm curious now. Okay. Homework aside. Sometimes it just becomes personal. When you don't know the answer, it's like, that's personal. I need to figure out a chef. Yeah. Or when hiring a hit man. That also becomes personal at that point. Well, I feel like if one person asks me a question, more people will probably ask the question soon so it's a good thing to know. Yep. Copycats. Okay. Question number six. Ares says, so I'm struggling with something that should be simple. I have a SharePoint list which I added an image type column but it doesn't appear as an option on the PowerApp form. It is linked to even after refreshing. Can somebody help me? Don't all jump on it at once. Yeah, I haven't built a ton of PowerApps yet. I'm still kind of a baby playing with PowerApps but I do know that images and PowerApps are still a struggle. In terms of selecting them and finding them, like you can embed them but I and I don't know any more than that. Yeah, I think we've had a variation of this. A couple, it might have been like a month ago. I think we had this similar question about this. Yeah, the image type column and SharePoint. You know, that's not an embedded binary. Right. It's a hyperlink. It's a hyperlink. Yeah. So I'm thinking. Anything that's a reference gets difficult in PowerApps. So you probably have to point, I wonder if you point it directly to like a library where the images are stored that might make it easier, but I don't know. Well, this is, I've already got a question out to Laura Rogers from last week. And I can always, I can follow up with this one as well and see if she's got a quick answer for this. So let me, I'll post this out. We need to start inviting some PowerApps. Yeah. Or just use a disclaimer. I don't know. I'm getting so in our space. I feel like it's coming. Yeah. Well, I wish they would have, I wish it would have been that way when it was flow. You know, but now it's picked up because it's got the word power in front of it. And they have a whole new team behind it. And it was just as good when it was flow, but yeah. Yeah. It is what it is. All right. Question number seven, Santosh says, Hi team, I am working on a PowerShell script to read Excel data. Excel is hosted on SharePoint and shared across the organization. I have no background about permissions of files shared using SharePoint. Please let me know if a user can open an Excel file over the browser without signing or without any credentials or without authentication. Thanks in advance. So SharePoint files are just OneDrive, right? So it might correct me if I'm wrong, SharePoint folks. You have the ability to access files that are in SharePoint just by going to a OneDrive location, correct? It's splitting hairs. OneDrive is SharePoint, but SharePoint is not OneDrive. I had this conversation the other day. But I think the question that he's asking is can you do anonymous usage? And yes, you can do anonymous access in SharePoint or OneDrive, assuming things are configured correctly at the tenant level, the SharePoint and OneDrive level and or the team's level. What I was getting at is whether or not in the PowerShell script, if he's calling it as an absolute path or a relative path. So can you see, and I'm just asking this question in general, can you see or get two files in OneDrive that are hosted in SharePoint? Is there a direct path to that? Can I go into the OneDrive on my local machine and drill down to a SharePoint site and then actually get to a file that's hosted on a SharePoint site? Yeah, you go to the tenantname-my.sharepoint.com. So that would be an absolute path. So you'd be able to, okay. So in a PowerShell script, if you had permissions to that file, because we're going a little bit deeper on this, when that file is in that physical location and that absolute path, what permissions take control of that file? Are those NTFS permissions or are those SharePoint permissions? SharePoint permissions if you're going against the SharePoint site. Yes. Okay, so that site permission controls access to that file, not the file system that it's sitting on. As long as it's not blocked by something before that. So let's say, for example, if the network is blocked by external access regulations or AD, if they have AD or Azure AD to set up to not allow external access, that can actually be blocked or if they have whitelisted URLs or whitelisted domains, sorry. You know, if they're limiting the access at a higher level, that can be managed. But if they're not limiting that, then yes, what you're asking is true. And running scripts against locations in SharePoint also involves another permission level that oftentimes is not set by default. Yeah. Okay. Especially if it's, yeah, especially if it's online because that can be enabled and disabled as well. Catch you. It's a tricky question because it's kind of like there's a lot of gates. You have to go through assuming that all the doors are open. It's possible. It's possible. Yes. Good. That's a good to understand because I was trying to understand when you're programmatically creating a script to read a file or to pull a file or to manipulate a file, it really depends on what permissions are granted to a user to see that file. Now, that's the governing thing, right? Is what is actually controlling the permissions of that file? Is it SharePoint? Is it, you know, something else? NTFS? Is it, you know, what do you have to get down to to actually give anonymous permission to that file to be able to read it or whatever? Another tip, another big thing we run into too is especially if you're using a service account, it's a really smart idea to have a service account that doesn't have MFA enabled because if you have MFA enabled, it'll also try to credential it every time it tries to go and I know that's not for the anonymous side but if you're using a service account to access files especially in an online tenant, MFA can get in the way a lot. Security folks are just right now going boo, boo. Now, assuming he gets the Excel spreadsheet down, whether or not he's gonna be able to do anything with it remains to be seen. You know, CSV, you can import CSVs into PowerShell all day long, but you know, we're talking Excel proprietary format or even Excel XML format, it's like. Well, there's no, I mean, PowerShell has a built in logic in a command led called import from Excel. So you have, it has logic of import and Excel but it looks for a delimiter of some sort, right? It's not an import from CSV, it's an import from Excel. Okay, I typically when I'm using spreadsheets and I know I'm gonna be using them with PowerShell, I don't bother with any of the office formats that do straight CSV. A lot of folks don't. Yeah, just because of the headaches it creates. Yeah. Fun with SharePoint on a Monday morning. Yay, I know. Well, I like to line up all of the SharePoint questions early for Mike, but no, it just, you know, it was just the questions being asked. It's the luck of the draw. It's interesting looking week by week and sometimes there's just a, you know, a flood of teams questions or there might be just a, and I did very quickly go through and even like in Azure and PowerApps, I very quickly run into the questions that we saw, you know, last week. And so we're out of kind of the new, so. Don't we have a telephony question in here somewhere? I don't believe so this week, so I'm sorry. Yeah, I just had to ask that, but. No bonus points for any of us. If we have time at the end, I'll just think up one off the fly there for you. I really want a gold star. All right, so question number eight, Ahmed says, what will happen if a user is given global reader role based on group-based RBAC, so for example, local AD, synced group, having access to subscriptions as global reader at MG level? And also if we provide the same user Azure AD role from PIM having global reader, so which role will take precedence and what would be the best practice to provide roles if we have group-based RBAC and PIM enabled? This is confusing. Yeah, I mean, global, the global reader role in Azure AD controls obviously everything in officer 65 MG 65 in Azure. So if you have global reader role, it's going to go across everything. I mean, the RBAC is only applicable to individual resources within an Azure, you know, it's not a global setting, it's individual settings. What is the MG level? Am I missing something there? I don't know what that is. We're all missing that, so. I don't know what that is. Is that management group maybe? Maybe. At the management group level. Maybe they mean like a security group? Yeah. Oh, I wonder if it's a Microsoft group. Well, management groups are a thing in Azure AD, just like M365 groups are a thing in, you know, in 365. So I don't know that to me it's confusing. I mean, a global reader is a global reader unless you have a resource that specifically has an RBAC permission set for that person not to be. So it's allow, allow, allow and then deny, right? And so. I'm wondering if they're asking if they have access as a global reader in Azure AD, will that override for the stuff that they have on-prem if they're limited to a certain group? Well, okay, so then I have more questions. I'm trying to figure out why they're asking the question. Because that's why we're here as a community, as leaders, as experts. Again, I'm gonna just put the disclaimer on screen for a second there. Right, as experts around that. It's just to ask more questions, confuse ourselves and the audience even more. So continue. Yeah, I mean, do they have Azure? No, Azure AD is AD. I mean, that's what I don't understand. There's no differentiation between the two unless you have two different domains set up unless you're not doing the sync. Well, that's what it says. It says, for example, local AD synced group. Well, then it's just under AD. I mean, there's no difference. There's no difference except, you know, that one's in the cloud and one's on-premises, so. I do find that if they have a local AD group that synced out to Azure AD, that sometimes they have limitations with the local AD accounts if they don't have an Azure AD account. But if they have both accounts, then I don't see any limitations. It seems to be that it just syncs everything together. We're back to global readers, global readers. Global readers, global readers, yeah. If you give them global read, they're gonna have global read. It doesn't matter where you give it to them. Yeah, and he's asking, what would be the best practice to provide roles if we have a group-based RBAC and PM&AML? One of my best practices is not to use an acronym until you write it out. Just saying. Just saying. That's part of the magic of doing these sessions, though, is trying to... Oh, this is magic? Interpret what the author meant there since we don't have the chance to do a follow-up question. Do you have to be a mind reader? Like, that's part of the job. I'm gonna bring my magic eight ball up next week. Yeah, that's right. Cool. You got one. Ask again later. Can we make Christian disappear? Dan, he's still there. I'll give him the advice I give my kids and that is don't leave yourself open to interpretation. I mean, in the world today, just so you know I'm in the world today, technology world, Microsoft has 5,000 different acronyms for 5,000 different things and some of them are the same acronyms. So we can't know everything. PIM could be a lot of different things. I know project managers would use it for something different than what engineers use it for. So, and I remember PIM from an old acronym was the personal information management with the, what were the divisors? The palm pilots. Well, that's right. That's right. That's right. They were a PIM device. I remember that. Are we talking about palm pilots here? That's right. You know, I still have mine. I mean, it's in a box. Of course you do. Of course I do, yeah. Right next to the zoons. Is, as we say, wasn't that the device that won? Who has the oldest device in the door contest? I think so. I think it might not. Yeah. So I put a link out here. I think the big answer to this is if you don't have somebody helping you with your maturity model and your governance, you probably should if you're asking best practice questions around admins. So I just put the link out here, the generic link for administration and kind of getting governance started around those particular roles because I know I spend a lot of time working with my clients on getting their governance set up around M365 administration. So that's a good place to start. Awesome. All right. I can't wait to get to question 10. So hurry. Okay. All right. Question number nine. I'm gonna ask it very slow. It's like when my driving with my kids and they're small and be like, Dad, get home quick. Gotta use the bathroom. So of course, Dad, then I drive a stick, jerk in the car, slowing down under the speed limit. Call the things like, why would you give me that information? You were just a mean person. You're just like, he's like, do you know me at all? Do you know me at all? I'm loving a parent would use that information for good Christian. All I'm saying is it was part of a longer strategy in raising my kids that one, my children, they know that they're loved. Number two, they know that there's no way in hell once they turn 18, they're ever moving back home. And it's, that's- When Christian finally kicks, his kids are gonna pack him into a car, drive along the road and roll him into a ditch. So I think there's, I've talked about this before. There's general acceptance that as in my, that it's like, you know, Dad's gonna live longer than mom's. And they did the one, two, three, not it on who gets to have dad. So, and then I just, I just mentioned that whoever takes care of me is directly tied to the will. So, you know. There you go. Anyway. Well, they say that if you don't want your kids to move back in with you, don't make it comfortable. I guess if they have to continually go to the bathroom and the car, that's really not comfortable. So, mission accomplished. The kids came up, there's a whole joke back when propel was new. And we'd always have cases of propel in the back. My wife would drink the stuff. And so the boys would always joke about peeing in the propel bottle as needed. And don't drink the open bottle of propel that's on the floor of the back seat if the boys were on a long trip. Anyway, okay. Hey, speaking of, I forgot to say, those that know my son Preston, so he and his wife are expecting to induce tomorrow. So, little grandson number two should arrive tomorrow or Wednesday. And so little Carter Buckley should be here soon. So, I'll let everybody know. Pick the name of any of them, is that a time? They picked the name already. Of course they did, yeah. Assuming that it comes out and they'd be like, no, no, no, that doesn't look like a Carter. That ain't a Carter. That isn't a Carter, no. So who knows? Could happen there. All right, number nine. Dan says, when I purchased Microsoft 365, it was so that I could convene meetings with any attendee I sent an invitation to, clarifying that these attendees would not have Microsoft 365. That's the only reason you bought 365, really Dan? I discovered over a month ago that non-365 attendees cannot see each other, compromising the meetings. After 15 hours of discussion with six different tech staff, I was told that teams cannot do this. Ha ha ha. How much did he pay that tech staff? I wanted you on that tech staff. This is not indicated on the sites pages or TV ads being aired these days. Do any of the users have insights into this? And so, I'm a little bit confused by this because, so one, whether it's meetings or live events. If you're talking about live events, no, they don't see each other. No, not unless they're presented. Nobody sees each other. It has nothing to do with the login or not. I've never had this problem in a team's meeting ever. Yeah, team's meetings, no problems. My guess is a configuration problem. Yeah. Sometimes you see people and you wish you didn't. Ha ha ha ha. Yeah. But yeah, this is, I look at this as user admin error, not as the features, because I have meetings all the time there are a different people who are admins that are just users with paid licenses or free that are joining that meeting. You can send an invitation to anyone. Just open it in a brown. Correct. Yeah. And I see them and they can participate. Yeah, the two questions I have around this is number one, live meeting now, as we know, has come out with a feature that external users can now present their video inside of a live meeting if you make them a presenter. Yeah. Okay. And then really, 15 hours of discussion with six different tech staff, really, and they can't figure this out? Ha ha ha ha ha ha. Well, I'm wondering if, honestly, I'm wondering if it's not the Microsoft tech staff because- Oh no. I had the same- No. Ha ha ha ha. I had the same issue when I was trying to figure out why I had, I couldn't, so I had a personal Microsoft account and then I had the business Microsoft account. When I changed the domain, then now you have two. There's an, I didn't know this, I know now. There's an Azure AD and then there's a, you know, your domain. There's two different things. And I'm like, it is a Microsoft account. It's Office 365. So that's my point. It's like, you can spend two, three hours, especially if there's multiple phone calls, of just doing that basic stuff before they ever get to the actual question. Right, yeah. That's part of the frustration is, can we cut through all of that? And let me just pose the technical question that I'm dealing with and let's have a discussion there. And I- You need to connect me to tier two or tier three button. Right, and I get that they need to have that baseline. And- Can the next guy have read the baseline first, please? So I don't have to go through the whole thing again. I don't think we're having a Microsoft you because we have kind of worked this out and figured out who we can talk to. And a lot of times we can answer that question faster than support can. And if we do need to escalate it, we have the ability to escalate it all the way up. So that's what partners are for. So I actually figured out how to fix it. And me, the ABC consultant, anything but code, fixed it with PowerShell up on myself. And I figured it out. And I said it back to them. It was like, by the way, this is the solution. And they're like, we get this question all the time. Well, this is the solution. Why didn't somebody figure it out before me, who doesn't code? Yeah. So I can see, I could totally see that six texts in 15 hours because I lived it. I just don't, I mean, I just don't see anyone. What you did as Indonesia or the Philippines and just as the gentleman says, you have a difficult time understanding what he's saying. And he has a difficult time understanding what you're asking. Yeah. And you know, like I said, you have a push AT, give me a tier two or a tier three support button or give me somebody in the United States who has a better command of the language and can understand what the heck I'm saying. And now, I mean. And they're not using acronyms. And that's the thing that my big encounters with Microsoft support has been over surface surfaces. I had a Surface Pro 4 still have it that developed the infamous screen shake disease that that particular model was famous for. It was replaced like five or six times, but like I say, each and every time, I didn't say, I'm saying now, each and every time I had to deal with this, it was all these, you start off in Indonesia or the Philippines or someplace like that, you go through the whole routine again, may or may not have read the person's records and you just go on and on and on and on forever before you finally get an answer. And it's, I wish there was a better way. It's sad to say that I often will have issues that will go for weeks or months just because I don't have time to call support for that. And then somebody reminds me, well, as an MVP, you have premium support. Like, oh, where did they pull that out of? Still gotta go through that process. And you're totally right. And then they're amazing about following up. They're like, I'll follow up with you tomorrow and I see the phone call and I'm like, I can't answer it. Three or four days they're nagging me to close the ticket, which I appreciate because they're following up. But it's like sometimes, I don't have time right now to sit on the phone with you for two more hours. There's a reason why for some, again, these are not just office, just basic office app problems, but we're having an inside person and being able to call like a billbearer and answer deeper questions is a great benefit to being an MVP or an RD. And have more. Or to simply annoy Bill. True, it's a mix of things, true. But so the fundamental question or the answer to Dan's question is like, Dan, yeah, you can. So this is user admin error because yes, you can invite anybody and they should be able to see each other and participate in a meeting, in a live event. If that's what you're using, the live event capability, no, they will not see each other because that is a one way, it's a webcast. Use the admin should see everybody, correct. Unless you add them. The admin sees them and then can add them as a presenter, right? So, okay, question number 10. Shiraz says, I created a VM in Azure with high specifications, not medium or low specifications. High, high specifications. But why is my VM very slow? I have 25 meg second internet, but still having an issue. The VM is very slow, need help. Was that, I set it up for you. You're so excited. Where do I start? Okay. Where do I start? High bang. I thought of this thing. I thought, you know, when I added this in, I thought, you know, mice could unload here. No, no, I'm going to be really nice about this is basically we need more information, Shiraz, because you create a VM in Azure, just because you have 25 megabits of internet, doesn't mean that you have the same connectivity, but that really has nothing to do with the resources in use on the machine. We don't have any information on the machine. We don't know what you're running on the machine. We don't know if you get a, you know, maybe it's a Linux VM that's got a runaway process that's just consuming all the CPU and RAM, and you can't connect to it, or it's a Windows box that just natively is, you know, not allowing you to connect RDP. I don't know. There's so many different variables. We need more information, but in general, VMs as they're created in Azure are not slow by default, unless you create them as slow. So if you created them, you said high specifications, I'm assuming that means that you have maybe a D level machine or higher. If you have an A or B level, then yes, it could very well be slow because of the sizing of the machine, but if you have a D level or higher, I need more information to evaluate, that's all. That's it. All right, okay. Anybody else wanna add anything to that? Yeah, if they were asking about some other applications and issues and things that are out there, and I know that I spent years prior to the Office 365 existing as a PM had fun creating a dedicated but hosted collaboration platform back in the early 2000s and got involved in all the WAN optimization and understanding edge devices and performance issues with massive file sizes and design doc sharing and viewers and kind of all those different things. I know this is a slightly different thing, but yeah, there's people's expectation around like, I've got a really powerful computer and I have fast internet. It's like, yeah, there are a lot of parts to doing collaboration and depending on where the process and where the files live and yeah. Okay, let's jump to question number 11. Andre says, can anyone help me with the following? For every meeting and attendance report is created and displayed in post, that is great, but I don't want to share it with guests. Can I hide this report for guests in post? If yes, how can I do that? The attendance report is new and I've seen this question, people don't want it to have that published. So I was hoping y'all had an answer because you had some people ask. No, I think if you cut them out of the chat, then it cuts them out, I mean, if you cut them out of that, it cuts them out of all the chat. And if you don't create the attendance report, then you're not getting an attendance report. I don't know that there is a middle ground yet that I'm aware of. Why would- You're outside the circle of trust. Why would Microsoft publish, and obviously this is a, should be limited to admins only and push that out to everybody. That makes no sense to me. It happens in team meetings, but so in a live event, only the admins have access to the attendance report. In a team meeting, which is open. In a team meeting, yeah, it's a collaborative meeting. So I think they're trying to imply that peers are all equal and maybe use a live event. I mean, you can see the attendee list in a team meeting, right? That's true. Right. So it's already visible, they're just giving you an informant, you know? Right. I guess we're talking about an organization where some people are more equal than others. That's a great- That's a great point. The answer is a live event. Yeah. If you wanna not share the attendance report. That's a great point because I've actually sat and done that. I've joined meetings, and I went through and it's like, who are these folks? And then gone and grabbed their email and done an offline aside conversation, contacted them about a point made and doing that. If they already have that information through the meeting, what's the difference with them having visibility to that attendance report at the end? Does the attendance report give you more information than what's available in the, okay, I don't know that. I haven't looked at one, so, okay. Now. Yep. So, yeah. Let's move on to Christian's question. Yeah. So this is a- What are you thinking about this one? This is somebody else that's named Christian. It's not me. It's like we might have a highlander moment later this week. There can be only one, but for now. Going back to house suggestions for hiring someone. Oh, okay, I'll move on. Has anyone successfully implement BCS with SharePoint Online? We tried to use Azure SQL as a BCS without any luck. It seems Power Apps is the future of working with external data, but lacks promoting fields like InfoPath so they can get indexed. Also, external data columns don't appear to be compatible with modern list forms. Any other alternatives? We need SQL data from an on-premises or Azure to SharePoint metadata for DocLibrary. Not sure if we have better luck with WCF and BCS, but that only works for classic lists. It's Power Apps with license and flow with list columns to match input fields and a flow to update these columns. All right, Sharon, take it away. Yes, so I have lived in this world for the last year. I finally escalated it all the way to the very top as far as I could and I got a private meeting and I worked with the cloud architecture team and the answer I received was, there is no formal plan for BCS and SharePoint Online and the writing is on the wall. That's the answer I got. I have not been able to successfully use BCS and SharePoint Online and so what we have done is we have gone around the back and if you don't know about Azure Functions, Azure Data Warehouse, Azure Logic Apps and then also on the dataverse side, all the connectors, you really need to kind of start reading up because if you can do it with a dataverse connector, that's the easiest way to do it. So SharePoint has an out-of-the-box dataverse connector to all of the Power Platform stuff. If you're gonna go outside of Microsoft stuff, then you need to go the Azure Function route and there is an HTTP REST call inside of Power Automate for an action that you can force an API from anywhere basically into a SharePoint list. So it kind of depends on what you're using. If it's inside the Microsoft universe, I would say use a connector if at all possible and if it's outside, then I would say move to Azure Functions and Azure Logic. I have to say that that is probably the most complete answer that has ever been given on this show in the last 50 some episodes that we have done. I applaud. Well done, Sharon. Well done, well done. But I will say one thing about the question. Anyone uses the term on-premise again, punch you in the throat. It's, I've got to punch you in the throat. It's not a word. Yeah, you know, so something I used to do too with our show notes, for those that I sent out the questions in advance sometimes with a couple hours notice, but usually like the night before or Sunday afternoon, Sunday evening, I'll send it out. But I have stopped going in and spell-checking and cleaning up. They truly are just the raw out there because I agree with you, Mike, because I think that that tells me something. If somebody uses capital S but lower case P where separates share and then point as to separate, like- Power shell. Power shell. Right. I almost- It tells the story. It does. It tells me a little bit about the person asking the question, honestly. About, yeah. How would you like to sit in a meeting with a CEO and CTO of a company for two hours and have them use that word like 30 times? My OCD, I'm sitting there like, I'm going to bust at these guys. They're, you know, there's C levels, but I'm telling you, man, you don't know what the hell you're talking about. Yeah. I know. I like correcting people on the on-premise. I said, is that the way the writing style, the on-premise, they're on point of the word. Like I don't see how that's relevant. And on-premises system, on the other hand, would make much more sense. Could you please clarify? Everybody should now sit down on-prem. So instead of getting it wrong, they just say on-prem. I say if you're on-prem. Right. But on-prem isn't actually in the Webster's dictionary either. So, whatever. But if all else fails, use on-prem, or if otherwise confused about the difference, yeah, I'm with you. I love that. And I love correcting people with that, but I try and do it in a way of saying, you know, I want to make sure that people know exactly what you're talking about to your point, Christian. And, you know, it's on-premises. And I try not make them feel belittled. Yeah, for sure. I'm trying to let you kind of let you get out of the bag that you don't know what you're talking about if you use that phrase. Exactly. You want to edumicate people. Now, one of my favorite jokes from that movie, was it the interns at Google? So Vince Vaughn and, you know, it's how he repeatedly calls it. And then we can put it on the line. It's like, it's online. It's like, it just keeps saying again and again, on the line. The poor, like the techie guys, just keeps trying to correct him. It's awesome. That was Vince Vaughn and Owen, wasn't it? And Owen, yeah. They're a pretty good duo. It's a good movie, so. All right, let's see, number 13. Galeno says, hi, I would like some help. I bought a new PC and logged in to Microsoft with the same account as the old PC yesterday. I don't know how I found all the files of the old PC on a new one. How can I get the PC back new clean? Keeping the integrity of the files of the old PC, thanks. It's just, what could be happening here? I know. Yeah, it's just a Microsoft login. I mean, you're syncing, that's all you're doing. So create a local account, you know? Or pull the network cable. Yeah, well, no, that won't get rid of the settings though. Or just click the reset button on your new PC. That'll work. The old PC, is it connected to the new PC? If you reset the new PC, the old PC will stay intact. What do you mean by reset though? Yeah. You said reset. Reset the factory settings. Okay, reset. Restore defaults. Yeah, okay. Because there used to be a reset button on the old computers, you know, there was an on-off. We still want the new computers, too. Is it that there's an option to reset it back to the beginning and it just takes your account out if you want it to go completely back? Is it the one where you had to use a paper clip and then bend it and push it in there? Yeah, yeah, yeah. No, actually, I had this just happen with my in-laws. Is that, you know, they were freaking out because they were like, how does this machine know that we have all this stuff? You know, how did my pictures and everything get, I'm like, because you'd like to use the same thing. Yeah, exactly. I said, did you get vaccinated? Did you put the chip? Yeah. Check your computer somewhere. It'll give you your heart rate. Yeah. And it just comes down to just don't use that account or go into settings, go into user accounts, and then there's an option to create a non-Microsoft account or what they call an offline account, I think. Something like that. Yeah, local user. Local user account. I do that all the time because I have like 12 different profiles on my computer because I have different clients and it's easier for me to log out and log back in. And then after I create the local user with the standard password I use for all of them, then I go back in and add the Microsoft account for that company or client that I'm working with. And it's a God send to me because otherwise I'm frustrated. But I think part of it too is if it's a Microsoft account, it's our one drive that's syncing to their desktop, which was by design, but you can turn that off. Yeah. Yeah. I mean, the easiest way out of it is do what Sharon said, is just go back and do a refresh, reset, or restore, whatever, and that'll, because that user will continue to exist on that machine. Continue what Sherry says, log in with a create a whole separate account and that way it will pull on through. Right. And then if you log in again, but if they don't turn off the syncing in one drive, it's gonna just do it again. So you've got to make sure that you unlink that account and log in as a local user. And then when you, in one drive, you can tell it which folders. Do you want it to sync the documents, the pictures, and the, is it documents, pictures, and video? Desktop. Desktop, thank you. And turn that off and then it won't bring all that old stuff. So the question too is the purpose of that machine. If this is Galinos, this is a second machine, but you want to keep the files separate. It's like, well, but what's the problem then if it's your second machine of having access to those cloud enabled files in both locations so that you can work on either? If you're setting up a machine that's for another person, then yes, then go wipe that clean, create another profile. Or you just want to start off from scratch. Maybe you just want to start off from scratch and then gradually copy stuff over, you know, get rid of the garbage. He doesn't want the garbage that he, you know, doesn't want to bring over. I don't know. So then you just choose which folders you want to sync on the host, the original machine and stop syncing those. And then when on the new machine, choose which folders you want it to sync. Yeah. Can you tell I do this every once in a while? Well, we have three devices that'll bring everything with me or where I go. This has been, it has been just a lifesaver. As I've tried to, well now, especially work from home, I have everything on my workstation and how easy it is to make these things accessible when I go and I'm on the road and put out in the cloud. So I actually have nothing local on my laptop and I only use that, things that are in the cloud, pull down those files, a presentation or something else that I need when I'm on the road. Yeah, that works 75% of the time. I mean, there's another 25% that just they won't sync because the app doesn't recognize syncing or whatever because I have the problem. So pessimistic, but yes, I understand. No, but I get it, no. And that's why if you're going on the road, like I'll have a couple dozen files that I know I'll be working on, I'll make sure I'll do that while I'm still sitting here in my home office, make sure the sync happens and they're moved over there and then go on the road and to not rely on that. So I'm still of the, remember when SkyDrive was still new and I'm a music collector and I had multiple external drives and everybody was like, I'm moving my collection out on the cloud, I'm using up this space and I went for that and then I lost half of the music that I put out on there. Of course I had my cold storage, the CDs, the thousands that are in my food storage closet over to my left here that my wife just keeps saying, it's like, when are you gonna get rid of all those CDs? I'm like, I'm gonna be giving those to my grandchildren and great-grandchildren. They're gonna throw them out of the car when they roll you off on the side of the road. Probably, that's right. There's room in the ditch for them. Not if they read the terms of my will, they won't. I have a throwback for you all though. I do the same thing you do, Christian, and instead of bringing over certain folders, I have a, in my OneDrive, I have a folder called briefcase. Does anybody remember briefcase? Yeah, now it's personal vault. Oh, the personal vault. I move things into the briefcase and that's the only folder that syncs with me when I go on the road. That way I know everything. And then when I come back, I file it back away where I want it to be here if I'm on the road I can get to. Yeah, briefcase works much like the, you know, the my day and to do. And so I just was adding things over from the various lists of tasks that have been assigned to me and I just, I do that every morning. It's part of my, the way that I work and drag things over just as top of mind a list of these things that I'm working on. But briefcase is much the same way. That's why one of the questions I have for the group is did anybody use the personal vault in OneDrive? Okay, so let me, let me ask you this is that I have a problem I enabled a personal vault and when I am in an app that says save as and I go to save as and I click on personal, I can't save it to the personal vault. So when I try and do that, it comes up and tells me that I can't access the personal vault number one, okay? Because it's, you have to provide a password to get into the vault and some applications don't recognize, hey, you know, the popup that wants a password before it can start copying the file there. So does anybody else have a problem with that? Because I can't. I've not tried doing that. I've only used it you with File Explorer and moving files into it. So I've just, I've not seen it. Yeah, I was trying to save as because if I get it, you know, if I get backup codes for something or I get, you know, MFA. That makes sense that you would have. Right. Yeah, that's something to go look at. I've not seen that. So that'd be a great blog post. Mike, if you're interested in taking that as homework and tell us about it. She is. All right, let's, let's, we've got so another six minutes. Let's one or two questions. I think we can jump to you. So question number 14, Raja says, or Raja says, we have around 10 channels and teams. I need to send alert messages to students using a bot instead of posting in the individual group. Is it possible to send messages to all channels and notifications using a bot? Yes. As long as you have permissions in those channels and there are bots in the mic and the marketplace apps that you can, you can use. Okay. You have to do them individually. I don't think you could like do it. So I don't know if you could do it to all channels at once. That's the only thing. I think there actually, I did see a bot that'll do it to all channels that you have permissions to do it. Nice. And specify the channels. But it has to be, it's in the limitation of the team though. So you could do it at the team level. Yes. You could do it to multiple channels across multiple teams, but within a team to multiple channels. Yes. Correct. Yeah. Okay. I'd have to look up the bot name again too because there was one bot and there was created. And I don't know, maybe it's not, I mean, it's in the app store. So I'm figuring it out. It's legit. Who knows. Mike takes this as home. All right. Will he not? I'll send the reminder of that. All right. Question number 15. Gift says, hello, I need to help. How can I disable users to create teams? Don't forget the little crying face. Yes. And there's a sad face after that. With a tear. With a tear. Yeah. There's actually a cry there. There's actually leave them into tears, yeah. It's in the team's admin center. Is there a way to tell that to restrict users so they cannot create teams? I'm not aware that a regular user can create a team. Well, that's, you can enable or disable that. You can make it, you can give permissions to a group of admins. But they're admins. We're talking about users here. We're talking about users. Yeah, that was my question because it's either all or nothing. Right. You can't just cherry pick what users can, which users can't. That's what I thought. Yeah. Okay. Yeah. Sanity check. Yeah. So that's, has there been any discussion about putting a tiered support for that? Having like a. I think it has been majority of teams at this point. I mean, that the granularity permissions, a lot of those, a lot of the potential modifications are going to be driven from user requests and user usage patterns. Yeah. I think, you know, what we'll probably get, we'll continue to get the same sort of roll out of features, but I think things will get more granular as those become prevalent asks and use cases. Well, I know that there were a lot of third party solutions out there. I mean, we have App Point, we have it built into our platforms. You have like a SEBS company, a provision point. I mean, there's plenty of provisioning solutions that are out there to do that control. So you can, you know, disable it there, but have it manage that function through a provisioning application. Which undoubtedly is going to have much more control and ability to make things granular. And I know that it's Microsoft is developing templates and things for teams, but that, you know, a lot of the provisioning solutions already had a version of that that was out there as well. So just more control that way. The only other thing you could do would be to go back a step and manage who can control groups. And if you can do that, so I've actually walked through that where basically you create a security group and then you run a PowerShell command to basically disable users from being able to create Microsoft 365 groups. And then you put people in the group that can create groups. And so you can kind of determine who can do that. I'm gonna post the link to that in here. So that would be the only other way I think that you could probably do it is if you're managing who can create groups, then that'll also mean that you can create teams. See who controls the groups controls the world. It's true. Closer to the song to the universe would be, yeah. He who controls the spice controls the universe. By the way, can't wait for that the latest for those that don't know that quote from Dune. The new movie looks fantastic. Spice must have. I'm just so excited about that. And I will, and I've got the original Eon 12 inch as well as the CD single in the collection that my wife complains about for the song Spice, which was an old club hit in the late 80s. Love that. Around 88, 89 I think when that song came out. Well, we are at the time folks. So thank you so much for everybody on the panel for participating. Sean, Sharon, Hal, Mike and Sherry and Eric who left us early, Neil who's dead to us currently don't know what happened to him. But I can't remember if he was on the road or something again, but. Yeah, I think he's in Phoenix because there was some pictures postings with Brian Alderman and a couple. Oh, that's right. That's right. There's an event going on and banking was had. That's right. Well, thanks so much. And for again, for everybody watching the live stream so there will be the summary blog post of every question, every topic in the message center updates that Mike provided as well as every question that we covered and all the links that were, you probably didn't catch that we're in the chat throughout the video. We'll all be in that Buckleyplanet.com blog post and as well as a complete link list out on YouTube. So the live stream on YouTube so the recording is already out there. You can find it out there. Just do a search for collab talk. You should be able to find that. But thanks all for joining. We'll be back again at 8 a.m. Pacific next Monday to do it all again with a new set of questions. We've got these five that we're already queued up for for next week, mobile. But... Yeah, my response exactly, huh? Well, thanks so much everybody and we'll fade out with some music here but we'll see you all out in the on-premise world. Have a great week, everyone. Bye. Bye. Have a nice day. Have a nice day. Bye. Bye.