Power Automate: and function
Sometimes one function is not enough, so combining multiple is necessary. To help us with that, we have the “and” function. It combines various functions …
Making your life easier with automation
Function Day is where I’ll explore the basics of some functions and provide some recommendations on how to use them. I’ll focus on Microsoft Flow, SharePoint, and PowerApps since there’s a lot to explore there, but there may be other references showing up in the future.
Please don’t expect an exhaustive list of all functions. You can find that on Microsoft’s excellent reference. I’ll focus on the most common ones and build from there, but I want to make Function Day a thing on this site.
Articles will come out every Thursday, always 1 pm Lisbon Time. Since I have three platforms to explore, you can expect Power Automate, SharePoint, and Power Apps articles, every three weeks. Time permitting I’ll increase the frequency, but I think this is the right balance so that I can keep on delivering valuable information in a defined schedule.
Sometimes one function is not enough, so combining multiple is necessary. To help us with that, we have the “and” function. It combines various functions …
Rounding number is sometimes necessary, and it’s an essential operation in math, but it can be tricky depending on how you do it. That’s why …
Nothing compares to the Power Automate “if “function when it comes to fundamental functions. It exists in all platforms, programming languages, and tools. You name …
Comparisons are an essential part of any platform, and Power Automate has fantastic functions to help us with that. For example, the “greaterOrEquals” function serves …
JSON is a standard used in multiple areas like integrations between systems (like Power Automate connections, for example), so it’s pretty widespread even if we …
Arrays are part of the building blocks of Power Automate. We can get arrays from many actions like the SharePoint “Get Items” action, for example. …
Rounding is a fundamental operation in math, but it can be tricky depending on what you’re rounding. That’s why having the SharePoint “RoundDown” function is …
The “lastIndexOf” function is the corollary to the “indexOf” function, where it returns the last occurrence. It always returns a number, and it will return: …
One of the trickiest things is to keep data consistent, especially if it’s inserted by the users. Each person has their way of providing data, …
The item function is oftentimes misunderstood since it’s not common to be used, but it’s beneficial. For example, when you’re inside a repeating action, like …