Blog - Recent Posts

Dataverse - How to work around the error "multiple levels of many-to-one relationship expansion aren't supported"

Have you encountered the error "multiple levels of many-to-one relationship expansion aren't supported" when attempting to write some formula? If so, this post clarifies the meaning of this error and describes how to work around the issue.

SQL - How to return data from Stored Procedures to Power Apps

If you're looking to call SQL Server Stored Procedures from Power Apps, this post walks through this new feature and demonstrates how to display and use the return values from an app.

Reading Dynamics 365 and Power Platform User Group successfully holds its Q1 2024 meetup

Find out what happened at the Q1 2024 Reading UK Dynamics 365 and Power Platform User Group meetup in Reading, England.

Data - How to show the distinct rows from 2 data sources or collections

If you want to combine the contents of 2 collections or data sources and return the distinct rows, this post walks through an example of how to carry out this task.

Data - How to implement circular rotational date sorting

There can sometimes be a requirement to implement circular or rotational sorting, particularly in the case of data that contains dates. This post describes the formula to carry out this task.

Dataverse - The easiest way to modify Dataverse data outside of Dataverse and Power Apps

If you need an easy way to add, edit, and delete the records in Dataverse, this post describes a simple method that you can use.

Forms - When calling SubmitForm, how to debug the error "Network error when using Patch function"

If you receive the error  "Network error when using Patch function", here's a quick demonstration and walkthrough of how to diagnose this error.

AI Builder -  Where to find the AI Models in the Power Apps designer

If you're having some difficulty finding some of the AI Builder models in Power Apps, this post describes where you can find them.

Text - How to truncate and add 3 dots / ellipsis to long label text

If you need to summarise long text by only showing the first characters and adding '...' to the end of the text, this post shows the easiest way to carry out this task.

Controls - How to build a control to enter measurements in inches with fractional units

If you need to build data entry screens that permit the entry of fractional units, this post walks through how to carry out this task with the help of a slider control.

FormuIas - Is it possible to call a user-defined function recursively in Power Apps?

Calling a user-defined function recursively is ideal for solving problems that can be broken down into smaller instances of the same problem, and is perfect in scenarios where we need to traverse tree structures. Is it possible to call a user-defined function from Power Apps? Find out in this post!

Formulas - A beginners guide on how to create and call user-defined functions (UDFs)

If you want to improve your app by defining reusable parameterised functions, this post provides an introductory guide on how to use this new feature.

Text - How to display text and content upside down

If you need to show text upside down, this post walks through an example of how you can carry out this task.

Dates - How to convert a month name (eg January, Feburary, March) to month number (eg, 1, 2, 3)

Do you need to convert a month name to the month number? If so, here's the formula to carry out this task.

SharePoint - Deleting the last record from a SharePoint list - how NOT to do this!

If you need to write formula to delete or to remove the last record from a SharePoint, this post describes the pattern that you should follow.