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 »
There is a strange action in Power Automate which is really not there to do anything other than to help you organize the Flow a little better, it seems: We can use scopes to put other actions in them, so we can, then collapse and expand those scopes this improving the manageability of the Flow:… 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 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 »
Connection references have been released (well, not quite, but they are in public preview, which is close enough), and, from the ALM support perspective, it might be one of the most anticipated features for those of us who have been struggling with all those connections in the Flows (chances are, if you are using Flows,… 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 »