Swap Controls in PowerApps

I really enjoy working with PowerApps but I cannot say the same about the default form controls. I suppose my SharePoint list datasource is to blame but I prefer to keep the SharePoint columns as simple as possible. Unless my SharePoint list columns contain dates, people’s names, numbers or many lines of text, I rarely use any column other than Single line of text. Why? I don’t feel like dealing Read More…

More ways to work with errors in PowerApps

In the last post, Handling Errors in PowerApps, I discussed a way to prevent errors by disabling submit buttons until all required fields are completed and how to display custom error text for a data card based upon another data card’s value. That post spawned some questions which are the focus of this post. In the last post, I mentioned that the built-in error contains a not-so-friendly messaRead More…

Customize Your PowerApps Browse Screen with Multiple Galleries

I like to make each PowerApps app look like an app. A colleague of mine noticed this about apps I develop and told me that’s what I did. It had not really dawned on me. It is not enough for me to simply make the app function, I must design the app. I must think about how the user will interact with it and how they will want to interact with it. What will the user want to see and how will they wanRead More…

Handling Errors in PowerApps

One of the easiest ways to deal with errors in a PowerApps form is to prevent them and stopping end-users from submitting incomplete forms is the quickest way to getting good data. Required Fields Disable Form Submit Buttons in One Step The Error property of PowerApps forms contain a built-in not-so-friendly message that is invoked when form errors exist. This property is able to be explRead More…

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…

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…