Blog Recent Posts
Blog - Recent Posts
Dataverse - How to switch to the classic designer when the option is not available
If a Power Platform update breaks features in the Dataverse designer (such as the table or view designers), and the option to open the classic designer is missing, it may be possible to carry on working by accessing the classic designer directly by web address.
Excel - All you need to know about the 'Excel Online Business' connector
The traditional way of connecting to an Excel data source through the OneDrive connector imposes serious limitations on the number of records we can retrieve. We can overcome several of these with the Excel Online Business connector, but it introduces a different set of problems. This post introduces the 'Excel for Business' connector, and describes what you need to know.
How Power App builders can more easily connect to code that has been written by pro-developers
Coming soon will be the release of the 'Visual Studio Extensions for Power Platform' - a feature that will allow app builders to more easily integrate features that are built by pro-developers. This post takes a first look at this feature.
Forms - How to convert a display form to an edit form
If you want to convert a display form to an edit form, there's unfortunately no way to do this through the app designer. However, we can accomplish this through code and this post describes how to carry out this task in more detail.
How to detect the end-user web browser from within canvas app
There's no direct way to retrieve the session ID from within a running Power App. A workaround to this issue is to retrieve the session ID by calling a Flow. This post walks through how to implement this technique.
SharePoint - How to fix the "skip to main content" error message on integrated forms, or to fix forms where records don't save
Why do I receive a "skip to main content" message when I attempt to save a record on a SharePoint integrated form? This post describes this problem that app builders sometimes encounter.
Android - Here's how to correctly configure the back button to navigate to the previous screen
There are two settings to set when we want to configure the back button on an Android device to navigate the user to the previous screen, rather than quit the running app. Which is the correct setting? In this post, we'll find out.
SharePoint - Use this trick to perform a 'contains' type search in a more delegable way
With SharePoint, it's difficult to perform a 'contains' type search that returns all matching records where the search term appears anywhere within a field, due to the fact that the search function is not delegable. A possible hack is to perform the search through a look up column. This enables us to carry out a delegable 'contains' type search against lists of up to 5,000 records. This post describes this technique in more detail.
SharePoint - Choice function now includes search capability
If you've been using Power Apps for some time, you'll be familiar with the Choices function - the function that retrieves lookup items from a SharePoint or Dataverse datasource. Following an update to Power Apps, this function now offers the built-in ability to filter the results. This post looks at how this applies to a SharePoint data source.
How to generate shorter/friendlier URLs for an app
The web address to start a Power App can look very unfriendly. This post explores how we can use third-party URL shortening services to generate friendlier URLs. In particular, we look at how to use the 'Short URL' service to manage short/vanity URLs from within a canvas app.
Bug - Sending email messages with the Office365Outlook connector that includes SharePoint file attachments no longer works
If you want to use the Office365Outlook connector to send email messages with file attachments from SharePoint, it's useful to note that this no longer works following a recent update to Power Apps.
Forms - How to copy/save an existing record on a form as a new record
A handy feature is the ability to make a copy of an existing record. The typical use case scenario of this is to speed up, or to simplify data entry. This post describes a technique that we can use to carry out this task.
How to retrieve and display the session ID from inside a running Power App
There's no direct way to retrieve the session ID from within a running Power App. A workaround to this issue is to retrieve the session ID by calling a Flow. This post walks through how to implement this technique.
Bug - OnStart property missing from designer - impossible to set OnStart formula
A recent update to Power Apps appears to have introduced a bug that makes it impossible to set OnStart formula. This post documents this issue and describes a workaround.
Forms - How to show Office 365 user profile details on a form
For business apps that are designed to facilitate collaboration, there may be the need to display the details of the currently logged on user, or some other specific user. This post walks through how to display user details on a canvas app form.