Book: Revenge of the Tipping Point
Malcolm Gladwell examines the 'rule of thirds' through cheetahs, sports, and crises in this page-turner.
AUTHOR
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.
Excel: Sum Function
Adds numbers, cells, or ranges into a single total. A single error in the range takes over the result.
N8N: Trigger Manually
Starts a workflow manually when you click Execute workflow. Emits a single empty item.
SharePoint: UPPER function
Converts text to uppercase, leaving numbers and punctuation untouched. The result is always text.
Power Automate: isInt function
Checks if a string is an integer.
Add properties to SharePoint files
Add columns to library files so you can filter, sort, group, and find them by metadata instead of folders.
How are things going and new sections.
A site update on how things are going, plus four new sections and open consulting slots.
Book: A Promised Land
Barack Obama's memoir of his early life, Senate years, and rise to the White House. The first of two volumes.
Excel: Count Function
Counts the cells in a range that contain numbers. Ignores text, blanks, and errors.
N8N: Gmail Trigger
Starts a workflow when a new email arrives in Gmail. Polls on a schedule; filter by label, sender, or search.
Power Automate: slice Function
Extracts a substring by position. Supports negative indices; endIndex is exclusive.
The reason it's EMail and not Email or email in Power Automate
Explains why SharePoint's email field is spelled EMail and why the casing breaks your filters