Formula References

These are some of the Power FX formulas that would be useful for your app development in AppAlloy.

This document is still updating...

Syntax	Description
Average	calculate the average value
Concatenate	join multiple text strings into one single string.
Date	represent or create a specific date value.
DateAdd	add or subtract a specified number of days, months, quarters, or years to a date.
DateDiff	calculate the difference between two dates
DateValue	convert a date string (for example, "Sep 18, 2024"), ISO 8601 formatted, to a date/time value.
DateTimeValue	convert a date & time string (for example, "Sep 18, 2024, 9:00PM"), ISO 8601 formatted, to a date/time value.
Day	create conditional logic
If	return the month component of a DateTime value, ranging from 1 to 12.
Month	return the month component of a DateTime value, ranging from 1 to 12.
Now	return the current date and time
Rand	return a pseudo-random number that's greater than or equal to 0 and less than 1
RandBetween	return a pseudo-random integer (whole number with no decimal portion) that is between two numbers, inclusive.
Round	round up if the next digit is 5 or higher. Otherwise, this function rounds down.
RoundDown	round down to the previous lower number, towards zero.
RoundUp	round up to the next higher number, away from zero.
Sum	calculate total value of several numeric data
Text	format a number or a date/time value
Today	extract the month from a date value
Weekday	return the weekday of a Date/Time value, ranging from 1 (Sunday) to 7 (Saturday) by default.
Weeknum	determine the week number of a date, ranging from week 1 to 54 in a year.
Year	extract the year from a date value