Posts

Showing posts with the label Power Fx

Important Power Fx formulas

Power Apps Formulas Reference (Top 50) A handy reference of the most commonly used Power Fx functions in Power Apps. # Function Description 1 If() Checks a condition and returns one value if true, another if false. 2 Switch() Compares a value against multiple cases and returns the first match. 3 IsBlank() Returns true if a value is blank. 4 IsNumeric() Checks if the value is a number. 5 Len() Returns the number of characters in a string. 6 Left() Extracts characters from the start of a string. 7 Right() Extracts characters from the end of a string. 8 Mid() Extracts a substring from a string. 9 Upper() Converts text to uppercase. 10 Lower() Converts text to lowercase. 11 Trim() Removes extra spaces from text. 12 Concatenate() Joins multiple text strings. 13 Concat() Joins values from a table into a single string. 14 Today() Returns the current date. 15 Now() Returns the current date and time. 16 DateAdd() Adds days,...