Skip to main content
Manuel T Gomes

Automation Expert and Software Engineer

Home
Microsoft ▾
  • Power Automate
  • Power Apps
  • SharePoint
  • More ▸
    • Planner
    • Teams
    • Forms
    • Lists
    • Excel
    • Outlook
    • OneDrive for Business
    • Shifts
    • OneNote
    • To Do
    • PowerShell
Apple ▾
  • Xcode
  • Shortcuts
Python
Reference ▾
  • Power Automate Functions
  • Power Automate Actions
  • Power Automate Triggers
  • Power Apps Functions
  • SharePoint List Functions
  • OData Reference
  • N8N Triggers
  • Excel Functions
  • Power Automate Cookbook
  • Expressions Cookbook
Tools Newsletter Need Help?

Reading comfort

Set it once. We'll remember it for every visit.

Text size
Theme
Reduce motion
CATEGORY

Power Automate Function Reference

Power Automate expressions are where a lot of the real magic happens, and this is my reference for the functions that power them. When the point-and-click designer runs out of road, a well-placed expression gets you exactly what you need. I document the everyday date and time helpers like the "addDays" function, the "addHours" function, and the "addMinutes" function, along with the more flexible "addToTime" function for shifting timestamps. I cover math with the "add" function, logic with the "and" function, and data shaping with the "addProperty" function and the "array" function. Need to convert data types? The "base64ToBinary" function gets its own walkthrough, and the "action" and "actions" functions let you reach into earlier steps. Every entry gives you the syntax, the parameters, the return value, a practical example, and the edge cases that catch people out.

Power Automate: parseDateTime function

Power Automate: parseDateTime function

13 min read · 5 days ago

Converts a date string into an ISO 8601 timestamp using a locale and optional format. Locale comes second.

Power Automate: convertTimeZone function

Power Automate: convertTimeZone function

14 min read · 1 week ago

Converts a timestamp between two time zones, daylight saving included. Output drops the zone marker.

Power Automate: getFutureTime function

Power Automate: getFutureTime function

11 min read · 2 weeks ago

Returns the current timestamp plus a number of time units. Always counts from UTC now.

Power Automate: convertFromUtc function

Power Automate: convertFromUtc function

11 min read · 3 weeks ago

Converts a UTC timestamp into a target time zone. Returns a string with no offset or Z marker.

Power Automate: convertToUtc function

Power Automate: convertToUtc function

8 min read · 1 month ago

Converts a timestamp from a source time zone to UTC using Windows time zone names.

Power Automate: isInt function

Power Automate: isInt function

8 min read · 1 month ago

Checks if a string is an integer.

Power Automate: slice Function

Power Automate: slice Function

11 min read · 1 month ago

Extracts a substring by position. Supports negative indices; endIndex is exclusive.

Power Automate: isFloat function

Power Automate: isFloat function

6 min read · 1 month ago

Checks if a string is a floating-point number.

Power Automate: dayOfMonth function

Power Automate: dayOfMonth function

5 min read · 2 months ago

Returns the day of a timestamp as an integer 1-31.

Power Automate: decimal function

Power Automate: decimal function

8 min read · 2 months ago

Converts a string to a precise decimal number.

Power Automate: less function

Power Automate: less function

4 min read · 2 months ago

Returns true when the first value is smaller than the second.

Power Automate: range function

Power Automate: range function

5 min read · 2 months ago

Creates an array of consecutive integers from a start and a count.

← Previous Page 1 of 8 Next →
Manuel T Gomes

Helping teams and developers plan, build, and automate, and sharing what I learn along the way.

No ads. No third-party trackers. Written by a human.

Topics

  • Power Automate
  • Reference
  • Python
  • SharePoint
  • Apple & Shortcuts

Site

  • Blog
  • Recommendations
  • Newsletter
  • About
  • Contact

Legal

  • Privacy Policy
  • Cookie Policy
  • Livro de Reclamações
© 2026 Skillful Sardine, Unipessoal Lda. All rights reserved. From Portugal to the World.