Tag Archives: Power Platform

TDS endpoint for custom development and data integrations?

TDS endpoint availability is, probably, one of the coolest technical capabilities introduced by Microsoft in the last few months. However, even though it’s great to be able to run SQL queries in the SQL management studio as described in Microsoft docs: https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/cds-sql-query There are other usage scenarios which seem to be very enticing. Using it… Read More »

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 »