Power Automate: Office 365 Excel - Add a key column to a table action
Adds a key column to an Excel table so other Excel actions can reference rows.
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.
Adds a key column to an Excel table so other Excel actions can reference rows.
Returns the protocol from a URL: 'https', 'ftp', or any valid scheme.
Removes a row from an Excel table by key column value.
Returns an Outlook email by Message ID.
Returns the full path and query string from a URL.
Returns just the path segment from a URL.
Fires when a OneDrive file is modified. Returns metadata only, not content.
Returns the first day of any month.
Fires when a OneDrive file is created. Returns metadata only, not content.
Creates a file in OneDrive for Business.