Microsoft Dataverse has a somewhat unique interpretation of what a “required” field is. It’s a bit of “do as I say not as I do”. For example, I can’t create an account in the user interface not having “account name” populated (since it’s a required field): But, of course, behind the scene… whether through Excel… Read More »
Every now and then, I would run into this error: What’s happening there is that I’m going through a list of records, and, occasionally, there is a field that’s not populated. So, in the example above, here is where it fails: That substring function expects a value, but how do we check if the value… Read More »
I got a little stuck the other day trying to upload files from Power Automate to a “file” filed in Dataverse – it turned out all the functionality was there, I was simply looking in the wrong place. CDS (current environment) connector has a couple of special actions to work with the file/image attributes: This… Read More »
I was toying with the idea of creating a dictionary variable in Power Automate, and, it seems, I got onto something. Unless there is an easier way? Well, just for the sake of experiment, what if we wanted to count the number of accounts per owner in our Dataverse instance and store those numbers in… 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 »
I am wondering if PowerAutomate flows can really be part of CI/CD when there are non-CDS connections? There seem to be a few problems here: Once deployed, the flow is turned off, and all non-CDS connections have to be re-wired in order to turn it on. That’s a manual step While re-wiring the connections, we’ll… Read More »
I was playing with the PowerAutomate approvals tonight, and, since I have not used them at all before, I am wondering if CDS is an “add on” for the approvals or if CDS is a pre-requisite? See, when looking at the link above, it seems I don’t need CDS to work with the approvals: However,… Read More »
A colleague asked me a question earlier today (I can probably use this theme for half of the posts here… for that matter, do you have a good question? Feel free to ask ): “why is this Flow condition on regardingobjectid type not working?” And the condition looked more or less like this: (It’s truncated… Read More »
AD group teams are not managed exactly the same way “native” teams are managed in CDS, and one difference seems to be that associate/disassociate events will not be triggered for such teams. However, this does not mean there is no way to respond to a change in the group membership, it just has to be… Read More »
It seems like a no-brainer question with a simple “no” answer; however, there was something that came up on Linkedin while discussing my other post about using CDS pre/post images with the Flow: https://www.itaintboring.com/dynamics-crm/cds-post-images-and-cds-pre-images-in-powerautomate-flows/ What if, instead of using the service bus, we tried using “web hook” option in the Plugin Registration Tool? It does… Read More »