In the previous post, I wrote about how we can use C# code in Power Automate connectors now. The example given there (converting a string to uppercase) was not that useful, of course, since we could simply use an expression and a “toUpper” function directly in the expression. So I thought of a more useful… Read More »
Did you know that you can easily add C# code to your Power Automate flows? And you will need no azure functions, no plugins, no external web services. You will only need 5 minutes. Although, your code will only have 5 seconds to run, and you will be limited in what exactly you can do… Read More »
Power Automate word templates are much more fun to work with than the classic D365 word templates, yet we can happily use them in the model-driven app with a bit of javascript: https://www.itaintboring.com/dynamics-crm/power-automate-word-templates-in-model-driven-apps-forms-integration/ However, how are we supposed to deploy flows containing “Populate a Microsoft Word Template” action in different environments so that each environment… Read More »
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 »
Form components controls (https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/form-component-control) can be extremely useful. It may not look so, at the first glance, since, after all, what they give us is, essentially, one extra tab on the “main” table form. In that tab, we can display columns from the secondary table. This comes at the cost of not having access to… 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 »