Skip to main content

Posts

Power Automate: Send Instant Emails From Canvas Apps

 In this blog, I want to dive into Power Automate.  When I first started with the Power Platform I dove deep into Power BI which then made way for Power Apps.  Soon thereafter I was introduced to Power Automate.  I sure wish someone had told me about Power Automate when I was a teacher of middle schoolers.  There were so many mundane daily and weekly tasks that I could have easily automated if I just would have been exposed to the program.   Power Automate is great for taking those routine or repetitive tasks and making them no longer a part of your daily routine. Sure setting up the Power Automate flow takes more time to get created, but once created you then can devote all that extra time you normally would have devoted to the task and now spend them on more mission-critical issues for your job.   In this video, I want to show you how you can send an automated email with just a click of a button.  Since I learned Power Automate after lea...
Recent posts

Power Platform Series: Episode 2 Global Variables In Canvas Apps

 In this blog, I am excited to release my 2nd episode in my new series covering the Power Platform.  If you have ever created Canvas Apps and have not used Global Variables, you will want to keep reading.  Global variables allow you as the app developer to design your application with fewer lines of code and in some cases avoid delegation warnings.   Global variables have many use case scenarios because you can call upon a global variable within any screen or control in your application.  For this video, I explore two use case scenarios for Global variables.  The first is to store custom colors that you want to re-use during your app design.  The second is able to retrieve information like email, display name, manager's information, etc. about the current user who is utilizing your application. Check out this video and see how easy it is to declare Global Variables in canvas applications. If you enjoy this video and are interested in formal traini...

Power Platform Series: Episode 1 Galleries In Canvas Apps

 It’s a New Year and time to get back to making more videos to help anyone who wants to learn about the various Microsoft products we here at Pragmatic Works train.  I’ve made over 40 different YouTube videos over the past two years, but for this year I wanted to create a structured series that will be dedicated to the Microsoft Power Platform.    Each month I plan on posting at least two videos that will cover various topics dedicated to Power Apps, Power BI, Power Automate, and Power Virtual Agents.  Some of the videos will be “one-off” videos while the majority will be continuations of discussion from the prior videos in the series.   I plan on giving you all the resources you will need to follow along.  Whether you start with me from episode 1 or you pick up with me on episode 11, I hope to give you great insights into how to use the programs and start implementing your business solutions.   In this first episode, I am starting wit...

Power BI: New Bookmark Functionality

 Bookmarks have been around for quite some time in Power BI, but with the new November update, you now have some extra functionality to make report creating easier. In this video, learn how to create bookmarks in Power BI using the newest bookmark update that came with the November 2021 edition of Power BI. With this new update, you now can insert a bookmark navigator on your report pages. This feature helps the cumbersome old process of adding separate buttons for each bookmark and attaching actions to them. You can use this new feature to update old reports or create new reports with bookmarks.   If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt20" at check out when purchasing our On-Demand Learning classes to get an extra 20% off - https://pragmaticworks.com/pricing/

Power BI: Must Know Tips For Column Removal, Searching, and Applied Steps

 When first starting with Power BI and diving into the Power Query editor you start to realize there are many ways to accomplish the same end goal.  For example, if you want to remove columns you can right-click on a column and remove it, hit the remove columns icon from the home ribbon, or even remove other columns.  The decision you make to remove the columns though has a consequence.  For example, if you use the remove column feature this makes it harder to modify this step in your applied steps.  If you chose the remove other columns feature or what I will showcase in my video below, the Choose Columns feature, then you can easily modify the applied step.  I believe the Choose columns step is the easiest of them all to utilize when removing columns.   Have you ever had a query with a copious amount of columns and you want to quickly go to a column without having to scroll through the whole query?  Well, I have the solution for you. In the ...

Power BI: Appending Data In Power Query Editor

 Do you need to bring data from multiple files into one table because the column structures, data types, etc. are similar?  Learn how to quickly do this in the video below.   In this video, I showcase how to bring in two different data sources that contain similar data and append/combine them into one table. This is useful to the user so you don’t have to go to the original data source and duplicate data to get what you need all in one table. Also, addressed is the scenario of what if I have different names for my columns or extra columns in one dataset compared to the other. I use some play educational data, but hopefully, you will see how to apply this to your business scenario. 👍   If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt20" at check out when purchasing our On-Demand Learning classes to get an extra 20% off - https://pragmaticworks.com/pricing/

Power BI: Group Values From Column For Visuals NO DAX Needed

Learn how to group and bin your field values for use in visualizations. This trick can help save space in your data model and never use a DAX function in order to make a calculated column that categorizes or groups your data using IF or SWITCH functions. This is great for new users to Power BI as well as save time for experienced users. In this video, I show how to group the sales territory countries into their corresponding continents. I also showcase how to group the ages of customers into different age ranges. 👍If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt20" at check out when purchasing our On-Demand Learning classes to get extra 20% off - https://pragmaticworks.com/pricing/