There's no built-in way to hide/show controls with a transition effect. The best workaround I suggest is to use a technique by Mr Dang. In this post, I highlight this technique and explain - what is an easing equation?

We can calculate the distance between two longitude and latitude co-ordinates using a trigonometric calculation. It's a complex formula so in this post, we'll find out how exactly this works, including a verification of the result. We'll see how to perform this distance calculation in both kilometers and miles.

With SharePoint, the syntax to patch certain data types can look very complicated. In this post, we'll summarise the syntax to patch lookup, single choice, multi-choice, yes/no, single person/group, and multi person/group columns.

Help - my app isn't picking up correct location/GPS values! If the location features aren't working, it might be due to these reasons that I most commonly see.

The settings area has now received a new look! Let's compare how the new look compares against the old, including a nostalgic look at what it contained, way back in 2017.

With SQL Server, the Count and CountRow functions produce delegation warnings. Without these functions, does it make it impossible to count records from large SQL Server tables? The answer is no! In this post, I'll describe a trick that enables us to carry out this task.

From the SQL Azure Portal, there is now the option to create a Power App ontop of a SQL Table. Here's a closer look at this feature.

Help! - my numbers don't format correctly or they appear with loads of trailing numbers. If we encounter this problem, a likely cause is a bug that affects SharePoint calculated columns. This post examines this issue in more detail.

At some point, many app builders want to use the SharePoint feature to import Excel data into a new list. There's a 'knack' to doing this and in this post, I'll describe the settings to make this process as smooth as possible.

What does the delayed load setting do? In short, it improves the speed of our apps, particularly the start-up time. In this post, we'll examine traces to prove that this feature actually works, and find out why it's important to take heed of the 'inefficient delay loading' warnings that the 'app checker tool' identifies, to help us take full advantage of performance benefits that delayed load offers.

Why doesn't my app work today?? If your app worked fine yesterday and suddenly stops, or works differently today, it's possible that an update to Power Apps has broken your app. If this happens to you, here's what you can try to restore your app to a working state.

It can be so frustrating when some obscure error prevents us from logging into Power Apps! If we find ourselves in this position, here are 5 things we can try to resolve the problem.

How can we apply conditional validation to a form - for example, if the status is closed, a closed date must be entered? In this post, we'll look at a quick and simple way to add this type of conditional, mandatory field validation to a form.

With SQL Server, there is a bug that prevents us from filtering datetime columns with equality operators. All SQL Server app builders should be aware of, and this post describes the behaviour of this bug in more detail, including workarounds to the problem.

The "Explicit Column Selection" setting improves the performance of our apps. But how exactly does it work, and what problems can it cause? This post describes the setting in more detail, including demonstrations of behaviour with traces.