You have probably heard that Entities are Tables now? If not, have a look here: https://docs.microsoft.com/en-ca/powerapps/maker/common-data-service/data-platform-intro#terminology-updates Well, am I thrilled about it? Am I concerned about it? Quite frankly, we should all get used, by now, to all those changes in the product names and/or in the terminology around Microsoft products. Sometimes, those changes are… Read More »
Right on the heels of my previous post where I was talking about delegation in Canvas Apps, here is another one on the same topic. We can’t help but break delegation when filtering polymorphic lookups, right? Since, of course, “AsType” cannot be delegated: Well, if you are up to writing a little plugin, it’s, actually,… Read More »
Here is a warning message which I keep running into: (The “Filter” part of this formula might not work correctly on large data sets) It’s not that I keep running into it every day. But I find myself looking at this warning every time I’m setting up data sources for a new application. So, maybe,… Read More »
The script below might help if you wanted to read CDS environment variable value in your javascript web resource. top.environmentVariables = []; function getEnvironmentVariableInternal(varName){ “use strict”; top.environmentVariables[varName] = null; Xrm.WebApi.retrieveMultipleRecords(“environmentvariabledefinition”, `?$top=1&fetchXml=<fetch version=’1.0′ output-format=’xml-platform’ mapping=’logical’ distinct=’true’> <entity name=’environmentvariabledefinition’> <attribute name=’defaultvalue’ /> <filter type=’and’> <condition attribute=’schemaname’ operator=’eq’ value=’` + varName + `’ /> </filter> <link-entity name=’environmentvariablevalue’ from=’environmentvariabledefinitionid’… Read More »
With Wednesday being a holiday (Remembrance Day in Canada), Thursday feels a bit like Monday. Which means I am still in the “holiday mode”, I don’t necessarily want to do anything at all, and, hence, some of the minor issues with Power Platform which should have been fixed long ago seem somewhat inflated on this… Read More »
You know how we can pick output fields from the Flow actions: So, why is it that, for the flow below, “Filter Array” output is not presented in the same way it’s done for the “Get Rows” action? Even though I’m really just filtering on the results of the “Get rows”, so would not it… Read More »
If you ever wanted to use Google sheets in Power Automate, there is a connector for that: However, it turned out to be a little tricky, and this is what this post is about. Imagine there is a very simple spreadsheet: What if I wanted to read a specific row from that spreadsheet in the… Read More »
There is, really, not a lot to write about it. The screenshot below says it all: There is one link missing on the right side, which is “Edit Filter Criteria”. It does show up for some other views, though: But, from what I could see, it disappears once the view(or, possibly, the filters) has been… Read More »
Earlier this month, I wrote a couple of post about reporting/document generation. While working on it, I also tried one other option which you may find useful, too. One of the biggest problems with Word Templates, be it classic word templates in model-driven apps or new populate word template action in Power Automate is that… Read More »
There are a few reasons I still have not, really, touched Power BI (beyond some very basic things just to see what it’s capable of), but, having looked at my reporting options recently, I figured Power BI paginated reports might be what’s required on the project. Luckily, it turned out we might be fine on… Read More »