Have you ever noticed the following paragraph in the Canvas Apps coding guidelines? Periodically republishing your apps The PowerApps product team is continually optimizing the Power platform. Sometimes, for backwards compatibility, these optimizations will apply only to apps that are published by using a certain version or later. Therefore, we recommend that you periodically republish… Read More »
Just learned the other day that where Power Automate actions can be showing “display” names in various dropdowns, it might still be some sort of ID/Guid that we should be using when trying a custom value there. For example, in the flow below, when using a “custom value”, I have to use a GUID to… Read More »
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 »