Skip to main content

Making a SharePoint Knowledge Base Part Two: Knowledge is Power... Automate

Happy snow day folks! Well, at least for me. We saw up to 40+ centimeters last night which gave me plenty of time today to sit down and write the second part of this series which is adding templates and automation with Power Automate (in between all the shoveling and snow clearing of course). So this is where we get into some of the cool stuff that our knowledge base can do, as well as touch on some key points that may inspire you to go beyond even the knowledge base. However, if you're looking to finish off your knowledge base, here's the part that is for you!

Templates

Let's start with templates, as this is likely the most user-dependent part of the whole post. Before continuing, it's important to note that each template may differ, and it's really up to you and the stakeholders in your team or organization to determine the content to include. For the sake of demonstration, I'll keep this very barebones and focus on how to add a template to your knowledge base.

So, what are templates exactly? It's quite simple. When you create a new file in any document library, whether it's your knowledge base or any document library in general, you're presented with several formats such as Word, Excel, PowerPoint, etc. But what people often overlook is that you can also create templates. A template is a file you add to your document library and use as a stencil for creating files of the same format. For example, let's say we want to create a template for our knowledge base. We can create a new template and add the parameters we want users to complete, and then they have a template they can complete without starting from scratch each time. This can be especially helpful if people are constantly adding content and you want to control the formatting of that information.

To do so, all we need to do is the following:

1. In our knowledge base, click on "New" and then click on "Add template" as shown below:


2. You will then be given the option to upload the template that you wish. Assuming you have the file already created, go ahead and upload it. When it is all said and done, you should be able to click "New" again and be met with your new template:


And there you have it! You can now use this template to create knowledge base articles based on the format you desire. But wait, there's more! What if you want to restrict what people can create? For instance, if you want to prevent users from creating new PowerPoint presentations in your knowledge base, that can be done too! Here's how:

1. Click on "New" once again and then press on "Edit New menu":


2. De-select the formats you wish to get rid of then press "Save":

Now, when you go back to add a new file, you should only see the template, which you can then fill out and complete for your knowledge base. This allows you to add specified content repeatedly without users or team members straying too far from the approved formatting. Templates can be especially useful in environments where documentation must look the same or there are strict templating requirements.

With that out of the way, onto automation!

Automation

This may be the easiest part of the process as we can create rules to handle notifications for us. When people hear automation, they typically run the other way, but in this case, I want to show you that it's really easy to get started.


To begin, click on the ellipses in the toolbar, then press "Automate," then "Rules," and finally "Create a rule":

From here, you can select a rule to add to your knowledge base. In this case, I want to know when a user adds a new file to our knowledge base so I can review it. To do so, I will click "A new file is added" and proceed from there:


Now, we can specify how often and who will receive the email. In this case, I want to know always and have it sent to me:
You can set this to whatever you desire and enter whoever you wish. Once done, hit "Create," and that should be it. When someone adds a new file to the document library, you (or the specified person) will be notified. This is possible thanks to Power Automate, which you can also use to integrate more sophisticated flows into your document libraries. We'll delve into more Power Automate and Power Platform features in later articles. Until then, this concludes our segment on knowledge bases. I hope you enjoyed the content and look forward to seeing you in the next article!

test

Using Power Automate to Update Contact Information

 We've all been there- you have a large organization who has out-of-date contact information. What do you do? You could go around to each department and ask them nicely to update their information, or send out an org-wide email prompting people to do so. However, this is tedious and oftentimes a pointless task. By the time you update one department, you're running to fix another. What if you could put the power back in the department's hands to do so? This is a struggle I faced recently as I was trying to find was I could conjure up some updated contact information for each department. As I did my research, I found that I was not alone in this endeavour as it seems that many IT professionals would love to make this process a little bit less painful. With this in mind, I introduce to you my latest flow! This flow will allow you to encourage users to update their contact information, without the overhead that comes with manual effort. In addition to this, this flow utilizes t...

Using Custom Connectors and Microsoft Graph API's to Manage Licenses in Power Automate - Part Two

Hello again! Didn't I promise you that I'd be back to wrap this up? Well, here I am to give you the second tidbit of information that you need to get this started. If you haven't already, take a look at my previous post where I go into depth about creating a custom connector in Power Automate to retrieve the latest sign-in and also gather the user's licenses. Now that we have the custom connector ready, we can now get into the meat n' potatoes of this series. In this post, I will show you the flow that makes this possible and how you can use the custom connector you have created to tie it all together! Hope you enjoy. Understanding the Logic Before we can begin creating the flow, we should first understand how the flow will work. I designed this to flow to be triggered manually, but you may want to schedule it or use another trigger. The trigger will depend on your organization's policies, so please adjust accordingly. Once triggered, the flow will use the Entra...

Using Custom Connectors and Microsoft Graph API's to Manage Licenses in Power Automate - Part One

Happy June folks! I come to you with another post, but this time I wanted to change it up and show you something else I have just finished working on. As a SysAdmin, one of the most common issues we run into is managing licenses. Working at a post-secondary institution makes this an even greater challenge, as you have both students, staff and faculty constantly coming as well as going. Managing to keep up with this constant change can introduce great administrative overhead which takes away time from important upkeep of other systems and initiatives. You may also notice this same issue in large corporations or in other government organizations. To help combat this, I wanted to create a flow that can do the following: Get the user and their licenses Determine their last sign-in and the date Conditional to determine if the user is past the "cutoff" date Remove the user from a group where the license is assigned The only problem with doing this is that Power Automate does not ha...