3 Steps to Filter a PowerApps Gallery for the Current User’s Records

If you have recently generated a PowerApps app from data, you probably ended up with a 3 screen app. The first page of that app probably has a gallery. Basic default gallery By default, anyone using the app sees all records. This gallery can be customized to only show the records of the user that is currently signed into Office 365. Add a filter to restrict the gallery records In the Read More…

PowerApps Galleries Part 2

Use functions in a gallery In a previous post, a gallery was customized by adding a new label. The label displays the data from a field in the data source. Emphasis was added to the label by changing some of the label’s color properties. Unfortunately, there isn’t always data in the field for the label, as shown below. The label appears as empty rectangle. Use a function, to resolve Read More…

Convert Time Zones

Convert Time Zones in Power BI Reports in 5 Steps or Less

Importing data into Power BI from a data source, like SharePoint, can result in some odd behavior. Date and time values often appear in UTC time instead of the local time zone. Easily convert the time zone with a custom column: Make sure Date/Time/Zone is the data type for your current column. If it isn’t, use the transform tab to change the data type.In Edit Queries, click the Add ColumRead More…

When “Stuff” Doesn’t Open in OneNote Online

It isn’t made to. Microsoft Excel isn’t expected to open Microsoft Word files. Don’t expect OneNote to open anything but OneNote files. Although, OneNote Online is not designed to open other application files like Word, Excel, PowerPoint, audio and video files it is very common to see various files embedded in OneNote files. Typical OneNote prompt This is a pretty big limitation if you aRead More…

Go Dark with PowerApps

Go Dark with PowerApps

Give your PowerApps app a sleek and polished look by changing the background colors. Basic app with minimal customizations In the example below, the background colors have been changed to black giving the app a ‘dark mode’ feel. Basic app with black background The key to this look is the high contrast between the background and the white text and accents. Though other colors may beRead More…

Get more bang for your PowerApps Gallery

PowerApps Galleries Part 1

Get More Bang for the Gallery PowerApps has the ability to place app development in the hands of workers that are closest to the problems at hand. This is an exciting opportunity for any organization. Unfortunately, this opportunity does have a few limitations. Citizen apps tend to lack functionality and polish or as some clients put it, “…[their citizen apps] just aren’t ready for prime Read More…