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.
CATEGORY
Power Automate
Welcome to my Power Automate hub, where I share what I have learned building real cloud flows for work and for fun. If you have ever stared at a flow that almost works, this is where you fix it. You will find practical, hands-on guides that go beyond the basics and tackle the messy parts of automation. I cover advanced error handling patterns so your flows fail gracefully, and I dig into API rate limits and throttling, including batch operations and throttling mitigation, so your flows keep running when you scale up. I walk through building a website monitor from scratch, handling CSV files without losing your mind, and troubleshooting dynamic content when the values you expect simply are not there. My best practices for SharePoint across multiple environments save painful mistakes, and my approval workflow guide makes one of the most requested features easy to understand.
Power Automate: uriScheme function
Returns the protocol from a URL: 'https', 'ftp', or any valid scheme.
Power Automate: What is a Key Column in Excel?
Power Automate: Office 365 Excel - Delete Row action
Removes a row from an Excel table by key column value.
Power Automate: Office 365 Outlook - Get email action
Returns an Outlook email by Message ID.
Power Automate: uriPathAndQuery function
Returns the full path and query string from a URL.
Power Automate: uriPath function
Returns just the path segment from a URL.
How to solve the JSON Invalid type error in Power Automate?
Power Automate: OneDrive for Business - When a file is modified (properties only) Trigger
Fires when a OneDrive file is modified. Returns metadata only, not content.
Power Automate: startOfMonth function
Returns the first day of any month.
Power Automate: OneDrive for Business - When a file is created (properties only) Trigger
Fires when a OneDrive file is created. Returns metadata only, not content.
Power Automate: OneDrive for Business - Create file action
Creates a file in OneDrive for Business.