PowerApps Essential PnP PowerShell for SharePoint Provisioning

When importing PowerApps SharePoint-based solutions into upper level environments (such as from development to test environment), it’s typically necessary to provision a dedicated site and the lists that each environment will use. Unlike Dataverse solutions where importing a solution automatically creates the tables in the target environment, SharePoint sites and list resources are not. This gap led me to ask: what's the most efficient, programmatic way to create these SharePoint resources? Well, since you’ve read the title, you probably know where this is going: PowerShell PnP to the rescue! I'm going to assume you already have the SharePoint…

Comments Off on PowerApps Essential PnP PowerShell for SharePoint Provisioning

Format Date and Time to 12-Hour AM/PM in PowerApps Forms

When you use a form control with date and time fields in PowerApps, it automatically generates a data card with a date picker, plus two dropdowns for hour and minute—in 24 hour time. Now, I don’t know about you, but here in the U.S., where we’re used to the 12-hour AM/PM format, it’s kind of surprising that Microsoft hasn’t made this behavior easier to configure! Therefore, I sought to build my own solution to this annoyance by achieving the following goals: Combine the Hour, Minute, and AM/PM format into one single dropdown control. Allow for interval-based time selection…

Comments Off on Format Date and Time to 12-Hour AM/PM in PowerApps Forms

Use an Alphabet Letter Selector Component in PowerApps

The Alphabet Selector Component If you're ever worked with a Dynamics/Model Driven App before, you know it has many different ways to filter data out-of-the-box. One of these features is the "jump bar". This component allows users to quickly "jump" to records based on the starting letter. For canvas apps however, there isn’t a built-in solution like this. The jump bar in a Model Driven App I built a reusable component that mimics the jump bar behavior while also allowing for responsive design in desktop and mobile form factors. Horizontal Mode Vertical Mode In the example above, I am filtering…

Comments Off on Use an Alphabet Letter Selector Component in PowerApps