Power Apps makers can design a dropdown that starts with a blank value by setting the AllowEmptySelection property to true. But after enabling AllowEmptySelection the confusing part is once a user clicks to view the dropdown list there is no…
Welcome to the Power Apps Functions List.On this page you will find a categorized list of 150+ Power Apps functions with links to the official documentation. Undocumented functions like RandBetween and Index are also included along with my own notes.…
I recently sat down with Darren Neese to discuss how I created a successful Power Apps blog. In the interview we chatted about tips for creating killer content, the secret to publishing consistently, and effective strategies for getting others to…
An awesome new way to concatenate text strings in Power Apps has arrived with $-Strings. Placing the $ symbol in front of any text string now defines it as an $-String. Then you can write any function, expression of variable…
Calculating the number of business days between two days is a common feature of many apps. In Power Apps can do this by generating a list of dates and filtering out the weekends and holidays. There is no NETWORKDAYS function…
Table Of Contents: • Description • Phone Number Input Mask Properties • Example - Single Phone Number Format • Example - Multiple Phone Number Formats • Limitations • Download The Component For FREE Description This Power Apps component is available…
Power Apps users want to see the proper formatting applied to a phone number as they type. As an app builder, I want to make sure phone numbers are stored consistently in my datasource. Input masks are an excellent way…
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…