How to generate an Excel ID to access data in Power Automate
by Everyone uses Excel in one way or another, so the next logical step is to integrate it with Power Automate and create some automation on …
Tag: Best Practices
I’ll show you the best practices for the Power Platform tools. I provide them based on my experience and learning, so that doesn’t mean you can’t adjust them. I learned them from other people’s experiences also, so I don’t make the same mistakes.
Consistency is important, especially when multiple people work on the same platform. I see all the time SharePoint sites with heterogeneous naming, lists with convoluted names, and more. Having consistency enables you to know always what something means. It also helps when someone comes aboard where you can point to the rules and know what to do.
Regardless of the platform, I strongly recommend that you don’t want to adopt mine, at least have them written down on your side. Even if you work alone, create your best practices and reference material. It will make you think, and sometimes you’ll see where some things could be improved.
Power Automate: How to Get Your Flow’s Name
You might need to access your Flow’s name when building complex Flows for various reasons. You may create a custom logging system, want to include …
Power Automate: coalesce function
The “coalesce function” is one of those hidden gems in Power Automate that can save you much time and make your flows more robust. I’m saying “hidden …
Power Automate: max function
The “max” function is a powerful tool in Power Automate that helps you find the highest value in a set of numbers. Although it’s not …
Power Automate: Converting Strings to Integers
When working with data in Power Automate, you’ll often encounter strings that need to be converted to integers for calculations or comparisons. This is a …
Power Automate: mod function
Power Automate’s “mod” function helps you find the remainder after dividing one number by another. While it might not be the first function that comes …
Microsoft / Microsoft 365 Outlook / Power Automate / Power Automate Trigger Reference / Power Platform / Reference
When a new email arrives in a shared mailbox trigger
Having shared mailboxes can help a lot of a team’s productivity. You can have multiple people looking at the same inbox and dealing with emails …
Power Automate: dateDifference function
The “dateDifference” function is a powerful tool for when you need to calculate the difference between two dates. It gives you a reliable way to …
Power Automate: Convert Time Zone Action
If you have ever had to deal with time zones, you know how hard it is to convert them. It’s a complex problem, so we …
Power Automate: workflow Function
The “workflow function” is one of Power Automate’s most useful functions, especially when you need to reference information about your current Flow. While not immediately …