The Joy and Frustration of JSON Over the past few weeks and months, I’ve posted quite a few blog posts about working with JSON files, particularly in Power Automate, and interacting with APIs. The content has come from what I’ve […]
The Power Platform provides immense flexibility in connecting apps and automating workflows with APIs. A common scenario is using a Canvas App to trigger a Power Automate flow, which in turn, uses the HTTP connector to interact with external APIs.
Combining 2 Columns Sometimes it really helps to combine 2 columns to display in a dropdown control, for example if you have first and last names in separate columns Its straightforward to do that by using the AddColumns function within
There’s a Chinese proverb that says “A journey of a thousand miles begins with a single step” and that equally applies to coding complex formulas in Power FX I was asked about a previous post Filter Based on Child Data, and
Filter based on Child Data – Here’s a quick demo on how to get a filtered list of records from a parent Dataverse table based on data in a child table In my user case, I have a simple Dataverse structure
When building a Canvas app screen, sometimes there’s not enough screen space for all the data you want to display. Possible solutions are to implement vertical or horizontal scrolling or add tabs to the screen, but a nice alternative can
Dataverse Many to Many Relationships It can be a little tricky to work out how to navigate the many to many relationships between Dataverse tables Let’s look at the many-to-many relationship between the Teams and User tables. A Team can
By default, in Power Apps, the data in a choice column is displayed in the order in which the choice options are entered in Dataverse However, choice columns can be filtered and sorted when displayed in a Canvas app. How
Exiting an app is fine when data has been saved, but the inadvertant closing of an app can lead to lost work. Read on to find out how to use the ConfirmExit property to help prevent users losing unsaved changes
Canvas Apps can be accessed from many different devices such as phones, tablets, laptops, and desktops. A responsive canvas app automatically changes its layout depending on the screen size of the device This can include simply stretching or re-sizing the
Canvas App Size A canvas app runs in a client browser as a single web page and the larger the canvas app size, the greater the device memory that can be required for the app to run If an app
Power Apps delegation is the processing of a query within the data source itself rather than by Power Apps. Delegable queries are far more efficient because the query is executed quickly on the server and the full set of results