Get SharePoint Column Descriptions into a PowerApps Form

Within a SharePoint list, it's common practice to add a description to your columns. Naturally, you would want to provide a description to aid users in filling out the form. The out of the box form experience in a SharePoint list will display descriptions automatically. However, if you're building a Canvas PowerApp using the Form control, you’ve probably noticed the descriptions are missing. Frustrating! The description fields are present in the default SharePoint list form. The same list connected to a PowerApps Form...no descriptions show. 😐 To address this limitation, I’ve seen some workarounds—like hardcoding the description directly…

Comments Off on Get SharePoint Column Descriptions into a PowerApps Form

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