Now that we went through the process of creating a Power Automate flow that’s using Word Template action, why don’t we get this integrated into a model-driven application? Let’s first create a very simple invoice form. You should be able to do it easily (or you could use any other entity – I’m just… Read More »
I’ve never been a big fan of Word Template in Dynamics 365 since they have quite a few limitations, and, yet, I had to use them every now and then since they are so easy to develop (till you run into the limitations, of course). Besides, they are not so easy to deploy into different… Read More »
There is another renaming, so just be aware: https://powerapps.microsoft.com/en-us/blog/reshape-the-future-of-work-with-microsoft-dataverse-for-teams-now-generally-available/ And I can’t help but notice https://dataverse.org/ Well, I know it’s difficult to come up with good names these days since all of them have already been taken, but, quite frankly, what’s wrong with CDS, or, at least, how come Dataverse sounds better? Either way, it… Read More »
Recently, I happened to look into how google sheets connector works, and, to be honest, I was a little bit disappointed. First, I wanted to blame google. But, it turned out, there is no hiding the fact that’s it’s been provided by Microsoft itself: https://docs.microsoft.com/en-us/connectors/googlesheet/ In general, this connector works. But there is one notable… Read More »
Bitwise operators are, likely, not the most popular operators in the low-code world, so there is no surprise Power Automate does not have those. Which is a bit unfortunate, since, when we do need those operators, it seems like we have to opt for a custom connector/azure function/etc. But, come to think of it, if… Read More »
If you ever tried using “List Records” action with the POA table (principalobjectaccess), you might have noticed it’s not showing up in the dropdown list: However, it’s easy to solve. You just need to know the “set” name for that table (which is “principalobjectaccessset”), and, then, you can enter that name as a custom value:… Read More »
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 »