UnPivot columns in Microsoft Power BI and your data may stop adding up

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 values in any of the columns. For example, The sum of the column named Other Columns is 5. Other ColumnRead More…

Use Timers to Automate Success Screens in PowerApps

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, a Success screen is great for letting the user know that a completed form was submitted and there iRead More…

Create Documents Instantly with Power Automate

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 and thought to share it here, too. First Things, First Is automation worth it? For automatic doRead More…

Display an Image in a PowerApps Gallery, Conditionally

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 incident record. Gallery with circled image signifying a priority record Gather and Upload the Image
Read More…

Automatic Refresh in PowerApps

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 automatically refreshing data: OnVisible Property Adding a Refresh() function to a screen’s OnVisible propeRead More…

Create a Customized Welcome Screen in PowerApps

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, click New Screen. Select a blank or scrollable screen. This example uses a scrollable screen. Move tRead More…