There is a SQL Connector in Power Automate, and it has couple of triggers which are dependent on the IDENTITY/ROWVERSION columns in SQL: The existence of those two columns in the table is a pre-requisite for the trigger to work: https://docs.microsoft.com/en-us/connectors/sql/#when-an-item-is-created-(v2) There is a catch there, though, and I probably would not know about it… Read More »
I’ve been trying to promote my technology blog through LinkedIn for as long as it’s been out there, and all has been going pretty well. Google analytics audience overview for the last 3 years would please any stock trader if this were a stock chart: Well, at this rate my blog might be following in… Read More »
“Common Data Service” connectors don’t have an “Upsert” action: And it would have been a problem for one of the flows I had to implement recently if not for David Yack who pointed out that Update action will do an Upsert. What?? Well, he was absolutely right, here you go: Have fun folks. And thank… Read More »
It’s been a while since I wrote about SSIS – most of what we do these days is happening in the cloud. But, sometimes, we still need to resort to the old good time-proven technologies… such as SSIS. What’s the de-facto standard toolset of any Dynamics/PowerPlatform consultant who need to use SSIS? Well, that’s, of… Read More »
Just a few days ago, when I was writing a post about Power BI Paginated Reports, “Dataverse” connection type was still called “Common Data Service(Preview)” there. As of today, in the updated version of the Power BI Report Builder, it’s called “Dataverse”: There is no reference to the preview anymore, but, apparently, it’s still a… Read More »
In the previous post, I looked at some of the features of Power BI paginated reports. What was still unclear is how security works. Turned out it works pretty much as one would expect. Users having no access to the data won’t see that data in the report. Unless the report has NOT been configured… Read More »
Now that SSRS authoring tools have finally been updated (and there is a great article Nick Doelman published the other day on this topic), it might be the right time to ponder on which technology we should be using moving forward since there are two now: Power BI Paginated Reports SSRS So, how do… Read More »
Have you ever tried adding power apps applications to the office app launcher? I actually had not done it myself up until a few days ago, when one of the users mentioned they were observing some strange behavior there. So I tried, and it was working perfectly fine for me, until, just by pure coincidence,… Read More »
I’ll be absolutely honest – I have no idea what the answer is to the question above. Except that this combination of settings might be a legacy of the older versions of Dynamics CRM? However, if I were to make a suggestion here, I’d say don’t use that combination. Since it may lead to confusing… Read More »
Coincidentally, there seem to be change in how required fields are treated in the model-driven forms. I’m saying “coincidentally”, since I recently wrote a post on a related(though different) topic: https://www.itaintboring.com/dynamics-crm/how-to-not-to-get-stuck-on-the-required-fields-when-creating-a-power-automate-flow/ And, then, a co-worker just mentioned that, it seems, hidden fields are not “required” anymore in the model-driven forms even if they have been… Read More »