Unpivot Columns In Power BI, Unpivot Columns transforms columns into rows with attributes and values. In other words, it changes the data structure and as a result it can change values in a visualization. Other ColumnsApplesOrangesBananas12344212 In the table above, we can sum the valuesRead More…
I am not the biggest fan of Success screens but I have started adding them to a few apps I developed. Why? In the right app, a Success screen can add value. For example, if I am developing an app where the end user will not receive any other confirmation of their interaction with the app? If so,Read More…
A while ago, I was asked about the possibility to automate creating documents. Recently, a friend asked the same question. Her organization is hoping to develop a homegrown solution instead of purchasing a tool that fails to do everything they need it to do. I’d worked out a pretty quick solution aRead More…
As I develop apps, I am constantly looking for ways to enhance the data that’s there. I enjoy using images as a way to draw attention to specific records and provide more detail, at-a-glance, In this sample app, I use a simple image (the red exclamation mark) to signify a high priority incidenRead More…
I prefer to remove the standard refresh buttons from my PowerApps screens. Instead, I build automatic refresh into action states like OnVisible for screens. When a screen becomes visible, data is refreshed and my app’s users see the latest data. Here are my two favorite methods for automaticallyRead More…
Give your PowerApps app a bespoke feel with a customized Welcome Screen. Don’t let this concept fool you. The Welcome Screen can do a lot more than say “hello”! Consider adding in some information about the current user for more thoughtful functionality.
Add a New Screen On the Home tab, clRead More…
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 Read More…
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 forRead More…
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 colRead More…
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 fiRead More…
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 thRead More…
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 functRead More…