Blog - Recent Posts

Dec 26, 2019

Formulas - Generating Row Numbers - Part 2

Here's a technique to display row numbers against a sorted set of data in a gallery control.

Formulas
Feb 06, 2019

Data - How to access nested collections/tables

If you're struggling to access records in nested collections/tables, here's some example syntax.

Formulas Search Filter
Jan 24, 2019

SQL Server for Beginners Part 3 - Installing On-Premises Gateway

Find out how to install and connect to a local SQL Server with the on-premises gateway

Data Sql Server
Jan 14, 2019

SQL Server for Beginners Part 2 - Installing Management Studio

Data Sql Server
Jan 04, 2019

SQL Server for Beginners Part 1 - Installing SQL Server

If you're completely new to SQL Server, this post will show you how to install an on-premise instance of SQL Server.

Data Sql Server
Jan 03, 2019

Sample Apps– How to auto save forms, carry out translations, and much more!

Both new and experienced app builders should look at Mr Dang's 'design patterns' app. Read this to find out more, and to also find out how to setup Microsoft Cognitive Services with PowerApps.

General Info Sample Apps
Dec 27, 2018

Searching data–What you need to know about case sensitivity

It's important to understand how PowerApps behaves in terms of case sensitivity. Here are 3 things you should be aware of.

Data Sql Server Sharepoint Search/Filter
Nov 09, 2018

Images - How to create images that can change depending on data

If you want to build charts or images that can change depending on data, here are some blog posts you should definitely read.

Data
Nov 07, 2018

Text - How to get part of a string / Splitting text by spaces

How do you extract sections of a string? Here are some code samples that can help you.

Oct 26, 2018

Excel vs SharePoint vs SQL Server vs CDS

Don't know what data source to use? Read this to find out which data source can best suit your needs.

Sql Server Data
Oct 18, 2018

SQL - What you need to know about bulk updating records

Bulk updating SQL data from Power Apps can be very slow. Read this to find out why.

Sql Delegation Data
Oct 13, 2018

Authentication - Allowing Guest / Anonymous Access

Coming soon! Guest access for PowerApps...

General Info
Sep 25, 2018

Excel - Reasons NOT to use Excel as a data source

Before you choose to Excel as a data source, you must read this.

Data Excel
Sep 16, 2018

SharePoint - What you need to know about Filtering Data

Before you use SharePoint as a data source, make sure to read this to find out what problems you might encounter.

Data Sharepoint Delegation
Aug 29, 2018

Review of PowerApps - PC Magazine

PowerApps wins the PC Magazine 'Editors Choice' award.

General Info