When handling errors in the Flows, we can add parallel branches so one of those would run on success, the other one would run on error. However, in the example below, there is a Flow with two parallel branches configured that way, and, even though “On Error” branch is there, the Flow would only execute… Read More »
The other day, I was wondering if I could, somehow, come up with an app that would be tracking twitter mentions of certain keywords, and, then, do some analytics on top of that. And you know what? It took me 4 hours in total to get it up and running on Power Platform – the… Read More »
With the image columns in Dataverse, we can easily add fields to store images directly in the tables like this: This is great, since this makes all those images/documents much easier to identify than if they are stored in Sharepoint. In terms of storage, those images are stored in the file storage which is cheaper… Read More »
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 »
“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 »
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 »
In one of the earlier posts this month I was seemingly unhappy about the missing “incremental refresh” option: https://www.itaintboring.com/dynamics-crm/power-platform-dataflows-have-i-missed-incremental-refresh-option-somehow/ But, having thought about it a bit more, I don’t think it’s such a big issue. Not when working with the SQL data sources, at least. All we really need is a view that will pre-filter… 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 »