Power Automate: getPastTime function
Returns the current timestamp minus a number of time units. Always counts back from now in UTC.
Manuel
Over the last 20 years, I have been employed to work with big and small companies. My main focus has been on IT project management and improving the productivity of teams of all sizes thanks to optimizing the usage of Software. My drive is that, thanks to my help, people can focus on their job, save time and avoid frustration. I am specialized in Power Automate, and through my personal website – ManuelTGomes.com – I’ve been able to help hundreds of thousands of people over the last few years. This has made me decide to turn my passion into my job. I started my own company – Skillful Sardine – helping people and companies fix problems by teaching about and optimizing the usage of Power Automate and dozens of other Office 365 tools.
Stuck? Check Your Strategy First
Hitting a wall usually means the strategy is flawed, not the tool. Questions to ask before you push harder.
Excel: Mid Function
Extracts characters from the middle of a text string, starting at a position you choose. Always returns text.
What is uv and why it's so useful in Python?
Installs Python, isolates each project, and manages dependencies with two commands.
Power Automate: Teams - Get message details Action
Returns the full message behind a message ID: body, sender, mentions, and reactions. The body arrives as HTML.
Power Automate: chunk Function
Splits a string or array into pieces of a fixed size. The last chunk is often shorter.
Book: 12 Rules for Life
Not the usual numbered self-help book. Peterson's twelve principles, from Stalin to God to the Bible.
Excel: Sumif Function
Sums the values that meet one condition. A mismatched sum range is silently reshaped, not flagged.
Power Automate: Teams - When a new chat message is added Trigger
Fires when a message is posted in any chat the connected user is in. Returns IDs only, not content.
base64ToBinary function
Converts a base64-encoded string into binary file content. The content type changes; the base64 does not.
What is a connection reference in Power Automate?
A connection stores credentials; a connection reference is a named pointer to one, living inside a solution.
Excel: Countif Function
Counts the cells in a range that meet one condition. Text matching ignores case.