Tag Archives: Power Platform

Using SQL Management Studio with CDS

Just got to play with the latest cool feature, which is using SQL Management Studio to connect to CDS environments. You’ll find the documentation here: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/cds-sql-query If you have not seen what it looks like, here is an example: To set it up, you just need SSMS v18.4, and don’t forget to configure your environment… Read More »

When “required” field validation is not client-side only anymore

When working with the model-driven applications, we can make a field required, but, normally, that would not make any difference for server-side processing. That field will be required on the form: But I would have no problem at all using “empty” value for that field through the API/SSIS/etc. Or, as in the case below, by… Read More »

Canvas Apps: What is a “scope” and, what does it have to do with Filter/Lookup functions?

In the previous post, I was looking at which attributes are added to the CDS query by the Filter/Lookup functions. Might not end up with a definitive answer there, but, to summarize, chances are you’ll get the attributes included IF those attributes are utilized in the other formulas. Now, it turned out there is a… Read More »

User licensing in D365 instance

When thinking about user licensing in D365 instances, you may be thinking of D365 applications. However, from the licensing standpoint D365 instance is nothing but an “advanced” CDS instance with a bunch of first-party apps deployed there, so it is still possible to use Power Apps “per app” and “per user” plans in those instances.… Read More »