In Power Automate Desktop there are two ways to read an Excel file. The traditional way is to use built-in Excel actions extract all of the spreadsheet’s data. A better way is to create a SQL connection to the Excel…
Power Automate Desktop is a free application from Microsoft you can download to automate personal or business-related tasks on any Windows computer. One of the most popular use cases for Power Automate Desktop is taking data from an Excel and…
Math and statistical functions are among the most used functions in Power Apps. Fortunately, they are also some of the easiest functions to learn. Doing math inside of Power Apps has a lot in common with Microsoft Excel. Many of…
Creating a custom theme for your Power Apps project is important. The colors, fonts, icons and styles you use for controls (text inputs, dropdowns, date-pickers, etc.) define the unique look-and-feel of an app. Power Apps does not have a feature…
I assumed making Power Apps that display a PDF stored in a SharePoint document library would be easy. Power Apps already has a built-in PDF viewer control. All I need to do is supply the file location and it will…
Power Apps created for use inside a company can be shared with external users outside of the organization as well. External users require the same licensing as internal users but there is a different method to set them up vs.…
Want to filter a Power Apps gallery by the current user? There are many ways to do it. The easiest way is to get the current user’s email and use a filter function to show only matching records in the…
When a Power Apps form is very long a tabbed form can make it more organized and easier to use. A tabbed form is simple to build – create one button for each tab at the top of the form, when…
Need to show or hide a button in Power Apps based on the current user? There are several ways to do it. The quickest way is to comparing the current user’s email to a hardcoded value to see if it matches. But the…
Author’s note: Two weeks ago I published a tutorial on how to setup Power Apps Co-Authoring with Github. Many readers of this blog use Azure Dev Ops for source control instead of Github and requested another version of the same…