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.
SharePoint: REPT Function
Repeats a string N times. Result capped at 2000 characters.
Power Automate: Access an Excel with a dynamic path
Access an Excel file from a dynamically built path, working around the connector's no-dynamic-path limit.
Power Apps: Now Function
Returns the current date and time. Volatile.
Power Automate: Invalid Connection
Power Automate: addMinutes Function
Adds or removes minutes from a date with a custom format. No date range limits.
Power Automate: How to not go insane dealing with email
SharePoint: Now Function
Returns the current date and time as a serial number.
Power Apps: Round Function
Rounds a number to a given decimal place using half-round-up.
Power Automate: addDays Function
Adds or subtracts days from a date. The day count must be an integer, not a decimal.
Power Automate: Power Automate as a Web Service
SharePoint: Today Function
Returns today's date as a serial number.