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 […]
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
January 2024 Update – Microsoft has improved the table navigation. Read about the lastest functionality: Navigating Dataverse Tables. Recently, I wrote about how saving a Dataverse row to a variable can help Dataverse navigation. In that post, I used a series
A frequent requirement with canvas apps and Dataverse is to filter the contents of a table by a particular column within that table. Depending on the complexity of the filtering, that can be very straightforward or if you want to
