Hello, everyone. Welcome to
Microsoft 30. We came together.
We're excited today to teach you guys a little bit about the
Things we're do the powerapps and microsoft graph. We are catching up back stage.
He's been telling me about the exciting things they've been doing in the space.
You want to tell the audience a little bit about that? >> yes.
Many of you have heard about microsoft graph today.
Microsoft graph is the platform
That has all of the data that you can access.
And you are going to be talking to some very exciting examples
On how you can use the powerapps framework to build local
Applications very quickly that take advantage of microsoft
Graph on the back end. Look at the slides.
You can see the microsoft stored across the difficult products
Are all linked to each other. That's what we mean by graph.
It's not just the brand name of the api but how all of the
Elements are linked to each other and how they are access
Able and available to you using
Thissen is on the spi. The second thing i wanted to
Point out on the graph side is
Doesn't matter what data you are provide access.
This is how you can leverage all of the data to graph using prams.
Before that, can you explain
What powerapps is? >> it's on the business
It allows people to come in and quickly build a business
Application and go to market very quickly with an app that
Connects to various different data sources.
You can build these within a matter of days.
So we're going to dive in, give you some examples of what we're talking about.
So when we start with the business application platform,
We think about powerapps and power bis.
As we expand this out a little bit. If you look at the left side, we
Have your transactional data. This is your common data service
For apps and then on the right, we have the analytics side.
This is what we could refer to as the common data for analytics.
And then we have over 200 connectors that connect not only
To your microsoft but cross various different products and
Data sources and then tie it all together, this is built on
Azure. It's easy accessible at the
Azure platform. Some of the core capabilities,
As i mentioned, we can -- kind of a way to quickly build your applications.
You can automate that through the use of microsoft flow and
Then we have this rich data connector against different end points.
As we get into the extension scenario, this allows you
Professional developers to come in and build custom connectors
As well as azure functions. Once you build a custom
Connector, this can be accessible to other power users
So your citizen developers, you can expose your functions to
Them within the powerapps and they can build their
Applications without knowing how to write code.
>> So for the rest of the session, we want to make it very
Interactive and hands on. In order to make it easy for you
To use graph, inside perhaps, they are launching ten new
Sample template apps. These are available right now in
Power apps.
They will teach you how to use one of the various connectors.
Let's jump into the powerapps demo.
You will be able to see all of these templates.
We've taken some of the common applications and built out examples.
If you break into each of these examples, you
Will learn the connector. One is an app that is a meeting capture.
The meeting capture app is designed to be a
Companion for anyone in meetings.
But first, capture app, you can see this is going to list all of
Your vail meetings. This is coming from our calendar
Api. So now we've picked the first
Meeting and immediately you can see that in the ui at the top
Of attendees. This is coming from the graph
Api, information about the person, photos as well as the
Meeting information. Here you can put in notes and
Create tasks. Maybe let's fill in some sample
Tasks here. And what is happening as we're
Building out all of this data, all this is being built out in
Powerapps. We've created some sample notes and tasks.
Program, you can see the notes it's created.
So the main takeaway here if you
Go into powerapps today and crack open one of these
Examples, you don't have to
Figure out from start. All of these exist from today
And you can go in and start to leverage.
So scheduling a live meeting. The other wart we wanted to show
You is calendar. This one shows you how you can
Do calendar integration as well. One important aspect of
Calendaring scheduling which is how you find available meeting
Times for the variety of people.
This intelligently figures out the best time.
Here casey has picked attendees and the api is giving you back
What are the best teams. If you are trying to build a new
Calendar, you can take this example at a starting point and
Start building from that. Now, what you've done is you've
Creating some notes, scheduled a follow-up meeting and let's go
To see what has happened. So all of this, as you can see,
You can see, the time is 4:30 p.M.
This is the e-mail that's being sent out.
One of the things is it's very nice formatted e-mail.
And powerapps allow us to do this sort of, you know,
Picture-perfect content being sent out.
Some of that, if you look at the first, one that's the calendar.
That, again, is being sent to powerapps. So the main thing take away that
We want to find out from all of this, powerapps is a very
Powerful way to build applications and we have
Examples using graph for you to get started.
Let's go back to planner and you can see that
Planner 2018. If you go there, you want to see
That the task is created. So now let's maybe have casey
Explain to us how this works. So you can, you know, crack this
Open and bring your own extensions of this. >> All right.
Thank you. So early, we gave you an
Overview as well as some of the graphs. Right now, i have the graph open.
I wanted to give you an extension scenario.
Graph has an api called relevant people. You can see it here in the app
That we have the ability to add additional attendees once we
Send the meeting notes. My extension scenario is that
Instead of just being able to search for attendees, we also
Want to have relevant people that you normally interact with
On a day-to-day basis be recommended within the app and
Have that shown by default so you can quickly add the people
In because they are people you normally interact with.
The first thing we're going to do, we have this control here
And we want to control the visibility of this.
So let me just go down and get this.
I'm going to copy and paste these functions.
I will talk through them as we go. So the user research gallery
Here, we have this visibility control. We want to put some conditional
Logic around this. What i'm saying here is that if
The search box is blank or if it contains
Data, then -- sorry. If the search box is blank, then
We're going to set the visibility of this and then as i
Go in here -- let me copy this again.
Once we set the visibility of that, we're going to insert
Another gallery on top of this. Let me do this.
We're going to go insert. Insert. A blank vertical gallery.
And the data source, i'm going to enter this formula.
We're going to re-size this gallery
Here. Move it in place.
I get these nice grid lines to snap it in place and make it
Picture perfect and have a nice design element around it.
And then for the items we want to display, let me paste this
Function in here. Like i said, we're using the --
The connector that hits the graph and point.
It's the office 365 users connector. I already have the data source
Added within my app. We're calling relevant people
And we are going to get that e-mail address for relevant
People. Okay.
Copy this.
Now, similarly how we set the visibility on that other item, i
Want to do that here. If the other
Gallery is not displayed we're going to display
This one instead. We're going to display the
Relevant people if the research box is not populated with data.
Okay. Next we're going to go ahead and
Insert a label for this.
And we're going to do this item, display name.
Let me just remove that. Try that again here.
Insert the label.
Fin fin nicky.
Once this is selected.
Come on. There we go.
And so up here where you have the collection created that's
Listing all of the attendees for the meeting.
What i'm going to do is add an icon in.
A plus into the new gallery that i just inserted. Okay.
We're going to move that right over here so we have the ability
To add this, add the person and
Then we want to set the on select property here. Okay.
So for this collection that we had created, we this e-mail being sent.
We're going to pass in the upn as well as the display name for
The user. Okay. I haven't applied a lot of
Formatting to the search box here. We can make that look better but
Just given the interest of time
-- Of time i'm going to play it. It's returning all of the
Relevant people and i can go ahead and add these in, once again.
Once we export this, it will send it to those people.
All right.
Okay. That's a quick introduction on
Our session. There's more in-depth sessions.
One that goes in depth about building customer connectors,
That's tomorrow at 1:15 and then we also have one for -- on the
Microsoft graph connecting to a central data and that's also
Tomorrow. So thank you, everyone, for listening.
We have some references here. Meeting capture that goes into
More detail about how the app was built.
There is also video documentation as well as
Detailed documentation on the website that we'll be releasing
Shortly. Check out the powerapps that we
Talked about. Be sure to check that out as
Well as the graph reference. Thank you.
Ct-[ applause ]