Platform Banner

Power FX - Text Function Tutorial

Unlock the power of text manipulation in Power FX! In this engaging tutorial, explore essential functions like upper, lower, proper, and trim to enhance user-entered text in your Power Apps. Dive deep into combining these functions for dynamic transformations that boost functionality and presentation. Perfect for low code enthusiasts wanting to elevate their app's user experience! #powerfx #advanced #lowcode

03:25
576 views

Available in Microsoft365

00:00:09

see how they can transform and enhance user entered text.

00:00:13

Imagine you are creating a Power Apps application with

00:00:17

on one side,

00:00:18

a text input named user text where the user can freely enter text

00:00:22

and on the other side a label meant to display the result of our manipulations.

00:00:27

To start,

00:00:28

the upper function is a simple tool that converts all entered text to uppercase.

00:00:33

By using the formula upper,

00:00:34

each letter of the text will be transformed into uppercase.

00:00:38

This function is ideal for standardizing text display,

00:00:41

especially when the case does not matter.

00:00:44

Conversely,

00:00:45

if you want to convert everything to lowercase,

00:00:48

the lower function is your ally.

00:00:51

To give a professional touch to your text,

00:00:53

you might want to capitalize the first letter of each word.

00:00:56

The proper function is perfect for this.

00:00:59

By using this function,

00:01:01

the first letter of each word will be capitalized,

00:01:04

while the rest of the text remains in lower case.

00:01:07

This is ideal for formatting proper names,

00:01:09

titles,

00:01:10

or any other input that requires a neat presentation.

00:01:15

Extra spaces at the beginning or end of the text can sometimes cause issues.

00:01:19

The trim function helps eliminate them.

00:01:21

By using this function,

00:01:23

all spaces at the beginning and end of the text are removed.

00:01:27

For example,

00:01:27

if the user enters Hello world with spaces before and after,

00:01:31

the result will be returned without the extraneous spaces.

00:01:35

This ensures that the text is formatted

00:01:37

correctly without errors due to accidental spaces.

00:01:41

If you need to know the length of the entered text,

00:01:43

the len function is exactly what you need.

00:01:46

You will get the total number of characters in the text,

00:01:49

including spaces and punctuation.

00:01:51

This is useful for imposing length limits or analyzing user input.

00:01:58

Sometimes you need to replace certain words or phrases in your text.

00:02:01

The substitute function offers you this flexibility.

00:02:04

By applying the following function,

00:02:06

every occurrence of the word power will be replaced with Microsoft Power.

00:02:11

This is an effective way to dynamically correct or adapt user entered content.

00:02:16

But why stop there?

00:02:18

By combining several functions,

00:02:20

you can achieve even more powerful manipulations.

00:02:23

Let's take this complex formula.

00:02:25

What exactly does it do?

00:02:27

First,

00:02:28

substitute removes all spaces from the text by

00:02:31

replacing each space with an empty string.

00:02:34

Then upper

00:02:35

converts the obtained result to uppercase.

00:02:38

Next,

00:02:39

Len calculates the number of characters in the text without the spaces.

00:02:44

Finally,

00:02:45

by assembling everything with Ampersson,

00:02:47

we create a complete sentence that displays the

00:02:49

modified text and the number of characters.

00:02:52

For instance,

00:02:53

if the user inputs Hello world,

00:02:55

the resulting output will be as follows.

00:02:58

This combination displays the text without spaces,

00:03:01

all in uppercase,

00:03:03

and indicates the total number of characters,

00:03:05

thus providing an in-depth analysis in a single formula.

00:03:09

By mastering these functions,

00:03:11

you can transform and adapt user text in multiple ways,

00:03:14

thus enriching the experience within your Power App's application.

00:03:18

Feel free to experiment with new combinations to

00:03:20

uncover the full potential of Power FX.

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

491 Views

Video Training Microsoft Power FX : Master Power FX to optimize your applications in a low-code environment

Master Power FX to optimize your applications with powerful and flexible functions in a low-code environment.

ALL COURSES