To start with, why do I even call it a battle? Isn’t it supposed to be a peaceful coexistence where each type of power apps can contribute where the other type is lacking in functionality? In theory, yes. In practice, it seems things may spin out of control in the extreme cases. Imagine there is… Read More »
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 was troubleshooting missing dependencies earlier today, and, after some digging, uncovered a hidden solution in the environment. I could see that solution when looking at the layers: And I certainly could not see it in the list of solutions neither in the old interface, nor in the new one. Well, there is always a… 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 »