Excel: Countif Function
Counts the cells in a range that meet one condition. Text matching ignores case.
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.
New Power Automate now requires connection references
Convert a solution flow from a direct connection to a connection reference and unlock the new designer.
SharePoint: YEAR function
Returns the year of a date as a number between 1900 and 9999. Empty dates return 1899.
Power Automate: parseDateTime function
Converts a date string into an ISO 8601 timestamp using a locale and optional format. Locale comes second.
How to insert multiple values into a SharePoint Lookup field?
Writes multiple values into a SharePoint lookup column by mapping each tag to its list item ID.
The site is 7 years today
Seven years of the site. The newsletter is live, new reference areas launched, and old articles updated.
Excel: Averageif Function
Averages the values that meet one condition. Returns #DIV/0! when nothing qualifies.
Issue 001: Welcome! Power Platform changes and some bonus recommendations
The first issue: what's coming to the Power Platform, what's leaving Power Automate, and a few things worth reading.
Why it's not a good idea to update the dependencies right away?
Delaying dependency updates by a few days blocks most supply chain attacks. Cooldowns in uv and pip.
Power Automate: Office 365 Outlook - Get emails Action
Returns an array of emails from a mailbox folder. Filter fields only scan the first 250 emails.
Power Automate: convertTimeZone function
Converts a timestamp between two time zones, daylight saving included. Output drops the zone marker.
Power Automate mobile apps, the Excel add-in and personal accounts are going away
Power Automate is dropping the mobile app, the Excel add-in and personal accounts. What changes and when.