Oh, hey everyone!

Hey folks! This blog has gone a little stagnant for a while. I’ve been busy, and have not been able to dedicate many of the working day hours to upkeep here.

But I hope to change that going forward. Within the past two years I have started up a YoueTube channel for some of my many hobbies (woodworking, metalworking, leatherworking, and just about ever other maker-thing you can think of, and some you have not) here at The New Janky Workshop. So, check that out (and subscribe!) if you’re into that sort of thing!

With that personal endeavour, I’ve also REALLY gotten into video editing and publishing (because yes, I need MOAR hobbies). So, I am going to try to semi-regularly post to my new channel, for things Microsoft, SharePointy, and other M365 topics (and also Azure, PowerShell, and other goodness). So, if you’re interested in that stuff (which, by the sake of you being on this post at all, likely means that you are). Please check it out: The SharePoint Yankee (and also subscribe there too!).

It’s brand new (so new, in fact, I just posted a quick short video today on it as my first one…). So, follow along, leave comments there or here on how you like the videos, what you’d like to see, and more, and I’ll get cracking on it.

Cheers!

Advertisement

Speaking at SharePoint Saturday San Juan

43049817_10156779677362164_6495283152024502272_o

I am pleased to announce I will be speaking at SharePoint Saturday San Juan on November 3rd.

Register today at http://www.spsevents.org/city/sanjuan/sanjuan2018

The Microsoft Office 365 and Cloud community invites you to the second 365 & SharePoint office on Saturday to be held in San Juan.

It is a totally free event in which you will find technical and development sessions focused on Microsoft Collaboration tools such as SharePoint, Office 365, Integration with Azure, Power Apps, Flow, Project, Planner, OneDrive, Delve, SharePoint Framework, Power BI, Dynamics CRM, Blockchain among others. We will have the company of MVPs and specialized technical leaders in each of the different types of talks.

I will be presenting Using Azure Runbooks and Microsoft Flow to Automate SharePoint Tasks

Session Abstract

Runbooks are a feature of Azure Automation that allow you to execute workflows from within Azure or remotely to automate processes. Microsoft Flow allows you to attach to certain activities in SharePoint and across other platforms, to perform a task when a certain condition is met. In this session, you will learn how to link SharePoint Online, Microsoft Flow, and Azure Runbooks in order to execute scripts automatically against your SharePoint tenant, or really, perform or automate any task.

Hope to see you there!

Speaking at SharePoint Saturday New England 2018

spsne1028

I am pleased to announce I will be speaking at SharePoint Saturday New England. Taking place on Saturday, October 20th, at the Microsoft office in Burlington, MA.

Register today at https://spsnewengland.org/

Carrying on the great tradition of SharePoint Saturday started by Michael Lotter, Susan Lennon, and Kevin Israel on January 10th, 2009 in Virginia Beach, we hope to welcome you to SharePoint Saturday New England.

Join New England area SharePoint architects, developers, and information workers for SharePoint Saturday: an educational, informative and lively day filled with sessions from other SharePoint professionals, MVPs, and Microsoft employees. SharePoint Saturday is FREE, open to the public and is your chance to immerse yourself in SharePoint right here in New England!

I will be presenting Using Azure Runbooks and Microsoft Flow to Automate SharePoint Tasks

Session Abstract

Runbooks are a feature of Azure Automation that allow you to execute workflows from within Azure or remotely to automate processes. Microsoft Flow allows you to attach to certain activities in SharePoint and across other platforms, to perform a task when a certain condition is met. In this session, you will learn how to link SharePoint Online, Microsoft Flow, and Azure Runbooks in order to execute scripts automatically against your SharePoint tenant, or really, perform or automate any task.

Hope to see you there!

Speaking at the Granite State SharePoint Users Group on Thursday, April 5

In case you missed my session last month at the Boston Area SharePoint Users Group, I will be delivering my session “Easily Integrating a Chat Bot into SharePoint” at the Granite State SharePoint Users Group next month, on Thursday, April 5th.

Session Abstract

​Chat Bots are very commonplace these days. They have been around for years, but advances in AI technology have allowed for a large growth and advances in this area. Microsoft has in preview a service called QnA Maker, that will allow you to create and build a Chat Bot that you can easily integrate into SharePoint using the Azure Bot Framework, all without writing a single line of code. Join me, and I’ll walk you through step-by-step on this process, along with discussing how and where Chat Bots can be used to provide better adoption and support to your users.

Click here for more information and to register! Hope to see you there!

Getting the Job ID of an Executing Azure Runbook

If you’re calling an Azure runbook, it is sometimes useful to be able to get the Job ID, say, to report back and update the source that initiated the call to a runbook. This is a quick post on how to access that ID in PowerShell.

You can access it via the following:

$PSPrivateMetadata.JobId.Guid

image

And the output:

image

Getting the Plain Text Value of an Azure Key Vault Secret with PowerShell

Related imageAzure’s Key Vault is a great way to store certificates, usernames, passwords, for use in your Azure applications, infrastructure operations, and more.

This is just a quick post to tell you how you can get at the value of a stored Secret in the Key Vault with PowerShell and the Azure module.

You can see, I have a Key Vault named gvkeyvault, and a secret named geoffv

image

Now, to get it, we can use the Get-AzureKeyVaultSecret cmdlet. By giving it our VaultName and our key Name, we can see the key. However, that does not get us the value of our Secret.

image

To do that, we need to get the SecretValueText property of the Key Vault Secret.

(Get-AzureKeyVaultSecret –VaultName “gvkeyvault” –Name “geoffv”).SecretValueText

image

You can see we get the value out of “12345”…

image

Now I need to go change the combination of my luggage.

Slides from February 13, 2018 BASPUG Meeting

Thank you all who came out last night to see my presentation at the Boston Area SharePoint Users Group last night!

As promised, here are my slides from the presentation, hosted on SlideShare:

And here is a link to the blog post which contains all of the steps we demoed during the presentation: https://sharepointyankee.com/2018/01/23/creating-a-chat-bot-with-microsofts-qna-maker-and-azure-bot-service/

%d bloggers like this: