Latest / Microsoft Cloud IT Pro Podcast / Episode 418 – An Anti-AI Adventure with Cat Schneider: SharePoint, Power Automate, and Conference Shenanigans
Transcript
- 0:03Welcome to episode 418
- 0:05of the Microsoft Cloud IT Pro podcast,
- 0:08our first episode of 2026,
- 0:11recorded live from Workplace Ninjas US in December
- 0:152025.
- 0:16This is a show about Microsoft three sixty
- 0:18five and Azure from the perspective of IT
- 0:20pros and end users, where we discuss a
- 0:23topic or recent news and how it relates
- 0:25to you.
- 0:26In today's episode, Kat Schneider and I just
- 0:29sit down with a goal of having an
- 0:31anti AI chat with no real idea where
- 0:34this adventure might take us. In the end,
- 0:36we enjoyed a conversation about some of the
- 0:38solutions Kat has built using the Power Platform
- 0:41and SharePoint.
- 0:42We talk a bit about OneDrive sync and
- 0:44libraries in SharePoint, and just some of the
- 0:46fun times from the conference, which you should
- 0:49totally join us for in February 2027 in
- 0:52Arizona.
- 0:53Hope you enjoy the anti episode chat with
- 0:56Cat.
- 0:58We are sitting here with Kat Schneider. I
- 1:01said it right. Right? You're listening right? Perfect.
- 1:03Yeah. Kat Schneider at Workplace Ninjas again. This
- 1:05is like my third fourth? I think it's
- 1:07Forty third? Fourth? No. Fourth episode
- 1:10Oh. I've recorded while I'm here. Wow. It's
- 1:12been busy. It Yeah. It's been hopping around
- 1:15here. It has been it's been a good
- 1:17conference. Yeah. I've I've enjoyed it. I've never
- 1:20gone to a security conference before.
- 1:23How do you feel about a bunch of
- 1:25security people at a conference?
- 1:27I feel like there's not enough talk of
- 1:29security yet. Is it has it reached a
- 1:31new level of nerd? It definitely
- 1:34has been an interesting
- 1:36experience for sure. It's definitely not a Power
- 1:38Platform conference. No. Definitely not a Power Platform.
- 1:41And it is not
- 1:42an AI conference.
- 1:44Definitely not. Which is what we're doing. We
- 1:46came up with this. We did a hackathon
- 1:48a day.
- 1:49Monday.
- 1:50Yep. Monday. Monday. Today's Wednesday. Is that when
- 1:53we were talking about recording this? And we
- 1:54said we're gonna do an anti AI episode.
- 1:57Yeah. We did.
- 1:59It was at the speakers dinner on the
- 2:00way to speakers dinner. Something like that. It
- 2:03was That was probably the problem of coming
- 2:05up with this. Yeah. And we said We're
- 2:07gonna do an anti AI episode. So we're
- 2:09sitting down to record an anti AI episode.
- 2:11We're like, what do we talk about?
- 2:14I didn't tell somebody how to be asked.
- 2:16So What is the opposite of AI? What
- 2:18is the opposite of AI? Or what was
- 2:20life
- 2:21This is like a time capsule episode. What
- 2:23was life like
- 2:25back when I was a kid before we
- 2:27had a high? Back in my day.
- 2:30I had to walk uphill both ways to
- 2:32school in the snow. In snow.
- 2:34Yeah. My god. All the way back to
- 2:36my dad's days. Jesus.
- 2:38Right? Well, it's funny because I've been talking
- 2:40to people here and I'm like, I got
- 2:41my start in like, Cheerpoint 2003,
- 2:442007. I was still in school.
- 2:47Yeah. We were in the car the other
- 2:49day and Jay said, he's like, Ben, we're
- 2:51the old men in the car.
- 2:54Awesome. Oh. I think I was the youngest
- 2:56one in the car.
- 2:57I was like, is it really come to
- 2:59that that I'm now the old man at
- 3:01these conferences? I used to be the one
- 3:03that I go to these conferences at like,
- 3:05when I was doing SharePoint 2007 and they're
- 3:07like, they're talking about before SharePoint 2001. I'm
- 3:10like, I was in kindergarten when you did
- 3:11that.
- 3:12I'm on the opposite side of that now.
- 3:14Yeah. Now
- 3:16you're the guy that everybody talks about. In
- 3:18a good way.
- 3:20What are they saying about me? Because my
- 3:22sessions have got little we may have gotten
- 3:24a little wild this week in our sessions.
- 3:26Did you have you heard about any of
- 3:28our sessions? I have not heard a peep
- 3:30about any of the sessions, but I also
- 3:31have been a little off the rails myself.
- 3:34It was we may have so there's a
- 3:36bunch of people with Tim Tams here. Yes.
- 3:38Okay. So about this conference, so many Tim
- 3:40Tams here. So many. And another thing about
- 3:43this conference that as I look back, I
- 3:45I didn't know how it was gonna go
- 3:46going into it. I really like it. You
- 3:48have clippy bucks at this conference. So many
- 3:51clippy bucks. That we get as speakers and
- 3:53we can hand them out. And we get
- 3:54to make it rain. Yes. And we can
- 3:56use them to bribe attendees.
- 3:58Yes. 100%.
- 4:00Or incentivize them. Which I think one thing,
- 4:03it's definitely incentivized conversations. People here have talked
- 4:07way more freely, asked way more questions, been
- 4:10way more
- 4:11participatory,
- 4:12is that a word? Participants are. Yes. Designed
- 4:15sessions.
- 4:16Because of these, we tried to get attendees
- 4:18last night in our session to go steal
- 4:20Tim Tam's from the session next to ours
- 4:23with Clippy Bucks. Oh my god. It didn't
- 4:25work. Damn. But it would have been really
- 4:27funny Yeah. To see them, like, run out
- 4:29and try to run back in with Tim
- 4:30Tam's and hear the session next to ours.
- 4:32That would be fantastic.
- 4:33Yeah. Anyways, that's the type of sessions we've
- 4:35had this week. Yeah. No. I definitely have
- 4:37talked a lot about AI in sessions this
- 4:39week, which is why I was anti AI.
- 4:41Okay. But So what did we do? Anti
- 4:43AI back when we were kids Oh, my
- 4:46gosh. And we were doing this, you were
- 4:48talking about
- 4:50We don't know what we're gonna talk. We
- 4:51tried to come up with ideas. Flows, SharePoint,
- 4:54like, before AI. Yeah. We can't talk about
- 4:57AI, so we can't compare and contrast.
- 4:59Yeah. But I think some of these solutions,
- 5:02like you were talking about some of the
- 5:03flows you built Mhmm. Because it was flow
- 5:06back then. Yeah. It was We started talking
- 5:08about flow, and we both knew what we
- 5:09were talking about. Yeah. Even though it's power
- 5:10automate. And you were like, oh, wait. No.
- 5:11It's power automate. Definitely power automate. Definitely did
- 5:13not mix that one up.
- 5:15It I was like, we should just sit
- 5:16and talk about, like, some of what we
- 5:18did Yeah. Before AI because I think there's
- 5:22so many conversations about AI now that sometimes
- 5:25you we forget about Mhmm. Let's go do
- 5:28something that's not AI Yeah. That's anti AI.
- 5:31Because it's so refreshing to be, like, back
- 5:33to basics. Yeah. And one of them you
- 5:35were talking about that I'm, like, I never
- 5:37thought about this was SharePoint permissions with flows
- 5:40Yes. Was something you did. Yes. So tell
- 5:43us about SharePoint permissions and flows and the
- 5:45solution. Okay.
- 5:47Okay. What we were trying to do is
- 5:48we were trying to manage our SharePoint permissions.
- 5:51We were trying to
- 5:53identify
- 5:54who was in what cost center doing what
- 5:57job and how they were all involved and
- 6:04have
- 6:05a nice landing page for
- 6:07a call center so people knew, like, oh,
- 6:09okay. This is who I go to and
- 6:10this is where I can ask questions and
- 6:12whatnot. Okay. And so I was like, well,
- 6:16if we're gonna do that and we're gonna
- 6:19have this information already in SharePoint because it's
- 6:22associated with people pickers Yep. Like, why not
- 6:25just put it in a list
- 6:27that somebody can manage?
- 6:29They literally, the cost center manager will be
- 6:31like, oh, hey, I got a new manager.
- 6:32I'm gonna go put my new manager's name
- 6:34over here so people know that, hey, this
- 6:36is my new manager. Okay. Like, the managers
- 6:39can manage the people that work for them
- 6:41and below.
- 6:42Kinda makes sense. Right? Isn't that what they're
- 6:44supposed to do? It's so
- 6:45crazy idea. It was Mind blowing.
- 6:48Breaking technology.
- 6:51I'm like, why don't we just, I don't
- 6:54know, do what we're supposed to be doing
- 6:56and manage the permissions this way? And so
- 6:58I ended up building a list Yeah. Right.
- 7:01That incorporate,
- 7:02like, that that thing back in the day,
- 7:05the code called JSON.
- 7:07Yes. Yeah. Where you could, like,
- 7:10show the list in very specific format and,
- 7:13you know, there was tools that you could
- 7:15have in browser so that you could format
- 7:18your the SP formatter tool. Yep. Fantastic tool.
- 7:21I love that tool. And that's even newer
- 7:23than I mentioned SharePoint Designer and you laughed
- 7:25at me.
- 7:26Oh, I've used SharePoint Designer and I was
- 7:28like, oh, I hated that thing so much.
- 7:30Hated it. Okay.
- 7:32Anyways, back to Visual Studio Code and JSON.
- 7:34Yes. Well, no, because I'm still in the
- 7:36browser. I haven't even made it to Visual
- 7:37Studio Code yet. Oh, yes. That's right. Yeah.
- 7:39No. So JSON,
- 7:41we're managing that list in JSON. So I
- 7:43could have, like, their picture from their profile,
- 7:45like, show up nice and big. Doing the
- 7:46whole list formatting. Yeah. I was I was
- 7:48doing all kinds of fancy things. And then
- 7:50I was also incorporating the list on the
- 7:52front page, like, the home page. Okay. And
- 7:55so
- 7:56you could click on the person's
- 7:59or their picture
- 8:00or click on the little email icon that
- 8:02I incorporated with it, and then you could
- 8:04send them an email or you could open
- 8:05up a Teams chat and, like, you could
- 8:07do all these crazy things. And then when
- 8:09somebody moved in or out
- 8:11of a position, like, say, somebody moved on
- 8:15to another
- 8:16spot within the agency and I wasn't managing
- 8:18their SharePoint collection and they had to do
- 8:19their own thing Uh-huh. They just got moved
- 8:21out and they lost all their permissions to
- 8:23access anything in Teams or any of the
- 8:26SharePoint that it was being managed by. Like,
- 8:28I was managing lots of permissions, like, even
- 8:31for Teams
- 8:32groups and whatnot from the SharePoint list. From
- 8:35the SharePoint. So was that, like, one central
- 8:38SharePoint list that everybody was in there? Did
- 8:40you have separate SharePoint list for each
- 8:42call center? Or For each call center, I
- 8:46had their own site collection because I didn't
- 8:48want finance and accounting to be able to
- 8:51manage To change permissions for another department. For
- 8:54them to be changing permissions for HR and
- 8:57Yeah. Yeah. That's what I'm saying. It was
- 8:59all over the place. So I was like,
- 9:00you get a site collection and you get
- 9:02a site collection. I was just Oprah. Oh,
- 9:03yeah. Just handing out site collections left and
- 9:05right. Yeah. Even though the SharePoint team was
- 9:07like about governance of SharePoint sites. Yeah. So
- 9:11I ended
- 9:12up being really close friends with our SharePoint
- 9:15governance Why? Folks. And I was like, I
- 9:17need another site collection. I'm like, oh, would
- 9:19you please just use the form?
- 9:22And I'm like, I will, but just know
- 9:24it's coming and this is what I want
- 9:25it to be named and don't go naming
- 9:27it anything crazy.
- 9:28So, like, there was all of that. And
- 9:30then I would be the site collection administrator
- 9:33and go in there and do all of
- 9:34that fun stuff. Okay. But, yeah. The I
- 9:37would go in there. I would set it
- 9:38up for them. I would set up their
- 9:39teams
- 9:40and get this one single SharePoint list. And
- 9:43then every time it got updated,
- 9:45it would kick off a Power Automate instant
- 9:47flow. Okay. Like a, automated flow. That's a
- 9:50mouthful. A Power Automate instant flow. Yeah. And
- 9:53it would say, oh, hey. This list item
- 9:56changed.
- 9:57What was the change?
- 9:59And I actually got it to the point
- 10:01I was able to go back into the
- 10:03previous version
- 10:05of that list item to see what was
- 10:08the value of that people picker before Uh-huh.
- 10:10And what is the value of the people
- 10:12picker now
- 10:13and be able to revoke permissions and grant
- 10:15permissions based on
- 10:17which it was. So So you're just adding
- 10:19and removing people then from the SharePoint
- 10:21permission group SharePoint groups. Yeah. Yeah. Like, I
- 10:24would have individual
- 10:25specific permissions, and then I would make it
- 10:28so that, like, that specific list, I didn't
- 10:31use groups per se, but everywhere else,
- 10:34there were groups. There were groups. Yeah. And
- 10:36then managers could essentially manage their own users'
- 10:38permission. Were they owners of their own SharePoint
- 10:40sites, or did this let you manage their
- 10:42permissions without them being owners of the sites?
- 10:44So
- 10:45I would not allow them to be full
- 10:47owners.
- 10:48Okay. Because if you let them be full
- 10:50owners, then they'll go in and delete something,
- 10:53and you're like, what are you doing?
- 10:55Because while version history was a thing, you
- 10:57can still delete something and then not be
- 10:59able to recover it. And then I wanted
- 11:01to murder people. But, you know Yeah. Working
- 11:03for the state, murder's frowned upon.
- 11:07I'm I'm I'm glad you refrained
- 11:11that we get to sit here and have
- 11:12this conversation
- 11:13here versus in jail somewhere?
- 11:17She was having this conversation with barks between
- 11:20us. Why would I why are you incarcerated?
- 11:23Jail so I can interview Kat about her
- 11:25SharePoint work and Why were you incarcerated? Because
- 11:27I murdered somebody for their SharePoint permissions?
- 11:31Oh, that would be fantastic.
- 11:33My. That's like a whole other side quest
- 11:36that I feel like
- 11:37needs to be unlocked somewhere.
- 11:40Oh, god.
- 11:41This is going even more off the rails
- 11:43than my sessions this week. Too much caffeine,
- 11:46too little sleep. And way too many shenanigans.
- 11:50Too many shenanigans. Actually, it was the ninjas.
- 11:52I blame it on the ninjas. The ninjas?
- 11:54I got a selfie with the ninjas. Oh,
- 11:56did you? I did. Oh, you did? I
- 11:58did that. I was in the speaker room
- 11:59and they were like, oh, can we take
- 12:00a picture? Because there was a workplace Ninjas
- 12:03sign on the door. Yeah. They went on
- 12:04a picture with them behind the glass with
- 12:06a sign in front. So I'm like sitting
- 12:08here working away and they're off behind me
- 12:09and doing their photo op.
- 12:12And I'm like, Can I get a picture?
- 12:15A 100%, that was definitely required.
- 12:17Yes. And accidentally going out at night, that
- 12:20was something else that came up this week.
- 12:21Yeah. But we couldn't accidentally go out at
- 12:22night. But
- 12:24I I started to see how it happened
- 12:25because we came back from, we went out
- 12:28to watch the Dallas Stars game last night.
- 12:30We came back and Jay and I were
- 12:31both like, oh, we're tired we need to
- 12:33go to bed, we need to get work
- 12:34done. And
- 12:35we walked out of the lobby. And we
- 12:37accidentally sat down in the lobby with a
- 12:39bunch of other people and got up an
- 12:41hour later.
- 12:43Yeah. I heard there were a lot of
- 12:44sushi boats involved last night. I saw a
- 12:47picture. I do not eat sushi, so I
- 12:49don't have the appreciation for it. But the
- 12:51pictures, it was a lot of sushi. I
- 12:53So I didn't see all of these pictures
- 12:55that apparently are going around, but I got
- 12:57one picture of one boat. One boat with
- 13:0092 pieces of sushi in one boat? Yes.
- 13:02And there were I heard there were at
- 13:04least three boats. I heard somebody ate one
- 13:06boat all on their own. I wonder if
- 13:08they're here today or They are? Are they
- 13:10doing okay?
- 13:12They seem to be standing on their own
- 13:14two feet, but just fine. Alright.
- 13:17That was a lot of sushi. That's a
- 13:18lot of sushi.
- 13:20Wow. And our friend who may have accidentally
- 13:24gone out. Did he? He accidentally went out
- 13:26with them. Accidentally go out with them? I
- 13:28have I have not seen him yet today.
- 13:30Oh, there is a reason why. Okay.
- 13:34But he is a good boy. Same as
- 13:36said friend
- 13:38also was really mad yesterday that his session
- 13:40was at 9AM in the morning. He's like,
- 13:41nobody ever schedules me for sessions before 2PM
- 13:44because
- 13:45said friend apparently has a habit of accidentally
- 13:48going out.
- 13:49So many times. Accidentally going out. I love
- 13:52him to death though. Okay. He's fantastic.
- 13:54Yes. It is
- 13:56he has
- 13:57made for many adventures this weekend. Our Uber
- 14:00driver he had our Uber drive I'm glad
- 14:02our Uber driver could drive safely with how
- 14:04hard our Uber driver was laughing
- 14:06when we
- 14:08were hearing about shenanigans
- 14:10on the car. And as I was arguing
- 14:12with him to tell the story correctly.
- 14:14So many shenanigans. Okay. Anyway, SharePoint. For real.
- 14:17SharePoint.
- 14:22Do you feel overwhelmed by trying to manage
- 14:24your Office three sixty five environment? Are you
- 14:27facing unexpected issues that disrupt your company's productivity?
- 14:30Intelligink is here to help. Much like you
- 14:32take your car to the mechanic that has
- 14:34specialized knowledge on how to best keep your
- 14:36car running, Intelligent helps you with your Microsoft
- 14:39cloud environment because that's their expertise.
- 14:42Intelligent keeps up with the latest updates in
- 14:44the Microsoft cloud to help keep your business
- 14:46running smoothly and ahead of the curve. Whether
- 14:49you are a small organization with just a
- 14:51few users up to an organization of several
- 14:53thousand employees,
- 14:55they want to partner with you to implement
- 14:57and administer your Microsoft cloud technology.
- 15:00Visit them at inteliginc.com/podcast.
- 15:04That's intelligink.com/podcast
- 15:11for more information or to schedule a thirty
- 15:13minute call to get started with them today.
- 15:15Remember, Intelligink focuses on the Microsoft cloud so
- 15:19you can focus on your business.
- 15:23So that was flows in SharePoint. Another one
- 15:25we talked about, this is interesting. We're gonna
- 15:27go to another it's a pre AI topic
- 15:31that keeps coming up over and over again.
- 15:34Mhmm. I've had this conversation
- 15:36at least twice this week at a security
- 15:38conference Mhmm. And you and I were talking
- 15:41about it. You've had experience with this SharePoint
- 15:43and file shares Mhmm. And syncing Mhmm. And
- 15:47migrations
- 15:48and MSPs
- 15:50that are trying
- 15:51to Yes. Do file syncs for their clients
- 15:54and treat it like it's still a file
- 15:56share. Yes. And we've talked about this. I
- 15:58know we've had at least one. We've probably
- 16:00had two or three episodes already on the
- 16:01podcast about it, but we've been going for
- 16:03nine years and people still don't seem to
- 16:05get the message. So we're gonna talk about
- 16:07this again. Alright. I'm gonna get I'm gonna
- 16:09beat this horse and hopefully it doesn't end
- 16:11me up in jail.
- 16:13It'll probably end up in a co pilot.
- 16:15No. Anti AI. No AI. No co pilot.
- 16:18No co pilot. Okay. SharePoint lists. Yep. What
- 16:21has your experience been guidance from you. Scott
- 16:24and I have beat this horse. It's time
- 16:26for somebody else to beat the horse. Alright.
- 16:28SharePoint lists are just Library. Libraries. SharePoint libraries.
- 16:32Files. Syncing. Because, I mean, SharePoint is really
- 16:35just SharePoint's third listception.
- 16:37Okay. True. So we could phrase those lists,
- 16:39but technically, you can't sync a list. Well,
- 16:41you can't sync a list that's not a
- 16:43library. You can't sync a list
- 16:45to a library, but you can sync a
- 16:47list to an Excel. Oh. We could talk
- 16:50about that too. Mhmm. Have you done much
- 16:52with syncing list to Excel? Uh-huh. Does it
- 16:54still work? I don't know if it still
- 16:56works, but it definitely did work when I
- 16:58was doing it. Okay. Talk to me about
- 16:59your SharePoint syncing list to Excel.
- 17:03So it's one of these things where what
- 17:05is it? You you still have to so
- 17:07it's in the trust center where, like, you
- 17:10can turn on and off, like, macros,
- 17:12but it's not a macro per se.
- 17:15No. It's like whether hey, this is connected.
- 17:18Do you really wanna do this? Yep. It's
- 17:20an o date. Was it o date of
- 17:22queries? I think it was o date of
- 17:24queries. Yes. You're like But you could turn
- 17:25it on and off. Yeah. And then even
- 17:27if that didn't work, you could still use
- 17:30Power Query within Excel
- 17:32to access the list and generate the data
- 17:35in Excel, which is why I had so
- 17:37many issues with people like, no, I can't
- 17:39use like, all of my Excel data lives
- 17:41in it's I can't put it on SharePoint
- 17:44because then it doesn't sync. And then it
- 17:46I get so many problems with trying to
- 17:48access this because it says it wants to
- 17:50get into a local file share and I
- 17:52can't access and it's like, well, if you
- 17:54put it in SharePoint Mhmm. You can either
- 17:57put it in a list, like export it
- 17:59from Excel into a list Yep. Or put
- 18:02the file in a document library, and you
- 18:04can sync it from there and make sure
- 18:07you change every single location that you're pointing
- 18:09it to every other workbook that you're pointing
- 18:11to. And that is no longer listed in
- 18:13a file share because now it's all in
- 18:15SharePoint. And
- 18:17I
- 18:18I had one client, bless his heart,
- 18:2062 Excel files
- 18:22that he would create
- 18:24every single year in order to manage all
- 18:27of the financials
- 18:28for his organization. Were they all linked together
- 18:30too? Every
- 18:32single
- 18:33one of them with macros,
- 18:35all point like, trying to open up one
- 18:38Excel,
- 18:40that took some patience.
- 18:43Because it's like, it would go to load,
- 18:45and then it was, like, waiting to connect
- 18:47to SharePoint.
- 18:48And then it was just spinning and spinning,
- 18:50and it's like, well, how's the kids? How
- 18:53are things going?
- 18:54Eventually, it would load. It opened. So did
- 18:56you help him get that into a SharePoint
- 18:58list? No. I ended up not getting the
- 19:00project because when we quoted them for how
- 19:03I was like, it's really not gonna cost
- 19:05that much for us to do it. But
- 19:08you're trying to make me put a number
- 19:10on it. And
- 19:11they almost croaked at the number Okay. Because
- 19:15they wanted everything moved for the last twenty
- 19:18years.
- 19:19Oh. Yeah. And And I was like, yo,
- 19:21that's not gonna be so whoever they end
- 19:23did end up going with, I was like,
- 19:25you undersold it, first of all.
- 19:29You did not think this went all the
- 19:31way through. Or there were lots of change
- 19:33orders. There had to have been. Happened before
- 19:36too. It had to have been. But, like,
- 19:38the guy so they call me a wizard.
- 19:41I don't call myself a wizard. I just
- 19:43ran with it. Okay. Like, they they told
- 19:46me, you're gonna get into tech. You're gonna
- 19:48need a name. And I was like, I
- 19:49don't know. Like, I don't know. Everybody just
- 19:51calls me a wizard. That's Whatever. You're a
- 19:53wizard cat. That's my name. But this guy
- 19:56was the CFO
- 19:58for his organization. He's Okay. The only one
- 20:00who touched this Excel document because he had
- 20:03to change it every year. He was very
- 20:05particular about this, like, to the point that
- 20:08the person who was supposed to be coming
- 20:10in after him when he retired
- 20:12Uh-huh. He wouldn't even share the password to
- 20:15get into the macros
- 20:16with her made her leave the room so
- 20:18that he could tell me by writing it
- 20:19on a piece of paper and showing me
- 20:21the camera showing it to the camera so
- 20:23that I could get into it and I
- 20:25could see what the macros were doing. I
- 20:27mean, at least he was security conscious and
- 20:29he wasn't. Trying to be Yeah. Very much.
- 20:32But I sat on a call I sat
- 20:34on two different calls with him for a
- 20:35grand total about six hours Okay. Where he
- 20:38explained
- 20:39the entire process The process of, oh, wow.
- 20:42Of this is what we have to do
- 20:44every year at the beginning of the year.
- 20:45This is what happens. This is where all
- 20:47the changes are made. Every quarter, we have
- 20:49to do this. We have to create this
- 20:51whole financial book. This all has to get
- 20:53printed out in very specific ways so that
- 20:54it can be then given to the CEO,
- 20:56and then all these decisions can be and
- 20:58it was six, six and a half hours
- 21:01straight,
- 21:02beginning to end.
- 21:04At one point in time, I was like,
- 21:05thank God we are able to record this,
- 21:08and I can get, like, transcripts,
- 21:10because there's no way I would have been
- 21:12able to do this. But after the first,
- 21:14like, two hour session that I had with
- 21:16him, of him just, like, explaining everything, and
- 21:18we went to go meet for the second
- 21:20session, and I was like, this is what
- 21:21I understood from the first session. He was
- 21:23like, yes.
- 21:25I'm supposed to retire in six months. Absolutely.
- 21:28I believe 100%
- 21:29without a doubt, if anything was to happen,
- 21:32that you guys could do it because you
- 21:33have the person there who understands it. And
- 21:34I was like, Excel is my jam, man.
- 21:37Like, I could fix this for you. Like,
- 21:40I re that was my biggest problem
- 21:42working at an MSP Okay. Was seeing people
- 21:46struggling with their Excels and being like, I
- 21:48could fix this for you right now. Like,
- 21:51I could make your life so much easier
- 21:53for you right now, and it would take
- 21:55me less than ten minutes. Like, can we
- 21:57please please stop hurting yourself? Yeah. Can I
- 22:00give you years back on your life?
- 22:03So yeah. No.
- 22:05I enjoy that work. But So what else
- 22:06did you do with SharePoint lists and Excel?
- 22:08Did you I did everything with them. I
- 22:10tried to get everybody off of using Excel.
- 22:12Okay. If you could use SharePoint and lists
- 22:15and you didn't want everybody to have access
- 22:17to every single list item Uh-huh.
- 22:20Like, I don't I can only share this
- 22:21much of this Excel with you, or I'm
- 22:23gonna have to split it up into six
- 22:24different Excels so they can share the information
- 22:26that's relevant from this one with that person,
- 22:27and this one with that person. Like, I
- 22:29was like, why why do that? Put it
- 22:30in a list. Yeah. You can provide individual
- 22:33permissions, and you can say, oh, hey. This
- 22:34is supposed to be for financial, and this
- 22:36is supposed to be for HR.
- 22:38Excuse me. That was a burp. You can
- 22:39check that out.
- 22:41I had a lot of Coke today. And
- 22:43cola.
- 22:43Coca cola.
- 22:45Pop. Yes. I'm from Michigan. It's pop.
- 22:48I'm from Florida. It's Coca Cola. It's
- 22:52No. I would try to get them off
- 22:53of it because I'm like, it's so much
- 22:55easier to manage your permissions
- 22:57using Flow. As long as you set the
- 22:59logic, it's not that difficult. Yep. And I
- 23:02was like, if it's gonna be, oh, I
- 23:04only need these three people to have access
- 23:06to it, you can either put a group
- 23:08together and put those three people in it
- 23:09and assign that group.
- 23:11Or if it's just, hey, this one time,
- 23:14I just need these people to have access
- 23:15to it, put them in a people picker
- 23:17field, give them the permission, and when they're
- 23:18not in the people picker field, take it
- 23:20away. Take it away and remove their permissions.
- 23:22Yeah. Like, I was using Flow to manage
- 23:24permissions all the time. Flow. Power automate.
- 23:28But it was Flow when you did it?
- 23:30I think it Probably? It was, like, right
- 23:32around the time between Flow and Power Automate
- 23:34name change. Okay.
- 23:36So it was I was, like, I don't
- 23:38understand why they called it Power Automate, but
- 23:40okay. And then it was like, oh, there's
- 23:41a Power Platform and everything's gonna be Power.
- 23:43And we've got Power Automate and Power Apps
- 23:44and Power BI. And then they're gonna take
- 23:46Power BI off the Chrome. Marketing had to
- 23:48justify their Yeah. Marketing needs to their existence.
- 23:51Every six months.
- 23:53Oh. So So the other one with an
- 23:55MSP.
- 23:56Yeah. Going back to syncing, OneDrive syncing. Mhmm.
- 23:59File syncing. Yep. Like, this is one that
- 24:02I
- 24:03Again, pre AI it's a problem. Post AI
- 24:06it's a problem.
- 24:07AI does nothing to help with this. Nope,
- 24:09absolutely not. And it just continues to be
- 24:11a problem is,
- 24:13I'm guessing with an MSP, you saw it
- 24:14as well, you go in and people are
- 24:16like, we need to migrate file shares to
- 24:18SharePoint because we're done with file shares. And
- 24:19they like take their entire file share and
- 24:22say And dump it in home. It's going
- 24:24in this SharePoint site and then everybody can
- 24:26sync it and life will be dandy because
- 24:28we don't have a file share and it's
- 24:29all in SharePoint. And then they wanted to
- 24:31immediately
- 24:32sync back to it so that everybody could
- 24:34access it? Yeah. They're like, why is this
- 24:35taking eight hours to sync back? Or why
- 24:37isn't everything staying updated? That's like, well, you
- 24:39understand there's a fundamental difference here between SharePoint
- 24:42and between file shares. Like, file shares, you're
- 24:45actually accessing it on the file share. SharePoint,
- 24:47you're doing it locally and syncing it. And
- 24:49if you try to sync 590,000
- 24:53files,
- 24:54one, I'm surprised it would even work. And
- 24:56if it does, it will take hours to
- 24:59keep everything up to date. I might have
- 25:01had a client. I might have had a
- 25:02client who had
- 25:0574
- 25:06layers of files
- 25:08or seventy seventy four Folders? Folders. They didn't
- 25:11hit the, like,
- 25:12name blank. No. A whole whole whole whole
- 25:14whole whole whole whole whole whole whole, please.
- 25:17Okay. I'll be patient. 74
- 25:20levels of folders
- 25:22in their document library.
- 25:24Okay.
- 25:24And there were over 672,000
- 25:29files
- 25:30that were in here. And every time they
- 25:33would go to move a file in there,
- 25:36it would take forever for it to go
- 25:38or it would stop. Uh-huh. And then they
- 25:39were trying to automate this using Power Automate
- 25:42and not understanding why the flow would break.
- 25:45Oh my. And I was like, first of
- 25:48all, oh my god.
- 25:50Second of all,
- 25:51oh my god.
- 25:53Third of all, that's never going to work
- 25:55in a million years.
- 25:56Like, there's a limit on how deep you
- 25:59can go because there's a limit on the
- 26:01number of characters that are allowed. And 74
- 26:04of those characters are already used by forward
- 26:07slashes.
- 26:09Wow. Which is also where I found out,
- 26:11don't use spaces.
- 26:13Dear God, do not put spaces Don't use
- 26:14in your folders. No. It's I feel like
- 26:16it they've done something. It's gotten a little
- 26:19bit better.
- 26:20Maybe? Maybe.
- 26:22I still don't like folders or spaces and
- 26:24folders. What was I gonna say about that?
- 26:25There was something else. Moving files
- 26:29I don't know. It's gone.
- 26:30I had something I was thinking of that
- 26:32I was gonna relate that to. Yeah. I
- 26:34don't know. Yeah. No. That was a fun
- 26:35project. I was like, you you guys do
- 26:37know that you don't need folders
- 26:40in order to store your files.
- 26:42Right? Like, you can have actual,
- 26:45like, views Like, yeah. Set up. And then
- 26:48we can set up filters
- 26:50because the first level was all of their
- 26:53clients, and then the next level
- 26:55was individual folders that they needed for those
- 26:58clients. And then it was like, well, this
- 27:00is for quarter one, and this is for
- 27:01quarter two, and this is for quarter three.
- 27:03And then it was just Got it. It
- 27:04was years and years of data. And I
- 27:06was like, oh,
- 27:08this is gonna be fun. And then Microsoft
- 27:11came up with channels and teams that created
- 27:14folders,
- 27:14and I said,
- 27:16I give up.
- 27:17I can't keep telling people to stop creating
- 27:19folders because Microsoft says to stop creating folders.
- 27:22And then they create folders. When they create
- 27:24folders and channels, they're like, it's a losing
- 27:26battle. Go create folders to your hard content.
- 27:28Oh, I remember what I was gonna ask.
- 27:29Okay. So have you ever seen this when
- 27:31you start getting that many files and folders?
- 27:34And I feel like I've seen this a
- 27:35couple times where, like, two people will sync
- 27:37it. Mhmm. One person will go to move
- 27:39it. And because it takes so long to
- 27:42sync,
- 27:43the other person's
- 27:45computer back in there. Gets confused and, like,
- 27:47puts it back as people are moving it
- 27:49out, and you end up with Multiple No.
- 27:52Multiple copies because it takes so long to
- 27:56sync
- 27:57that the two OneDrive clients on the two
- 27:58different computers That's awful. Lose track
- 28:02of what's going on. That's so awful.
- 28:04Like, this user
- 28:06will put I think this is the other
- 28:08one I've seen. User a
- 28:10will like add files to the folder. Mhmm.
- 28:13User b takes takes like the whole folder
- 28:17And while user a is still waiting to
- 28:19synchronize,
- 28:20so then user a recreates the folder
- 28:23and puts the new files in it. So
- 28:25now you have not duplicate files, but you
- 28:27have duplicate folders
- 28:29In different places. In different files. Yeah. User
- 28:32b is like, I'm missing files that user
- 28:34a was supposed to add and user a
- 28:35is like, where'd all the files go that
- 28:37were supposed to be in this folder that
- 28:38I added these other ones to? Oh. And
- 28:41then it's turned into a massive confusion and
- 28:43it's one of those things where it's,
- 28:46again, beating this horse of
- 28:48SharePoint is not a file share.
- 28:51Please, I get you want your users to
- 28:53feel comfortable with SharePoint and OneDrive and syncing
- 28:55and all that, but don't try to make
- 28:57OneDrive a file share. Yeah. No. What I
- 29:00have found really helpful
- 29:02is Power BI use
- 29:04with SharePoint.
- 29:06Okay. Because I can point a URL,
- 29:09like, in Power Query and Power BI to
- 29:11a document, like, a document library URL. Okay.
- 29:14And then I can see all of my
- 29:16files
- 29:17in that library. Like, I can break it
- 29:18down. Oh, because it flattens them all out?
- 29:20It flattens the whole thing. And so then
- 29:22you can see, oh, hey. Well, here's this
- 29:24file in this folder, and here's the same
- 29:27file in this other folder. But if you
- 29:29look at the URL for where these files
- 29:31are at, you can see there's a big
- 29:33difference in the URL length and how this
- 29:36is all set. It's fantastic. I haven't tried
- 29:38that yet. Dude, I 100% guarantee it's, like,
- 29:41mind blowing. When you get in there, you're
- 29:42like,
- 29:43this is beautiful. It's blowing my end right
- 29:46now. I'm gonna have to go try this.
- 29:47You
- 29:48should There are so many things that I've
- 29:50done with Power BI and that you probably
- 29:53should not have ever done or be able
- 29:55to do. But, like, I use Power BI
- 29:57to unzip files from
- 29:59Okay. Yeah.
- 30:01Explain.
- 30:02Okay. So I actually
- 30:04started on this project for PowerApps and Canvas
- 30:07apps Okay. Where I wanted to know the
- 30:10in internal
- 30:12guts of what was in a Canvas app.
- 30:14But when you export it, it comes out
- 30:15as an MS app file. Yep. Dot MS
- 30:18app. Well, inside the dot MS app file,
- 30:20like any other Microsoft file that is created,
- 30:23is a bunch
- 30:24of XML files and JSON files and all
- 30:27of that. So, like, if you change the
- 30:30extension of the file to dot zip and
- 30:32unzip it, you can now see all of
- 30:34the internal guts and glory.
- 30:37And so there are
- 30:39different tools that are out there. I think
- 30:41I found it somebody had it on GitHub,
- 30:44I think, for how do you decompress
- 30:46a file using Power BI. Okay.
- 30:49And so I have gone in and I've
- 30:52fiddled with that myself. Okay. And I've made
- 30:54it so that I can point it to
- 30:55a document library
- 30:57in OneDrive.
- 30:58Okay. And I can unzip every single file
- 31:01that is in that document library and see
- 31:03the internal contents of this file, so that
- 31:05I can then verify what's in the file,
- 31:08where it should be, how it's supposed to
- 31:10be set, like Can you actually unzip it
- 31:12too and have it go back to SharePoint
- 31:14as an unzipped file? Well, no. Because Power
- 31:16Query doesn't actually physically Doesn't go right back.
- 31:19You can actually do the reporting or the
- 31:21Yeah. Look at it. Yeah. So like if
- 31:23there was a like an Excel file, say,
- 31:25that's got a whole bunch of financial data
- 31:27in it, and you have another Excel file
- 31:28and another SharePoint list somewhere
- 31:31or SharePoint document library with some other financial
- 31:33data in it, and you wanted to compare
- 31:34the two, you could pull it into Power
- 31:36Query, Power BI, and
- 31:37and validate. And compare. Yeah. And never actually
- 31:41physically touch the files. To say, I have
- 31:43never done this. I'm gonna have to go
- 31:44start playing with it. This might be part
- 31:46of the reason why they call me a
- 31:48wizard. No. Because I find all these little
- 31:50hacks that nobody thinks about. Did you know
- 31:53you could do that with have you ever
- 31:54done that to an office document too? Change
- 31:56the name to that zip? Yeah. It's fascinating.
- 31:59Office document, Excel document, PowerPoint documents,
- 32:01every single one of them, even Power BI
- 32:04files.
- 32:05Are just zip files? Every single one of
- 32:07them is zip file. Everything after
- 32:09Office 2007.
- 32:11Yes. The when they added the x to
- 32:13the document extension. Yeah. Yep. Even the template
- 32:16files and everything is great.
- 32:18Very cool. It's how I wanted to start
- 32:20building crap. I'm like, oh, I can just
- 32:22change it to to dot zip and unpack
- 32:24it, and then I can just put whatever
- 32:26I want in it and zip it back
- 32:27up and change the extension to whatever it
- 32:28is. Just randomly tried it now with every
- 32:30file you get is just change it to
- 32:32dot zip to see what happens. Yep. A
- 32:34100%. I've actually saved my bacon before because
- 32:37I was working on a Power BI report.
- 32:40Okay.
- 32:40I accidentally made a change in which it
- 32:43froze the whole thing up, and I forgot
- 32:44to save
- 32:46after working on this for twelve hours.
- 32:49Oh, no.
- 32:50Thank god I always turn on the auto
- 32:52save part. Yep.
- 32:54But then I tried to open up the
- 32:55backup file
- 32:57Okay.
- 32:57And it had saved it with the error
- 33:00in place so that it was frozen as
- 33:02soon as it opened.
- 33:03Oh. And I was like, oh, no. This
- 33:06is not good. Because the number of power
- 33:09query, like, changes that I had made Twelve
- 33:12hours worth. I was never going to remember
- 33:14exactly how I had done it. Yeah. And
- 33:16I was like, oh, wait. I can change
- 33:18this file to dot zip, and I can
- 33:20open it up and look at it in
- 33:22Versus Code, and I can get all of
- 33:23the Power Query
- 33:24Okay. Out of there and make sure that
- 33:26I change the one specific part that was
- 33:29freezing everything.
- 33:31No. You can't. Yes. You can. No Power
- 33:34Query. It's John. It's John. Very stupid. No.
- 33:36It is not. Blah blah blah. It is
- 33:38the Let's go do some KQL over at
- 33:40it. Christ. I talked about KQL earlier. I
- 33:43do? Yeah. You have to talk really loud,
- 33:45John, so you get picked up on the
- 33:46mic for the podcast. Oh, you're on a
- 33:48podcast? Yeah. Now you are too. Nice. We
- 33:50just got joined by John the mastermind
- 33:54behind
- 33:55the workplace ninjas conference. As you get all
- 33:57the feedback from my microphone. Hello. Just like
- 34:00I told him at the MVP summit, the
- 34:02only person that you have to learn KQL
- 34:03are people who do defender are, like, Nathan
- 34:05McNulty. Making everybody else learn it is cruel
- 34:07and evil.
- 34:08Now I'm gonna go away. You're gonna go
- 34:10away. Alright. Thanks, John. Can't wait for are
- 34:12we allowed to talk about next year? We
- 34:15are announcing Is it public?
- 34:16At 05:30PM,
- 34:18we are announcing the 2027
- 34:20date and venue.
- 34:21Okay. So this podcast will come out after
- 34:23that, so we will talk about it. You
- 34:25can announce the fact that it is going
- 34:26to be at the Scott And Scottsdale
- 34:29The Scott? Next week of February Okay. 2027.
- 34:31The Scott And Scottsdale,
- 34:33last week, 2027.
- 34:35You should absolutely come and accidentally
- 34:38go out. Go out at night.
- 34:41Enjoy all the shenanigans at which 100% shenanigans.
- 34:44This is I don't know as many people
- 34:46at this conference as when I go to
- 34:48some of the other ones. Mhmm. This is
- 34:50by far the most fun I have ever
- 34:52had
- 34:53at a conference.
- 34:54To be fair, I found out today that
- 34:56I'm royalty.
- 34:57I did not know this. You're not only
- 34:59a wizard, but you're royalty. I'm apparently royalty.
- 35:01I'm MVP royalty, and I did not know
- 35:03this. Like, some of Congratulations.
- 35:05Yeah. I so, Ramona g Oh, yeah. I
- 35:09know. Ramona's awesome. Yeah. So I went down
- 35:11to her session before and, like, I only
- 35:13met her through WhatsApp chat, like, a few
- 35:16weeks ago. Okay. Two months ago, something like
- 35:18that. And I walked into her session and
- 35:20there's, like, there's a handful of people or
- 35:22whatever because they put her out in the
- 35:24middle of nowhere land like they did to
- 35:26me yesterday. I'm sorry. And definitely did not
- 35:28complain to John about that several times with
- 35:31a number of expletives.
- 35:34And so That never would have imagined.
- 35:37I went walked into her session, and she
- 35:40got, like, got all super excited and whatnot.
- 35:42And then, like, at at the end of
- 35:43her session, like, my friend, he wanted me
- 35:45to come introduce,
- 35:47like, him to her. He's like, she's fantastic.
- 35:49And I was like Is this the same
- 35:50friend that accidentally goes out? This is a
- 35:53different friend? Okay.
- 35:54And so he's like, you need to come
- 35:56introduce me. And I was like, I'm pretty
- 35:58sure she knows me, but sure. I'll come
- 35:59down there and I'll make an introduction.
- 36:01And so at the end, he, like, he
- 36:04jumps up and he's like, hey, I'm gonna
- 36:06do and so I was like, okay. Okay.
- 36:08And she's like, yeah. This is royalty right
- 36:11here. And I was like, what?
- 36:13This is the fun part. We just get
- 36:15random people stopping that. Yeah. Yeah. John I
- 36:17thought you were just shooting the shit now
- 36:18because No. This is that's the fun part
- 36:20of the podcast. Here's this is random Yeah.
- 36:23Just into
- 36:24the Lindsay came to say hi. We have
- 36:25Lindsay. We have Lindsay Shelton here from Epic
- 36:29with a q.
- 36:30So and Lindsay is epic.
- 36:32She is epic. She works at Epic and
- 36:34is epic. Exactly.
- 36:36Except I know how
- 36:37to
- 36:38spell
- 36:39epic.
- 36:41Oh my. But I love my work, I
- 36:43love my employer. Alright. Yes. In case they'll
- 36:45send to this case later. We'll make sure
- 36:46that is noted
- 36:48and Yes. Acknowledged.
- 36:50Alright. But we should probably wrap
- 36:52up. I don't even know how long we've
- 36:53been recording for. Anything else that's anti AI
- 36:57that we wanted? We did well for anti
- 36:59AI. We did. A little I mean off
- 37:01the wall on everything. I did mention CoPilot
- 37:03once, but, you know, I feel like that
- 37:06you have to as an MVP for anything
- 37:08that you're speaking at least mention it one
- 37:09time. It's yeah. It's an obligation. I think
- 37:12we signed something that says It's actually obligated.
- 37:14Time we talk, we will mention Copilot at
- 37:16least once.
- 37:17So I think we have done our contractual
- 37:20obligation. Well, thanks, guys. This was a lot
- 37:22of fun. It was.
- 37:24I will put links in the show notes
- 37:26to anybody that wants to
- 37:27meet Kat, the royal
- 37:30wizard.
- 37:30The royal wizard.
- 37:34You need a new handle.
- 37:36Half the royal wizard.
- 37:38I've added a dinosaur to my LinkedIn name.
- 37:40Now, like, what more can you ask? Perfect.
- 37:44Alright. Well, thank you so much. This was
- 37:46a lot of fun. Yeah. And we will
- 37:48have to do it again sometime. Yes. For
- 37:50sure. Alright. Alright. Thanks, Kat. We'll talk to
- 37:52you later. K. Bye.
- 37:56If you enjoyed the podcast, go leave us
- 37:58a five star rating in iTunes. It helps
- 38:01to get the word out so more IT
- 38:02pros can learn about Office three sixty five
- 38:04and Azure.
- 38:06If you have any questions you want us
- 38:07to address on the show, or feedback about
- 38:09the show, feel free to reach out via
- 38:12our website, Twitter, or Facebook.
- 38:14Thanks again for listening, and have a great
- 38:16day.