Blog - Recent Posts
Dates - How to format date day numbers with suffix (st nd rd th)
If you need to format or get the suffix for a day number (eg 1st, 2nd, 3rd), this post describes the formula you can use.
Dataverse - How to build an edit form to set the parent account for a contact record
A task that canvas apps builders struggle with, is how to set the parent account for contact record. The account lookup field doesn't appear in the form editor and doesn't appear to be editable in the data grid view. This post describes the behaviour walks through how to build an edit form in a canvas app that enables the user to set the parent account on a contact record.
How to split the URL parameter name and values from a hyperlink
If you need to parse hyperlinks and retrieve parameter values, this post describes how to carry out this task.
Dataverse - How to use a checkbox control a set a yes/no field in Dataverse
For users new to Dataverse, a common difficulty is how to build a form that sets Dataverse Yes/No Boolean fields with a checkbox or toggle control. This post describes how to configure such a form.
Sample App - Check out this great example of a calculator app
If you're looking for a great example of a calculator app in Power Apps, you should check this out.
Data - How to Validate UK National Insurance Numbers
Are you sure the National Insurance numbers you’re collecting are valid? This article walks through how to validate UK National Insurance numbers with Regex.
Dynamics 365 and Power Platform User Group Q3 2023 meetup - A Night of Networking and Learning
Find out what happened at the Q3 2023 Reading UK Dynamics 365 and Power Platform User Group meetup in Reading, England.
AI - Tips for creating Dataverse tables with Co-Pilot
Copilot in Power Apps offers a far quicker and smoother way to create Dataverse tables. However, the way that it currently works can be quite quirky. Here are some tips on how to work more effectively with Copilot.
SQL - How to call SQL Server Stored procedures more easily with the help of Dataverse plugins
It's now possible to execute SQL Stored Procedures more directly from Power Apps. This post walks through a demonstration of how to do this.
Bug - What to do when the data section of the Power Apps Maker portal doesn't work
Currently, there is a bug that prevents connections from being created, shared, or edited from the Power Apps Maker portal. Here's what to do if you experience this problem.
Errors - What to do when creating an app with the 'start with data' feature fails
If you attempt to create an app using the 'start with data' feature and the screen becomes 'stuck', here's what you can do to diagnose the problem.
Text - How to display text with striked/crossed out formatting
Do you need to display crossed-out text in Power Apps? If so, this post walks through an example of how to carry out this task with the HTML text control.
Editor - How to Bring Back the Data Panel in Older Apps
There is an ongoing issue where the data panel may not appear in Power Studio when you open an older app. Here's an updated post on some techniques you can use to fix this annoying issue.
Microsoft Build 2023 - Best highlights for Power App Builders
Don’t miss the following top features for Power Apps Builders that were announced at the Microsoft Build Conference 2023.
Error - How to fix the "This app isn't opening correctly" / "InsufficientActivePlanForApp" message
If users receive the "This app isn't opening correctly" / InsufficentActivePlanForApp error, here are some steps you can take to resolve this issue.
Recent Posts
- Apps - How to add predefined stock background images
- Dataverse - How to work around the error "multiple levels of many-to-one relationship expansion aren't supported"
- SQL - How to return data from Stored Procedures to Power Apps
- Reading Dynamics 365 and Power Platform User Group successfully holds its Q1 2024 meetup
- 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
Blog Author
Tim Leung Author, software developer, Power Platform specialist |