Function Explorer
All Power Platform functions at a glance
How the Explorer works
Choose platform
Switch between Power Automate and Power Apps functions.
Filter & Search
Use category filters and full-text search to find the right function.
Copy & Use
Copy function name and syntax directly to your clipboard.
addHours
Date & TimeAdds a number of hours to a timestamp.
addHours(timestamp, hours, format?)addMinutes
Date & TimeAdds a number of minutes to a timestamp.
addMinutes(timestamp, minutes, format?)addProperty
JSON & XMLAdds a property and its value to a JSON object.
addProperty(object, 'property', value)addSeconds
Date & TimeAdds a number of seconds to a timestamp.
addSeconds(timestamp, seconds, format?)addToTime
Date & TimeAdds specified time units to a timestamp.
addToTime(timestamp, interval, unit, format?)coalesce
JSON & XMLReturns the first non-null value from a list of parameters.
coalesce(value1, value2, ...)contains
CollectionChecks whether a collection includes a specific value.
contains(collection, value)convertFromUtc
Date & TimeConverts a UTC timestamp to the target time zone.
convertFromUtc(timestamp, destZone, format?)convertTimeZone
Date & TimeConverts a timestamp between time zones.
convertTimeZone(timestamp, srcZone, destZone, format?)convertToUtc
Date & TimeConverts a timestamp to UTC from a source time zone.
convertToUtc(timestamp, srcZone, format?)createArray
ConversionCreates an array from multiple input values.
createArray(item1, item2, ...)dateDifference
Date & TimeCalculates the time span between two date values.
dateDifference(startDate, endDate)endsWith
TextChecks whether a string ends with a specified substring.
endsWith(text, searchText)formatDateTime
Date & TimeConverts a timestamp into a formatted date string.
formatDateTime(timestamp, format?, locale?)formatNumber
TextConverts a number to a formatted string representation.
formatNumber(number, format, locale?)getFutureTime
Date & TimeReturns the current time plus specified units.
getFutureTime(interval, unit, format?)getPastTime
Date & TimeReturns the current time minus specified units.
getPastTime(interval, unit, format?)greater
LogicChecks whether the first value is greater than the second.
greater(value, compareTo)greaterOrEquals
LogicChecks if the first value is greater than or equal to the second.
greaterOrEquals(value, compareTo)if
LogicReturns one of two values based on whether a condition is true.
if(condition, trueValue, falseValue)indexOf
TextReturns the starting position of a substring within text.
indexOf(text, searchText)intersection
CollectionReturns items that exist in all specified collections.
intersection(col1, col2, ...)join
CollectionMerges array items into a string using a delimiter.
join(collection, delimiter)lastIndexOf
TextFinds the last occurrence of a substring and returns its position.
lastIndexOf(text, searchText)lessOrEquals
LogicChecks if the first value is less than or equal to the second.
lessOrEquals(value, compareTo)nthIndexOf
TextReturns the position of the nth occurrence of a substring.
nthIndexOf(text, searchText, n)parseDateTime
Date & TimeParses a date string into a timestamp value.
parseDateTime(text, locale?, format?)removeProperty
JSON & XMLRemoves a property from a JSON object.
removeProperty(object, 'property')replace
TextSubstitutes a substring with a replacement string.
replace(text, oldText, newText)setProperty
JSON & XMLSets or updates a property value in a JSON object.
setProperty(object, 'property', value)skip
CollectionSkips a number of items and returns the remaining ones.
skip(collection, count)slice
TextExtracts a substring using start and end index positions.
slice(text, startIndex, endIndex)startOfDay
Date & TimeReturns the start of the day for a timestamp.
startOfDay(timestamp, format?)startOfHour
Date & TimeReturns the start of the hour for a timestamp.
startOfHour(timestamp, format?)startOfMonth
Date & TimeReturns the start of the month for a timestamp.
startOfMonth(timestamp, format?)startsWith
TextChecks whether a string begins with a specified substring.
startsWith(text, searchText)substring
TextReturns characters from a string starting at a given position.
substring(text, startIndex, length)subtractFromTime
Date & TimeSubtracts time units from a timestamp.
subtractFromTime(timestamp, interval, unit, format?)union
CollectionMerges multiple collections into one with unique items.
union(col1, col2, ...)xpath
JSON & XMLReturns nodes or values matching an XPath expression.
xpath(xml, 'xpathExpression')Ready for Power Platform?
Book a complimentary Quick Assessment and let us analyze your automation potential.
Book Quick Assessment→More Use Cases
2% of Suppliers Generate 50% of Documents — How a Renewable Energy Company Transformed Its Month-End Close
281 projects, 700 documents per month, 11 utilities causing 50% of the volume. How a renewable energy project office used a Dataverse app and Power BI to relieve month-end close and enable technical operations analysis for the first time.
From Notepad to PDF in 10 Minutes — a Product Configurator for Sunshade Contractors
A sunshade contractor with 30 employees replaced paper-based quoting with a Power App. On-site configuration, automatic PDF generation, e-signature, and seamless document filing — all in one flow.
End-to-End: From Quote to Invoice, Fully Automated
Real automation isn't about optimizing individual steps—it's about connecting your entire workflow. Discover how to build a seamless quote-to-invoice process that eliminates manual handoffs and data entry.