Power Automate: Need more than 100 records?
Get past the 100-record limit on SharePoint lists with filtering, pagination, and indexed columns.
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.
Get past the 100-record limit on SharePoint lists with filtering, pagination, and indexed columns.
Returns the number of rows in a single-column table.
Returns true when a value is text.
Returns the position of text within a string. Zero-based; -1 when not found.
Ten habits that make online meetings worth attending, from mute etiquette to being upfront about Copilot.
Sorts a table by one or more columns.