Filter for “Not In” Scenarios in Power Apps

Power Apps is equipped with a lot of great functions. Unfortunately, Not In is not an available function but there are ways to get the same result. In the example below, there are a list of users in a gallery. The list is displayed by the following code entered in the Items box for the gallery:Office365Users.SearchUser({searchTerm:txtSearch.Text})where txtSearch is the name of my search field.Read 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…

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: Automatic Refresh when a PowerApps Screen Becomes Visible Adding a Refresh()Read 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…

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…