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 »
In the first version of the Angular-based portal template there was no ability to create support tickets through the portal, which is what the template would have to have in order to be a little more useful right off the bat to cover at least a basic self-service scenario. So, there is some of that in the… Read More »
There is no argument PowerApps Portals allow us to build a portal for CDS relatively quickly, relatively easily, and with a limited amount of development efforts. However, just because it’s been a while since I wanted to do something with Typescript and Angular, I figured why would not I try creating a completely custom portal… Read More »
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 »
I have certainly missed some news. Apparently, quick find in the unified interface now works as it has always been expected to work (but never did): It’s now using selected view columns And it’s now applying selected view filters If I were reading release wave 1 plan more carefully, I would have noticed the following… Read More »
Social distancing has definitely took a toll on my blogging – it’s been a while since the last post. Although, I’ve actually learned quite a few things outside of PowerPlatform in the last month, so I could probably start blogging about a few other things now: How to teach math fractions How to build wooden… Read More »
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 »
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 »
Before you start reading, here is a disclaimer right away: this post is not an extension to the power apps documentation. It is just my attempt to figure out how Lookup and Filter functions work in Canvas Apps when those functions are applied to the CDS data source. I am hoping the information below is… Read More »
I have seen this error a few times so far, and every time it seems to happen out of nowhere. My application used to work – I even recorded a video of how it was working the night before to share it with the client. Lucky me, since, when I opened it the next morning… Read More »