Excel: Countifs Function
Counts the rows that meet several conditions at once. All conditions combine with AND, not OR.
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.
PSA: Update anything PHP related as fast as possible
Two critical PHP flaws let attackers run code on unpatched sites. Fixed in 8.5.12, 8.4.27, 8.3.36 and 8.2.35.
Power Automate: Teams - When a new team member is added Trigger
Starts a flow when someone joins a chosen team. Returns only the user ID and polls every 5 minutes.
Power Automate: Get Future Time Action
Adds an interval to the current time and returns a UTC timestamp. Whole-number intervals only.
What is lazy in Python 3.15 and why it's so exciting?
Loads a module only when it's first used, so imports stay at the top of the file. About 13x faster startup in a test.
Power Automate: Create HTML Table Action
Converts an array of objects into an HTML table for emails and messages. No styling built in.
Power Automate: base64ToString function
Converts a base64-encoded string back into readable text. Takes a string, not a file object; UTF-8 only.
Power Automate: SharePoint - Get file properties Action
Returns a SharePoint file's library column values. Needs the integer item ID, not the file identifier.
Power Automate: triggerOutputs function
Returns the trigger's entire output object, headers included. The body sits one level down.
Issue 003: Get ready for a busy October
October deadlines for Project Online, Publisher and Office 2021, a new way to share files, and a new phishing trick.
Power Automate: Teams - When keywords are mentioned Trigger
Fires when a message in a watched channel or group chat contains one of your keywords. Single words only.
Power Automate: subtractFromTime function
Subtracts an interval from a timestamp you supply. Returns a string; months clamp to month end.