Posts
I passed my PL-900 Exam one week ago. Similar to my last posts about passing the AZ900 exam and the MS700 exam , I wanted to share what I used to study in hopes that it will help others. I recommend going thorough the MS Learn Power Platform Fundaments path. It's free and there is some good information that prepares you for the exam: MS Learn Power Platform Fundamentals I purchased the practice exam packet on WhizLabs for $15.95 and I found the questions to be very helpful. WhizLabs PL-900 Lastly, I found several Power Platform MVP's YouTube channels to be very useful. They do cover everything from intros/basic skills all the way to building advanced apps, flows, etc. Lisa Crosbie Reza Dorrani Shane Young Prior to taking this exam, I had been using Power Automate for several years. I hadn't really done as much with Power BI, Power Virtual Agents, or Power Apps. Since this is a fundamentals exam, I used this exam to study up and learn more about the things I didn't ha...
My department had an initiative this year to clean up our on premise Exchange environment. Any mailbox that did not have a reason to stay on premise was migrated to Exchange Online. One mailbox in particular was utilized by our E-Fax service. When an incoming fax was sent to the mailbox, a PowerShell script copied the email attachment to a NAS share. The process is outlined below: I had a meeting with the mailbox owner prior to the migration. I could tell she was very uneasy with any sort of major change the current process. In addition, the NAS share had permissions for a large number of users. Therefore, I wanted to make as few changes to the process as possible. That's exactly why Power Automate with a Data Gateway connection works well for this use case. I can create a Flow that leaves the existing NAS share and all permissions in place. The new process is outlined in the diagram below: Pre-Requisite M365 Licensing is required to use the Data Gateway feature. This article exp...
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...
