What is the Common Data Service?

This post defines what both the Common Data ServiceĀ (CDS) and the Common Data ModelĀ (CDM) are. The Common Data Service and the Common Data Model are core concepts in Microsoft Business Applications and the whole PowerPlatform, so it’s important to know what they are if your planning on or already in this area. This post aims to do this in a simple and easy to understand way.

The Common Data Service aims to be a single place for data used in interactive applications across an organisation. It achieves this in a few different ways. Read on to find out how!

Filter a Gallery in Canvas Apps on the Status Reason field (or any other OptionSet in CDS)

So this post is out of pure frustration that this information seems to be really hard to find (for me anyway) for what seemed like a basic requirement. I wanted to load a Gallery of information in a Canvas App based on the status reason within the Common Data Service. This field is often used in model-driven apps, including Dynamics 365 so being able to filter on this is pretty necessary for companion Canvas based apps.