Posts

Recently, I was asked to automate our crisis alert workflow. When a crisis alert is initiated, each team member should be notified to join a Teams Meeting to discuss what to do. This is currently a manual process and relies on each person being near their PC when an issue occurs. A crisis alert can happen at any period of the day, and we can't rely on people to be near their PC. I was asked if there was any way I could automate the workflow and make it more efficient. Additionally, we needed to reach people away from their PC. I created a Flow in Power Automate to do the following: 1) The current process is triggered from a an email marked 'important' to a shared inbox. I used that as the trigger for my Flow. 2) Send a Teams message to each member of the 'Crisis Management Team' within Teams. I can use Azure AD to grab each team member of that team. 3)  Create a table within an Excel document that contains each team members name and mobile number. The Twilio, 'S
This is Part Three of three. In this post, I'll outline how to use Form and Flow (aka Power Automate) to send an email to someone with our vcard attached. If you haven't created your vcard and uploaded it to a SharePoint library yet, please go back and read Part One and Part Two in the links below. Part One - Create a VCard Part Two - Upload VCard to a SharePoint Library Create the Form I created a basic form using MS Forms to capture the person's first and last name, email address, and company name. This step is pretty self explanatory as each entry is a text field someone can enter data in and click the 'Submit' button. I made the first name, last name, and email address mandatory fields so I can use them in the flow. Here's what my completed form looks like: Create the Flow At a high level, here is what the Flow does: 1. Take the data from the completed form. 2. Get the submitter's details.  3. Send an email from the submitter attaching their vcard from t
  This is Part Two of three. In this post, I'll outline using PowerShell with the SharePoint PnP module to upload the VCards we created in Part One. Go back and read part one and get the VCard creation script on my GitHub account.  Pre-Reqs : 1) Run the 'Create_VCard ' script in Part One.  2) You'll need a SharePoint Document Library to store the VCards. The cards are saved in a '.vcf' file format from the VCard creation script. I'll walk through how to create SharePoint Document Library below. 3) You can get a copy of my Upload_Vcf_To_SharePoint script on my GitHub Account. You'll need to install the SharePoint PnP module . The module includes a handy cmdlet called 'Add-PnPFile' that does the heavy lifting of moving the .vcf files to the Document Library. Create a SharePoint Document Library This is pretty straightforward, but I had to look it up, so I thought I'd include the steps I used. First, open a SharePoint site. Go to 'Site Cont
  With everyone working from home, many introductions are being made virtually these days. Since we can't trade business cards in person, why not digitally? Outlook provides the ability to create a contact card (VCard) for each of your contacts, including one for yourself. This could be beneficial for Sales or HR employees that are still generating sales leads or hiring new employees. Many people don't know how to create their own, so this script creates one automatically for each person in a given AD OU. We can use AD properties for the name, phone, mobile, location, and other pertinent info. In addition, Graph API provides a picture that can be saved and converted to a base64 string for the VCard.  Kinda neat, right? Check out my GitHub for a link to the script. I've already written another script that will connect to SharePoint and upload each VCard to a library. From there, I've created a form attached to a flow in Power Automate. Once the form is submitted, the fl