Excel: Count Function
Counts the cells in a range that contain numbers. Ignores text, blanks, and errors.
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.
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
Things I won't do in the site
Why I keep ads, affiliate links, guest posts, tracking, and polarizing topics off the site.
Power Apps: LookUp Function
Returns the first record that matches a condition, or a single reduced value. Blank if nothing matches.
Power Automate: isFloat function
Checks if a string is a floating-point number.
Why I prefer to fail forward?
Why I push forward to fix problems instead of rolling back to a safe version
SharePoint: MONTH function
Returns the month of a date as a number from 1 to 12. Empty date fields return 12
Office 365 Outlook Get Attachment
Fetches a single email attachment by its ID, returning its name, type, size, and base64 content.
Power Automate: dayOfMonth function
Returns the day of a timestamp as an integer 1-31.
How to stop an infinite trigger loop in Power Automate?
Stop a flow from re-triggering itself with trigger conditions, flag columns, or a create-only trigger.