Power Automate: SharePoint - Get file properties Action
Returns a SharePoint file's library column values. Needs the integer item ID, not the file identifier.
TAG
Common Questions
Some questions come up again and again, so I gathered them here in one place. This tag pulls together the practical answers I keep reaching for: whether Power Automate can run Python or PowerShell scripts, how to fix the changes conflict error in SharePoint, how to stop an infinite trigger loop, and how the "Parse JSON" action really behaves. You will also find function walkthroughs like the Excel "Count" function, the Power Apps "LookUp" function, and the Power Automate "isInt" function. Instead of theory, each article answers a specific question with a concrete fix you can apply right away. If you have hit one of these walls yourself, chances are the answer is already written down here, waiting for the next time it trips someone up.
My Claude best practices (so far)
Prompting rules built by trial and error. Pick the right model, curate context, and iterate on your own process.
Power Automate: Join Action
Joins an array into a single string with the delimiter you choose. An empty array returns an empty string.
Power Automate: getPastTime function
Returns the current timestamp minus a number of time units. Always counts back from now in UTC.
Power Automate: Teams - Get message details Action
Returns the full message behind a message ID: body, sender, mentions, and reactions. The body arrives as HTML.
Power Automate: Teams - When a new chat message is added Trigger
Fires when a message is posted in any chat the connected user is in. Returns IDs only, not content.
What is a connection reference in Power Automate?
A connection stores credentials; a connection reference is a named pointer to one, living inside a solution.
Excel: Countif Function
Counts the cells in a range that meet one condition. Text matching ignores case.
New Power Automate now requires connection references
Convert a solution flow from a direct connection to a connection reference and unlock the new designer.
SharePoint: YEAR function
Returns the year of a date as a number between 1900 and 9999. Empty dates return 1899.
Power Automate: Office 365 Outlook - Get emails Action
Returns an array of emails from a mailbox folder. Filter fields only scan the first 250 emails.
SharePoint Permissions in Power Automate
Which account really runs each action, and why a flow that works for you returns 403 for everyone else.