With, Dataverse It's possible to define views. Dataverse stores view definitions in a system table called 'Views'. We can interrogate this table to retrieve the SQL or the FetchXML for a table and this post examines this setup in more detail.

If you want to select a random row or record from a data source, this post summarises the syntax that we can use.

A common requirement to show multiple distinct columns, or to hide duplicate rows in a gallery control. This post highlights a technique to carry out this task.

An occasional question that I hear from app builders is - how do I build dynamic, or data driven navigation structures in Power Apps? This post describes a strategy that we can use.

When we build search screens or filter data against a SQL Server data source, we may want to specify whether Power Apps carries out a case sensitive, or case insensitive search. This post describes the behaviour of case sensitivity when we search data from Power Apps.

To help users more easily identify rows in gallery controls, we can conditionally highlight notable rows. This post describes how to carry out this task.

A question that I hear on occasions is - is the AppColumns function delegable? This question often arises when app builders are unable to retrieve more than 2000 records. This post explores this behaviour in more detail.

For date or scheduling diary type apps, it can be very useful to retrieve a list of days or months that begin on specific day or month. This post describes some formulas that we can use.

The combo box control does not support the display of date values. This post examines this behaviour and describes a method to overcome this issue.

Good news! Microsoft have announced that from October 2021, the licensing costs for many users could fall by half.

When we encounter a bug or unexpected behaviour in Power Apps, here's where to look if we want to find out if Microsoft are aware of the problem.

If you work frequently with Power Apps, it's a good idea to create browser bookmarks to help quickly navigate to the most commonly used areas. This describes the fomrat of the URLs that we can add as bookmarks.

A common question I often see is - how do I filter a table or SharePoint list by month and year? This post describes how to carry out this task using formula that is delegable.

When building data entry screens, it's often necessary to validate dates. Unfortunately, the date picker control contains no built-in way to specify the minimum and maximum permissible values, or other validation rules. This post describes a way to restrict the value that a user can enter through a date picker control.

Power Apps now offers the ability to read text and URL data from NFC tags. This post describes this new feature, including how to write data to an NFC tag, and how to retreive the values from a canvas app.