Today we're going to talk about life cycle management using
Microsoft flow and power shell. Principle program manager on the
Build project team. Joining me.
>> I'm a program manager in the power apps and customer
>> I'm going to start the session by talking app life
Cycle management using porocele. This is a feature that's been
Requested by customers, perhaps some of you in the audience.
People want more visibility into power apps and flow consumption
Within the enterprise. So we've recently released a set
Of power shell command lets. This was initially part of our
Gdpr release in support for that regulation. What we've done is made these
Power shell mantles available for everyone at this specific link.
You can use this in your day-to-day operations of apps
And flow. Similarly, you can manage your
Power app pes. You can manage who has access to
Specific power apps and the same goes with flow. In the case of flow, you have
The ability to also enable or disable flows.
You as an administrator if you weren't happy about something, you would have the ability to go
Ahead and enable or disable those flows if you required.
Now, what i'm going to do today is show a demo.
I'm going to show how you can take advantage of these tools
Today and build a power bi desktop fbi x file and include
One for download and how visualize the telemetry coming
Out of your power apps and flow environment. I'll go ahead and get into that
Now. When you go ahead and download
The package from the web page previously, you'll see a series
Of different power shell commandlets. Weave included an additional one
For downloaded to called tenant-wide app and flow usage.
That's what i'm going to go ahead and kick off right now.
So naturally i'm going to need to provide my credentials for
This. That's running.
It's going to run for about three minutes.
We don't need to watch the blinker while it occurs.
Let me flip over to the power shell itself.
If we take a look at the power shell, we'll see basically
Constants where we define the different types of files that
Will be output from this. We'll see a list of applications
In the case power apps. A list of power apps with their
Related permissions and similarly for flow.
We're beyond some of the initial that we construction here.
We'll go ahead and do can speech factory call out to a power
Shell command thes i previously referenced. In this case it is the get admin command.
It allows an admin to go ahead and generate a list of all apps
Or power apps within their specific tenant.
From there, we'll loop through each of those apps and through
Each of the connections within those apps in order to
Understand the connectors involved in that app.
Simulation lay already, the permigration services or who the
Connection has been shared with so you get a of users using
Those connections.
This is an example of the flow one. Here we're going to see the
Environment the flow belongs to. We'll have the internal guit,
The time created and modified. Naturally we're going to want to
Have a user friendly display name as part of that
Output. Which is this column e right here.
Then probably most importantly for a lot of folks is the flow
Connections here we're going to see essentially a delimited list
Of connectors that were involved in that specific flow.
This is pretty cool. It's a step forward.
It's going to give you visibility in terms of how people are using flow and power
Apps within your environment. That's not readily digestible.
You can't make lot of sense scanning through a file, especially if you have hundreds
Of flows or power apps within your environment.
Wear going to use the power of power bi.
I'm a big fan of power bi. It's a great tool for
Visualizing the data. In this case, csv files that can
Naturally be consumed into power bi. We can use power query to
Perform transformations on the data itself.
We had a semicolon limited list of connectors not readily digest
Digestible. We need to be able to go and
Inspect the data itself. In this i specific example, i've
Got a test tenant where i've got four different environments that
Have been configure. Within these four different
Environments, 22 different flows and we've got 11 different
Connectors that have been used. I can go ahead and slice and
Dice and actually see the breakdown of where all of these
Assets are actually hosted by from an environment erinspective.
I also have the ability to go ahead and see who are my user
That are actually involved in these flows or the power apps.
We're talking about how many different users have access to
These nose so i can see the admin user has access, whether
That be beas an owner or contributor for 17 of these 22 flows.
I can go ahead get a sense of when they were created and take
Advantage of power bi with some of its slicing capabilities in
Order to reduce the time frame to understand exactly when these
Flows were actually created. Similarly, i can use the data
From uptated timestamp as well. If i was interested in the
Frequency and the occurrence of an update that
Happened. Sorry. Let's flip to power apps.
What we'll desee is a very similar capability.
We're using a different file in this case the apps permissions
File. I have the ability to see
Similar data. In this case, five different
Environment as cross 28 different apps.
I've got 13 different connectors being used.
Within here, we'll see different connectors being used, then flow.
As an admin, this might be a prompt for you to take a look at
Your data loss prevention nderstand
The usage of how people are using power apps and flow and
Creating the right policies that line up for your organization.
We also have the ability to determine the app access by user
As well so we can see once again this admin user has access to a
Lot of apps. We can see some other users
Don't have as much access. Then similarly we can go ahead
And define or understand when our our apps were created and
The related timelines around that. So while this is something you
Can go ahead and try this out today and i'll provide the, let
Me flip back to the slides.
You can go ahead and download this package of this power shell
Script plus the pbix today and you can go ahead and build this
On your own and have it running tonight if you wish. Just want to make a call out.
James was the person that wrote this scripps you'll download.
And his team in conjunction with medi and a few others were
Involved in the development of these different power shell scripts.
Another thing coming from an admin perspective is we are
Providing some admin analytics. Those should show up soon.
So that will be a managed experience where you'll be able
To go and see the analytics for a specific environment for
Yourself without running a power shell chant lets.
Power bi ingests this data from a way if you wish as well.
With that said, i'm going to hand it over to machining edi.
He's going to talk about other admin opportunities.
>> All right. Let me switch.
Do you have the clicker? all right.
So what we have today is a flow management connector.
What you really get out of what you saw previously is a set of command complain line.
It allows you to to a lot today, have partial b v script.
That's not the only way to react with admin ais.
You can use an existing keckor today. It does a lot out of the box.
There are a lot of interesting
Interesting -- so out of the -- so the flow management connector
You have today will allow you to do a lot of what you saw had
With the command line. It can could create connection,
Get flow, get flow get a bunch of information about your flow
And basically function amount to administer your froes.
So one of the templates we have out of the box is that comes
With flow, i'm going to switch to all right.
So we have a template that lists all the, an exam of a flow using
The functionality is the list new microsoft flow connection.
It basically lists all the connections that your flows have.
I'm going to start with that. I'm going to just show a little
Bit how it's set up. As you can see, you have a
Regular flow, you have a set of recurrence that runs every day.
You have again the users of that connector, list connector a pick a.
It gives you. You can set up your own
Environment. I'm going to use, say, power
Apps. Make sure administrator writer
That. Power
Apps. Basically, what you get here is
A listive connectors. You are interesting in filtering
This information down to basically all the -- you
Basically want to get all the connectors that were created x
Number of days before today. Every keckor will get all the
Information you get out of the connector is the tick.
Basically it's the time where the particular connector was created.
You compared that to basically today's date minus x number of days.
In this case for just simplicity, minus one day.
It's occurring every day. The next step we'll dough is
Filter out all the connectors that were created over the last
24 Hours. Then what we are going to do
Later is basically create a report out of that information,
Oracle, a report containing all the details about which
Connector was created by which person.
If i run that, just before
Simplicity, for ease of time, we going to get a report like this
One where you get the created date time of a particular
Keckor. You could add any information to
Your report. In in essence what you get out
Of the connectors is the ability to have much more interesting
Scenario from a management perspective. You can find out all the flows
Created by your users. You can find out which connector
Were used. Similarly to the power shell,
You can use flow to give you notifications of when certain
Event happened.
That's what we have today. Coming real soon is the ability
To do basically the same sort of interesting flow with power apps.
Today we don't have a connector out of the box but i'll show a
Preview dem owe he for what it lacks like. Basically, beverage your apps
That you're creating in your environment, listing, getting
All the information you have, the creator of the app, the
Connectors that are used for an app, basically all sorts of informing you can get today out
Of the power shell, you could use a connector to get the same information.
And the scenarios are unlimited. You can monitor for high users
Of your app, find out what are the latest apps created.
You could create even app that's monitor the most viral of your apps.
So here's an example of that. Here you can see i'm using an
Environment, again, to get all environment.
Going through every app.
In this case, again, i'm using the timestamp to filter all the
Apps i'm interested in looking at. Here, again, i'm doing give me
All the apps created in all of my environments so i can see
What's the latest apps created.
Here's an example of my report. A much nicer looking report.
Basically tells you these are all the apps create in n this
Specific environment.
Again, the scenarios are multiple. You could just basically go
Ahead and create whatever you need today that is not out of the box in our admin center, for example.
The last thing i want to show, again, just to wrap it up, we
Have the use of this keckor. You can create app as well,
Power app to monitor and manage your own environments and apps
Within the environment. This is an example of where i'm
Using custom connector and i can see here i have power apps
Environment and power apps flow connector that i have.
And i'm basically listing out all the environment i have and i
Can pick any particular environment, find out all the
Apps i have in that environment, i can delete it, share, approve,
You can imagine having multiple environments you're creating
Apps in one environment and you want to ensure you have a way to
Review those apps and publish and approve and publish them in
Different production environment, let's say.
That's all i have. >> Can we put it back on the
Download page? so i guess some key takeaways
From this perspective is we do provide, like, graphical user
Input text faces for it. Mid center.
Collapses or unified admin center coming soon across the
Business application platform. But what we also with our
Customer it's s when you have a small number of services or
Assets, it's easy to manage through a gui.
Once you have a more and more assets, you want to web able to
Program at i cannily assets and manage them through something
Like power shell or through a management corrector.
That's the goal of what these tools are.
And the power shell is available today. You can go ahead and start
Today. The additional management keckor
For power apps will be coming soon. Thank you all for joining our