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.
One thing that can catch out app builders is that the Distinct function is not delegable. This post illustrates this problem through an example that shows how the distinct function may not return all records that we expect.
In cases where we need to join tables and to display details from related tables, the most efficient way to perform this task is to use a view. This post provides an introduction on how to display related data on a gallery control, and how to configure an app to update a record that a users selects through a gallery control that is connected to a view.
In cases where we need to display non English data, there can be the requirement to sort data using langauge specific sort sequences. With SQL Server data sources, we apply custom sort sequences through collation settings, and this post describes how to apply this technique to a Power App.
A very common requirement is to show distinct values from a SQL Server table. The most efficient way to accomplish this is to build a view. This post walks through how to carry out this task.
We can more easily access records in Dataverse by enabling the TDS protocol. This opens up read-only access to tables through SQL Management Studio and PowerBI. In this post, we'll look at why we might want to do this and the steps to set this up.
Bulk updating SQL data from Power Apps can be very slow. Read this to find out why.
- Formula - Transposing/converting rows to columns- an almost impossible task?
- Charts - How to create donut charts
- Settings - The easiest way to find environment id and other settings
- Admin - How to quarantine or block all users from running a specific app
- Learning - Learn Power Apps through the free Microsoft Virtual Training Day events (and receive a free exam)
- Formula - How to round times to the nearest x minutes
- Formulas - Review of how to write formulas using natural language
- Licensing - Microsoft 365 licensing price set to increase in March 2022
- SharePoint - Filtering lists by User() is now delegable
- Dates - How to get the start date from week number
- Data - How to remove/delete a field from a record
- Numbers - 10 examples of how to round numbers
- Dates - How to check if a year is a leap year
- Dates - How to get the week number for a given date
- Dates - How to get the nth weekday for a month
- Dates - How to get the last weekday for a month
- Forms - How to calculate values (eg sums and products) and store the results in SharePoint or other datasource
- Sums - How to calculate 'year to date' or running totals