Dataverse has been developed for Dynamics where comprehensive data security is essential.  For this reason, Dataverse security is incredibly powerful and flexible, but with that comes a level of complexity! In this post I’ve tried to simplify and explain the […]

Recently I’ve posted quite a bit on how to navigate around Dataverse to identify related rows in different tables.  With self-joins, rows can be related to other rows in the same table Consider the example of an organisation that has

Dataverse Choice columns are quick to create and are straightforward for Makers to incorporate into their app, however, they are very limited.  A more flexible alternative is to host the data in a separate table and access that table using

Setting a Default Dataverse LookUp value in Canvas Apps can give a slick user experience.  I’ll demonstrate using the example of a simple Asset Tracking app.   The app has just 2 screens fronting two tables.  The Location table has a one-to-many relationship

A Short post playing around with embedded tables in collections Contents Create an Single Column Embedded Table within a Collection ClearCollect( colA, { Month: [ “Jan”, “Feb”, “Mar”, “Apr”, “May”, “Jun” ] } ) Extract the Contents of the Table

The Table function is used in Power Apps to manually create a Table within a Power App control rather than retrieving data from a networked data source (such as SharePoint) or a Collection.  But what is it used for and

In the last post I set myself the challenge of creating an dynamic Power Apps Dropdown box that shows the number of records in a table that match the Dropdown selection criteria.  The  requirement was to not have hardcoding so

Aligning data from multiple tables can be achieved in several ways.  Cascading Power Apps Galleries, creating virtual tables using AddColumns, even simply using the humble Label.  These techniques can be combined together to deliver the best solution Galleries and Relational Data

Custom Connectors Power Apps is a fantastic platform not only to build great Apps quickly, but also to connect to remote services.  There are a huge amount of zero-cost web services out there and even many of the premium sites
Scroll to Top
Scroll to Top