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!
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.
Here's a walkthrough on how we can customise a data entry screen to include a button that carries out unit measurement conversions..
This post demonstrates a method we can use to convert semi-structured strings to rows and columns.
When displaying records in a gallery, it can be very helpful to show the sums of values. This post provides a walk-through on how to carry out this task.
If you need to calculate compound interest from Power Apps, this post describes the formula to carry out this task.
If you need to convert images of Power App formulas to text, here's a review comparison of some OCR tools that you can use.
For cases where we want to display values or prices in a different currency, this post describes a simple example of how to use a drop-down box to display the converted value.
Following the introduction of the ParseJSON function, we can more easily parse JSON for use from within Power Apps. This post highlights the formula to parse 4 typical JSON structures that we may encounter.
It's now possible to retrieve records from a table, collection, or data source by ordinal number. The function that provides this functionality is called Index, and this post summarises how it works.
A question that arises on occasions is - why doesn't my If statement work? This post walks through one of the most common causes and highlights the possible workarounds.
When we construct expressions that include the Boolean And and Or operators, which operator takes precedence? Find out in this post.
There may be a need to set the data source of a combo box control to a comma-separated list. This post walks through how to carry out this task.
When we work with numbers with Power Apps, a common requirement is to round numbers. This post summarises the formula to carry out some of the most common rounding requirements, including how to round to multiples, how to round to values such as 0.5, 0.99, 0.45, how to round to odd/even numbers, and how to return the integer portion of a decimal value.
For app builders who are relatively new, the syntax for writing formula can be confusing - perticularly with regards to the use of brackets. This post summarises the bracket types that are available in Power Apps.
- Data - How to show the distinct rows from 2 data sources or collections
- Data - How to implement circular rotational date sorting
- Dataverse - The easiest way to modify Dataverse data outside of Dataverse and Power Apps
- Forms - When calling SubmitForm, how to debug the error "Network error when using Patch function"
- AI Builder - Where to find the AI Models in the Power Apps designer
- Text - How to truncate and add 3 dots / ellipsis to long label text
- Controls - How to build a control to enter measurements in inches with fractional units
- FormuIas - Is it possible to call a user-defined function recursively in Power Apps?
- Formulas - A beginners guide on how to create and call user-defined functions (UDFs)
- Text - How to display text and content upside down
- Dates - How to convert a month name (eg January, Feburary, March) to month number (eg, 1, 2, 3)
- SharePoint - Deleting the last record from a SharePoint list - how NOT to do this!
- The easiest way to caption images with AI in Power Apps
- Controls - Top 6 changes that are coming to Modern Controls in 2024
- SharePoint - How to check if a user belongs to a Microsoft 365/ SharePoint group
- How to fix licensing error when registering for the Power Apps developer plan
- Walkthrough - An beginners guide to building an app that stores images in SharePoint
- Designer - How to fix the problem with the formula bar not resizing