Power Automate: Add to Time Action
Shifts a timestamp by a whole number of time units. Negative values subtract; the result is text.
CATEGORY
Microsoft
Welcome to my Microsoft hub, the starting point for everything I write about the Microsoft ecosystem. Here you'll find tutorials, references, and practical tips across the Microsoft 365 and Power Platform family, grouped into focused areas so you can jump straight to what you need. If you build automations, start with Power Platform, where I cover Power Automate, Power Apps, and Power BI. For everyday productivity, browse Excel for formulas and data tricks, Microsoft Teams for collaboration, and Microsoft Planner and Microsoft To Do for keeping tasks organized. Working with data and files? OneDrive, Microsoft Lists, and Microsoft Forms each have their own space with hands-on guides. Developers and admins can dig into Microsoft Graph and PowerShell for scripting across SharePoint, Azure, and Microsoft 365. I also cover Microsoft 365 Copilot, Microsoft Outlook, OneNote, and Shifts, showing how these products fit together in real workflows.
Power Automate: convertToUtc function
Converts a timestamp from a source time zone to UTC using Windows time zone names.
Batch Operations and Throttling Mitigation in Power Automate
Bundle hundreds of SharePoint writes into a single $batch request to stop hitting throttling limits.
Excel: Sum Function
Adds numbers, cells, or ranges into a single total. A single error in the range takes over the result.
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.
Excel: Count Function
Counts the cells in a range that contain numbers. Ignores text, blanks, and errors.
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
Power Automate: isFloat function
Checks if a string is a floating-point number.
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.