blog on learning how to code
The Power Automate formatDateTime function is definitely one of the hardest to understand. At first, these weird formatting strings look like some encrypted messages by aliens. Locales are even worse. People create crazy complex flows, because they do not understand how easy it is to translate days and month into their language with locales. This …
The Power Automate contains function can be used with strings or arrays. As the name implies, you can check, if a string contains a string or an array contains an element. Note: Power Automate Conditions also offer contains, which may be more suitable for your use case. Power Automate Contains Function The Power Automate Contains …
The Microsoft Power Automate utcNow function returns the current UTC time and date. UTC stands for Coordinated Universal Time. Be aware that you do not get the date and time of your timezone unless your timezone matches UTC. You will learn how to adjust the UTC time to your timezone in this article. Furthermore we …
What are conditions in Power Automate? Power Automate Conditions are the if clauses in Microsoft flows. Whenever you need to decide how to proceed within your flow based on one or multiple conditions, the Power Automate Condition action is your friend. There is also a Power Automate if function which you can use to return …
By using split in Power Automate you can convert a string into an array by defining a delimiter. A classic example is comma separated data in a string. The Power Automate split function returns an array with the data which can be further processed. In this article we explain how to use the Power Automate …
Almost every text editor has the function to replace text, because it is helpful in many scenarios. Microsoft flows naturally offer this feature as well. The Power Automate replace function replaces all occurrences of text with its substitute. In this article the Power Automate replace function is explained in detail and there are many examples …
When I ask myself the first time, how to handle errors in Power Automate. The answer was not that obvious. Coming from a programming background, I wanted to do something like in the following Java example. I want to be able to react on an error for a set of operations. So I tried to …
To check the position of a string or a char within another string you use the Power Automate indexOf function or the Power Automate Find text position. Both work the same. The difference between the indexOf function and the Find text position action is, that the function is used within expressions and the action is …
If statements are the bread and butter of programming environments. Within Microsoft Power Automate If statements can be formulated in two ways. One option is to integrate a Power Automate Condition action as a step into a flow. This way you can open two separate branches within your flow based on the result of the …
The way numbers need to be displayed varies on the context. Prices with different currencies need a different format than serial numbers with leading zeros. The Power Automate Format Number action and the interchangeably usable Power Automate formatNumber function simplifies formatting numbers. Within this article you will learn How to use the Power Automate Format …
Last updated