Download "PowerApps With Function"

"videoThumbnail PowerApps With Function

0:20

Intro

15:52

New Training Class

16:33

Power Apps Playlist

PowerApps In and Split Functions

PowerApps In and Split Functions

Channel: Shane Young

Power Apps Print function and adding it to your forms and Apps

Power Apps Print function and adding it to your forms and Apps

Channel: Shane Young

PowerApps With Function

Shane Young

PowerApps

PowerApps911

PowerApps Function

Power Apps

PowerApps Record

Shane Young Powerapps

powerapps tutorial

learn powerapps

powerapps records

powerapps video

microsoft powerapps

powerapps in office 365

office 365

bold zebras

microsoft powerapps training

powerapps functions

00:00:00

in today's show we're gonna talk about

00:00:01

the power apps with function look at how

00:00:03

to use this function to make your code

00:00:05

writing easier and a little more

00:00:08

efficient and just generally make your

00:00:10

lights a little better so not a very

00:00:11

complicated video today but this as well

00:00:13

as functions you should add your tool

00:00:14

belt because if nothing else we're gonna

00:00:15

use it to make performance better and

00:00:17

that's something we always care about

00:00:18

but first here's our intro hi my name is

00:00:29

Shane young with power epsilon11 those

00:00:31

guys in today's show we're going toward

00:00:34

the width function right and this is

00:00:35

what as ones where I'm Way more excited

00:00:37

than I should be because you know we're

00:00:39

gonna look at the width function it's

00:00:41

very simple form which breaks not a big

00:00:43

deal but looking at my own code and the

00:00:45

things I've done in the past that I did

00:00:47

not like and the ways that the width

00:00:49

function is gonna let us overcome these

00:00:51

they're pretty exciting so with this

00:00:53

particular video right if you like a the

00:00:54

beginning is really boring I know all

00:00:56

this stuff I get that but the second

00:00:58

half we're going to talk about how I'm

00:00:59

going to use this to make better

00:01:00

performance

00:01:01

that's the stuff you're after probably

00:01:03

so but either way let's just switch over

00:01:05

to my desktop and dive right in okay so

00:01:07

over here on the desktop we're gonna

00:01:08

still label on the screen and start kind

00:01:11

of playing with this thing bigger so we

00:01:13

can see it so what we want to do with

00:01:15

this particular width function is the

00:01:17

idea is that we can pass a record or a

00:01:21

variable we can pass some values into

00:01:23

another function so we don't have to

00:01:25

keep going and calculating those or

00:01:27

looking them up all the time so there's

00:01:28

most simple form you would do something

00:01:30

like this you'd say width and then

00:01:32

you're going to because we're making a

00:01:34

record it's always gonna be curly braces

00:01:36

right so we're going to hold down the

00:01:37

shift key so we can make her curly

00:01:38

braces like that and so inside of here

00:01:41

we're just gonna do something simple

00:01:42

we're gonna be like dog we're just going

00:01:45

to set it to be chewy just like that and

00:01:48

so just like that that is establishing a

00:01:51

record right you'll notice it's very

00:01:52

similar to the context variable way of

00:01:55

looking for things right that's how you

00:01:56

make a record and you can see that power

00:01:58

apps is telling me it's a record so now

00:02:00

you a comma and so then this is the

00:02:02

normal portion in our case this is for a

00:02:05

label so we might just say something

00:02:07

like you know the name of the dog is

00:02:14

close the parentheses don't amber stand

00:02:16

it concatenate and then it autosuggest

00:02:19

force dog that knows that is it within

00:02:22

the scope of where we're at like that

00:02:24

and then just like this the name the dog

00:02:29

is chewy because the idea is that we've put dog

00:02:31

in here you know and we've made it

00:02:34

available through this record if we want

00:02:36

to have multiple right we could say you

00:02:38

know comma and we could do the kid and

00:02:41

we could be like is billy goat huh you

00:02:44

thought I'm doing one of my kids no

00:02:46

right so then we'd expect adult a name a

00:02:48

dog is this and the goat is and then we

00:02:56

can just do ampersand if I ever find it

00:02:59

and then kid boom and so then right

00:03:04

we've just built the string so not

00:03:06

really complicated but I need you to

00:03:07

kind of write we gotta walk before we

00:03:08

can run and so we wanted to make sure we

00:03:10

understood that this in its most simple

00:03:12

form is how we're going to do this all

00:03:16

right we're taking with

00:03:17

boom-boom-boom-boom and we're using it

00:03:19

in a way but now we're using this here a

00:03:20

label this could be part of a patch

00:03:23

function or a part of a lookup or a

00:03:25

filter or some other crazy function that

00:03:28

you come up with right so we're using it

00:03:30

here with the label so it's real easy to

00:03:31

see the output and understand what's

00:03:33

going on but just remember you can use

00:03:34

this with any of the other functions so

00:03:37

now we've kind of seen in a most simple

00:03:40

form that is how we're going to do it so

00:03:42

let's go the next step and so the next

00:03:44

step down here you can see I went ahead

00:03:46

and just made some inputs right I said

00:03:47

just a text input and its default value

00:03:50

is 12 and then this text input is is 6

00:03:53

right and so this one's name text input

00:03:55

1 and this is 1 underscore one guy

00:03:56

copied on so what we could do we can

00:03:59

come up back up here right we're just

00:04:01

gonna use our label again but we could

00:04:03

be like hey so with do our curly braces

00:04:06

again and we're just going to say HW

00:04:09

four hours worked is going to be what

00:04:12

text input 1 dot text now and we want to

00:04:17

use that as a number though so we're

00:04:18

going to put that inside the value

00:04:19

function

00:04:23

and so then we're going to have that was

00:04:26

hours worked and then we'll just do wage

00:04:27

here to avoid confusion I should have

00:04:29

made name so similar sort of value and

00:04:32

so then this is text input one one dot

00:04:36

text like that right so same concept

00:04:41

only thing we did here instead of

00:04:42

hard-coding the values now we're getting

00:04:44

them out of input so they'll update

00:04:45

dynamically and then what do we did

00:04:48

we're going to a comma again and so then

00:04:50

because we're still inside of a label

00:04:53

we're just gonna have some text right

00:04:55

we'll just be like you know ours works

00:04:59

were boom and then we'll do that and

00:05:02

then we'll do that and we'll do with our

00:05:03

HW something like that and then we're

00:05:08

doing ampersand and then we'll do space

00:05:11

again there will be like for wage of

00:05:15

boom boom and then this will be wage and

00:05:21

so there you go we're now making this

00:05:23

but remember with is dynamic so instead

00:05:26

of having to worry about changing any of

00:05:27

these properties right if we go in here

00:05:28

and change the hourly wage to be eight

00:05:30

it's just automatically updating right

00:05:33

right away 13 and eight boom so that's

00:05:35

pretty nice that it's being updated we

00:05:38

can also then use these in here and so

00:05:40

we could be like you and then we could

00:05:44

do like for a total of and then we could

00:05:48

be we need to say you know we want HW x

00:05:52

o times wage o HW right it's got to be

00:05:58

capitalized correctly so I should do

00:06:00

that boom and so then there is it's

00:06:02

calculating is on-the-fly

00:06:03

so because we have full access to those

00:06:06

variables those numbers that we've done

00:06:08

so that's one pass right and we're a

00:06:12

really thinking about this right this is

00:06:13

a really simple example but a lot of

00:06:15

times I have to write really long HTML

00:06:17

emails for customers and I got a pool

00:06:18

different fields in and values and I got

00:06:20

to reuse them and you know having to put

00:06:22

this type of thing in my code value text

00:06:25

input one text pain-in-the-rear whereas

00:06:27

if I could put HW and make it something

00:06:29

that moves more meaningful than HW kind

00:06:31

of like I did with wage over here that's

00:06:33

going to make a better experience ok but

00:06:36

let's go one more step further with this

00:06:38

there's like several more steps we go

00:06:39

let's go to the next step so you can

00:06:41

also take and put these inside of each

00:06:44

others or not inside but you can build

00:06:46

so this was our first width and so it's

00:06:50

outputting this record however here this

00:06:52

is what's the formula well there's

00:06:54

nothing stopping us from just having

00:06:55

another wid to be in our formula and so

00:06:58

then we would kind of do a record again

00:07:00

close or comma and we need another

00:07:02

closing things here we're do format text

00:07:05

it's a little easier to read pull this

00:07:07

down all right so with hwn wage and then

00:07:10

with nothing and they were doing it both

00:07:12

so say we wanted to compute their

00:07:15

earnings ahead of time right so k we

00:07:17

don't want to compute inside our code

00:07:19

right so we have to say earnings and we

00:07:22

can reference it here so as long as

00:07:23

there's no conflict and do HW times wage

00:07:27

so then now right because there's no

00:07:30

conflict we have an access to all three

00:07:32

of these widths but we had to go to the

00:07:35

second width because I want to use the

00:07:36

first widths outputs width is a hard

00:07:38

word for me to say apparently and so

00:07:40

then now we can go right here and we can

00:07:42

change this to be earnings there it is

00:07:45

also suggested and so we've got the same

00:07:47

output right with a total of 80 but you

00:07:50

can see here that now we've kind of

00:07:52

stacked these upon each other and we've

00:07:54

made it sort of pretty easy to read all

00:07:56

right we coming here me real efficient

00:07:58

like Greg was in his blog post bike

00:08:00

this is hourly wage alright put these

00:08:04

are school code comments we got Caesar

00:08:05

for this is or way that was hours work I

00:08:07

really I'm name that HW right

00:08:09

everyone would agree that was a terrible

00:08:10

idea me I do hours worked and then this

00:08:14

is a wage right and then this is

00:08:17

calculated earnings boom but so the idea

00:08:22

is that by getting all these declared

00:08:25

ahead of time we're able to you know

00:08:27

make this a lot easier to read instead

00:08:30

of it saying value text input one text

00:08:33

and I don't once again in these big

00:08:35

emails that I'm writing for customers or

00:08:36

these PDFs that I'm generating

00:08:38

I'm my code today is a hot train wreck

00:08:41

mess so if I could just come up here at

00:08:42

the top in the beginning and say with

00:08:44

and pass all these in here with nice

00:08:46

friendly names then that would make my

00:08:48

life a lot easier so just something for you

00:08:51

guys to kind of think about and use in

00:08:53

here but when it comes to my simple text

00:08:56

inputs like this you know you can you

00:08:58

probably think of seven other ways to do

00:08:59

this I I know I can but what I want to

00:09:03

do is I wanted to show you this so I can

00:09:05

show you more complicated right coming

00:09:07

up here in just a moment and then from

00:09:08

there we're gonna look at the super

00:09:10

stuff that is the part of it that

00:09:11

actually gets me excited so let's just

00:09:13

go to the next piece alright this was

00:09:15

straightforward you know know how to use

00:09:17

the width function so let's go look at

00:09:18

how I used it the first time so over

00:09:22

here I have a gallery that is connected

00:09:24

to a SharePoint list called employees

00:09:25

you if you're watching my videos you've

00:09:27

seen this listed data several times and

00:09:29

so then what I'm doing is over here on

00:09:31

the right basically every time you you

00:09:33

know you select an employers just play

00:09:34

the app so if I click on Greg here

00:09:38

you're gonna see that it's like our

00:09:40

employee details so full names Greg

00:09:42

Peter right as the department its

00:09:43

finance that is not true and his the

00:09:46

department manager is finance Fred so in

00:09:49

his record right in his actual employee

00:09:52

record I am storing if I can ever click

00:09:55

on the department okay so I have that

00:09:57

available but the department manager is

00:10:00

actually kept in a separate list so

00:10:02

here's the way I used to write that type

00:10:04

of code alright so I would say write

00:10:07

department manager equals and then I

00:10:09

would go do a lookup so go get the

00:10:12

manager's name alright so look out from

00:10:15

departments where the title equals the

00:10:17

department from that record if that was

00:10:20

blank then I would put an unknown

00:10:22

because I don't always have depart

00:10:23

managers if it's not blank then I was

00:10:26

actually going to provide you with you

00:10:29

know do the lookup again to get the

00:10:31

manager so it would show you that out

00:10:33

for Greg its finance Fred I hated this

00:10:36

code every time I wrote it and it's I've

00:10:38

got it in dozens of apps because wine

00:10:41

I'm making two calls to my data source

00:10:43

right I'm doing a lookup to see if the

00:10:44

value exists and if it I'd ready to

00:10:46

check to see if I values out there and

00:10:48

if it's blank or not and if it's not

00:10:52

blank then I'm doing the same look up

00:10:53

again to get the same field back so I

00:10:56

can show the field yeah watch how with

00:10:59

makes this so much better

00:11:01

let's go down here so what we did here

00:11:04

as I said all right Department manager

00:11:07

and then I did with and I did the lookup

00:11:10

so I went and fetched that whole record

00:11:12

and that was my width right because with

00:11:14

returns of records that notice my curly

00:11:16

brackets aren't there because I just

00:11:18

needed to go get the record and lookup

00:11:20

returns a record so then I said if is

00:11:24

blank manager right that is the manager

00:11:26

property of that record we just returned

00:11:28

if that's blank then put in unknown if

00:11:31

not then show the manager that's it that

00:11:36

is so easy and clean look at how much

00:11:38

cleaner right this code and our formula

00:11:43

not code and this one do the same thing

00:11:45

that's a hot mess

00:11:47

I can barely keep up with what that does

00:11:49

this one makes a lot more sense so

00:11:52

pretty excited about that possibility

00:11:55

right so I just made my app more

00:11:56

efficient by making those little small

00:11:59

changes so then let's take another step

00:12:02

further and so here is a button that I

00:12:06

wrote and so in this case where I wanted

00:12:08

to do is I wanted to check to see if

00:12:11

Greg if there was a record with the

00:12:14

first name of Greg if that record

00:12:16

existed then I'm going to start that

00:12:19

record doesn't exist so it comes back

00:12:20

blank then what I'm going to do is I'm

00:12:22

going to patch and I'm going to patch

00:12:25

that list default employs that means

00:12:27

create a new records when we create a

00:12:29

new record and set the title to dork and

00:12:31

the first name to Greg if that record

00:12:35

came back with the value so I went and

00:12:36

did a lookup for a record where the

00:12:38

first-name equals Greg if that came back

00:12:40

with a value then instead what I want to

00:12:43

do is patch employees and I would go do

00:12:45

that same look up again boom and then do

00:12:49

the title and it historic ok

00:12:53

so that code works this is very common

00:12:55

right check to see if the record exists

00:12:56

it exists update it if not create a new

00:12:59

one that's the concept there but

00:13:02

terribly inefficient so what does this

00:13:04

one do same thing but now what we're

00:13:08

going to do is we're going to take

00:13:09

advantage of the ability to load that

00:13:12

record now notice here this time I

00:13:14

used curly braces so this is a little

00:13:16

bit different than probably what you

00:13:18

were expecting but the thing you have to

00:13:20

keep in mind is you can't reference the

00:13:22

record right so remember up here when we

00:13:26

did this one right there I loaded the

00:13:29

record the record was here and I could

00:13:30

reference the field a reference manager

00:13:33

but I couldn't reference the whole

00:13:35

record at once I couldn't say here's the

00:13:37

record I can only say here's a piece of

00:13:39

the record so what I'm doing in this

00:13:41

code this is where we got super advanced

00:13:43

for us is we're going to take that

00:13:45

record and we're going to store it in

00:13:47

the value of record right so we've got a

00:13:49

record with a record object inside of it

00:13:51

don't overthink it but now that I've got

00:13:55

this record with a record inside of it

00:13:56

now I can say if is blank record ID

00:14:00

patch employs default employees title

00:14:03

dork blah blah blah if not patch

00:14:05

employees and instead of doing a lookup

00:14:07

again I can do the record I like I can't

00:14:11

put the there's no way to specify the

00:14:15

current record in the width right

00:14:16

there's no way to call it so what you

00:14:18

have to do is you have to assign it to a

00:14:20

record so that's how he's able to write

00:14:22

this code so nice and clean all right

00:14:25

kind of format text man make it easier

00:14:26

see but that's one of those things right

00:14:29

this this this took me a little prodding

00:14:32

to get there right Greg had to kind of

00:14:33

you know walk me to this one but that's

00:14:36

why I want to just cut you guys straight

00:14:38

to the chase and back hey if you want to

00:14:39

put records in here I think what my

00:14:41

standards gonna be is going to just

00:14:43

always be to make a record named record

00:14:45

so then that way you know this code is a

00:14:48

little more complicated right instead of

00:14:50

just saying ID it has to say record ID

00:14:52

because I want the ID of the record

00:14:54

inside the record but by doing this it

00:14:57

has made my life here made this possible

00:15:01

so that's the key so I think for me

00:15:04

right if you're one of my consultants

00:15:06

watching this I think this is gonna be

00:15:07

our standard way for using this

00:15:09

particular guy curly brackets around it

00:15:11

boom we're off and running

00:15:13

so that is that and just like that folks

00:15:18

we now know how to use the width

00:15:20

function I said super jazzed about this

00:15:22

it is going to make your code easier to

00:15:24

read easier to follow less of this on

00:15:27

change stuff and carrying around

00:15:29

variables that you didn't need before

00:15:30

and less calls to your data sources

00:15:33

which we're always about right we're

00:15:34

always trying to make our apps a little

00:15:36

bit faster so hopefully you enjoyed this

00:15:38

video if you did you know I've got a

00:15:40

million more out here to check out you

00:15:42

know you leave me comments if you have

00:15:43

questions or other ways you're using

00:15:45

with I always respond to my comments I'm

00:15:47

about a week behind typically but I

00:15:48

always respond if you need help right

00:15:51

reach out power apps 9-1-1 we've got a

00:15:53

new training class launching next week I

00:15:55

haven't told anybody else you guys are

00:15:57

the first ones to know but we are trying

00:15:59

to create more you know we've got all

00:16:01

those great YouTube's videos I was like

00:16:02

75 of them at this point but we're also

00:16:04

trying to make more formal type of

00:16:06

training available throughout power-ups

00:16:08

and I 101.com slash training so with all

00:16:11

that said I'm late for a meeting so

00:16:12

thanks and have a great day

00:16:17

hey it's me again if you got a second

00:16:20

click the subscribe button that always

00:16:22

keeps me making more videos or if you

00:16:24

want to work together need some help

00:16:25

getting your power apps going hit me up

00:16:27

with power apps nine-one-one always

00:16:29

happy to work together or finally if

00:16:31

you're always looking for more videos

00:16:32

that's probably what it is check out the

00:16:34

power apps playlist over here and you

00:16:36

know enjoy that all right

00:16:37

thanks and have a great day

Description:

In this video, you will learn how to use the PowerApps With Function. This makes for cleaner formulas and better performance. PowerApps Training https://www.powerapps911.com/training

Preparing download options

Popular

HD video

Only sound

All

* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."

** — Link intended for online playback in specialized players

Questions about downloading video

How can I download "PowerApps With Function" video?

http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

Which format of "PowerApps With Function" video should I choose?

The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

Why does my computer freeze when loading a "PowerApps With Function" video?

The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

How can I download "PowerApps With Function" video to my phone?

You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

How can I download an audio track (music) to MP3 "PowerApps With Function"?

The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

How can I save a frame from a video "PowerApps With Function"?

This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

What's the price of all this stuff?

It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.