Power Platform + MS Graph

Jingyi2419 · ‎Aug 16 2022

Through our roles as Microsoft Learn Student Ambassadors, we have actively been part of the Microsoft Learn Student Ambassadors, social impact project, where a group of ambassadors from across the globe work together on a project.

Our project team consisted of the following Ambassadors Gayatri Prabhu, Muhammad Qasim, and me, Jingyi Zhu.

This blog series introduces the Power platform ecosystem with Microsoft Graph with use cases for people from the field of education.

Our goal is to empower readers to build solutions easily and identify undiscovered resources!

Prerequisite:

To learn and build with Power Platform, there is no prerequisite required. We will start from the very basics and will learn the track step by step. In this blog, we are going to answer the questions which evolve in every person’s mind who starts with Power Platform to hone their business. We will learn about this technology in detail and will also define its pros and cons.

So we encourage the readers to start learning Power Platform without worrying about the prerequisites for this learning path.

Expected Outcomes

After learning this track, you will be able to

Work with power platform components to create the best business solutions.
Create custom apps using Power apps without having coding skills.
To automate workflows and repetitive processes using Power Automate.
Analyze data, visualize data and make decisions using analyzed data with the help of Power BI.
Work with the most powerful AI-oriented technology called Power Virtual Agents.

Introduction to power platform

A power platform is a platform that consists of four components and many underlying technologies that all the applications can use. The four components are:

Power Apps
Power Automate
Power BI
Power virtual agents

We will discuss all of them one by one.

So, all these apps combinedly form a powerful platform called Microsoft Power Platform. Microsoft Power Platform is used to provide complex business solutions, analyze the data and make decisions based on analyzed data, visualize the data with the help of graphs, automate a business process, and is used to build virtual agents for communication with humans. The most interesting fact about Power Platform is that everyone can use it without having coding skills because it is drag and drop technology and by just dragging and dropping the components, we can build powerful applications. Along with these powerful tools Power Platform also provides other amazing features like AI builder, Microsoft Data verse, and connectors which adds more functionalities to these apps. With all these extensions and functionalities Microsoft Power Platform is the leading technology in low code/no code development.

The Microsoft Power Platform is used by many businesses – both big and small. The following image shows some of the businesses that have chosen to adopt the Microsoft Power Platform to accelerate their business.

So now it's time to dive into the details of each component of the Power Platform.

POWER APPS

PowerApps is a drag-and-drop interface that allows users to create apps with no-code/low code development. And the apps designed through PowerApps can run on Android, iOS, windows, and on any internet browser, this feature of PowerApps makes it the leader of other app development platforms. PowerApps also provides other services, connectors, and data platforms that help create custom apps for business solutions. PowerApps can quickly transform any manual business into digital operations by providing interactive interfaces and several functionalities for better performance.

How to create a PowerApps app?

First click on this link and sign in or create account. After signing in below interface will appear which provides various data platforms to import data from and create the app. So we will create an app using an excel workbook so I will click on excel

After clicking on excel below interface will appear

This interface shows the various connections for importing data. I will click on one drive for business for importing the excel workbook and then click on create. After clicking on create, select the file as shown below

After selecting excel file, select table as shown below and then click on connect

After clicking on connect below interface will appear

Based on the data, power apps create a default app for us that can be customized by us.

We can now click on icons and can customize them easily. When we click on the play button in the top right corner then the interface changes and we can browse our apps and can check how it will work after publishing

After customizing the app we can use it by selecting the file and then clicking on save as and now we can install it on our phones etc

POWER AUTOMATE

As its name suggest, it’s a tool for automation. It helps automate the repetitive processes by designing workflows for automated communications, automated file synchronization, automated reminders, automated data collection and other task automation. Some of the examples of Power automate workflows are given below:

If we receive an attachment in our email then we can automatically upload it to one drive.
We can send automated emails on fix date and time.
We can automatically send monthly salary slips to our clients.
Automatically add the events to the calendar and get alerts of upcoming events.
Automatically schedule events.
Get automated notifications of tasks to do.

So these are some of the functions which Power automate can do. Power automate can connect to various data sources and API’s for improved automation.

How to create our first workflow with Power automate?

i. Sign in to Microsoft 365 account.

ii. From apps select Power automate and click on it.

iii. After clicking on Power automate below interface will appear.

iv. On the left panel various functionalities are available like data, monitor, and AI builder which can be used for advanced features of workflows.

v. We will create a simple workflow by clicking on “get a push notification when a new file is added in OneDrive for business”.

vi. After clicking on “get a push notification when a new file is added in OneDrive for business” the below interface will appear. Here we need to login to our OneDrive for business account and click on create for notifications tab.

vii. After the above step below interface will appear, here select the folder which we need to monitor for files upload and select the desired settings for push notifications as shown below.

Settings for push notifications

viii. Now click on save in the top right corner to save the workflow. After saving the workflow below notification will appear on the top. We can also test our workflow by clicking on the “test” button.

Power BI

Power BI is all about data visualization and dashboarding. It is useful for visualizing complex data and converting complex numbers into interactive graphs and visuals. As visuals are more understandable than numbers, so Power BI can transform the number and calculations into immersive visuals which can be easily understood by non-technical people.

How to work with Power BI?

i. We can start working with Power BI by using the online web portal or installing the Power BI Desktop app.

ii. Sign up head over to this link and sign up, after signing up we can use either the web-based version or can also install the Desktop app.

iii. In this tutorial we will use the online web-based version. After signing in to the online Power BI website we will have the below interface

iv. On the left panel is create button, click on it and then select “pick a published dataset” as shown below.

v. As I have already a published dataset so I will select a dataset named “time table”. We can add data manually or by copying and pasting data in the online web portal. We can add more data sources in Desktop app but can’t add data sources in the web-based version.
so after selecting the dataset click on create then the below interface will appear.

vi. Here we can create our visuals and dashboards. Various panels are present where we can select our desired options. On the right panel, we have our data where we will select only the desired columns for visualization than on the second are the types of graphs we can use then on the third panel are the data fields and filters for customization. So here can drag and drop our data and can easily visualize our data as shown below

Here we can add further customizations depending on the technicality of the designer.

Power virtual agents

Power virtual agent is that component of Power Platform that is used to create chatbots for automatic communication. It is a drag-and-drop interface where no code is required and there is no need for data scientists or developers for designing powerful chatbots.

So, what are chatbots?

If we have company and we are selling software’s then on daily basis we can have thousands of customers who may face problems while using our software’s or some customers want to know about our company then a single person can’t handle all these customers at a time so what we can do is that we can create a chatbot with the help of Power virtual agents where we will populate all the information and general questions & answers related to our software’s and company, so whenever a customer visits our site and he/she wants to communicate with us then a chatbot will be initiated for conversation and based on the selected problem the solution will be provided by the chatbot.

We can start our chatbot creation journey by clicking on this link Microsoft Power Virtual Agents after clicking on this link create a free account and start working with chatbot creation. The free account is for a limited time but we can practice with chatbot creation for a such limited time.

Below is the interface of power virtual agents chatbot creation.

Features of Power Platform

The power platform has some other powerful features which increase the customization and capabilities of the Power platform. Due to these features Power platform provides robust solutions to almost any kind of business. So the detail of these features is given below:

AI BUILDER:

This feature of Power platform allows users to add AI capabilities to their Power apps and Power automate. This feature makes Power platform intelligent and can make predictions for better business solutions.
To add AI capabilities to our workflows and apps we can locate its button on the left panel in Power automate and in Power apps.

Microsoft data verse:

As its name suggests that it’s a platform for data storage and data integration with Power platforms components. It facilitates the user to add data from multiple resources and integrate it with the power platform for usage. As we need data for every component of the Power platform to make it functional and that data is stored and manipulated in Microsoft Data verse.

Connectors:

Connectors help us to connect apps, data, and devices for cohesive actions and functionalities.
Let's say we have data stored in our Dropbox account and we want to use it in our Power app then we will use the Dropbox connector for importing that data into the Power apps platform. We can use the connector's functionalities by locating it on the left panel in Power apps and Power automate. There are various options available for connecting various connectors, examples of popular connectors include Salesforce, Office 365, Twitter, Dropbox, Google services, and more.

Introduction to Microsoft Graph

Microsoft graph is an API that is used to connect to various services of Microsoft 365 and we can also use it to access data in Microsoft 365, Windows, and Enterprise Mobility + Security. It can add intelligence and security to our apps which will interact with millions of users. It can automate our tasks and can make decisions for us based on the data provided.

We can start our initial journey with Microsoft graph by exploring the “Graph explorer”.

Graph explorer provides samples for creating Microsoft Graph REST API requests. It contains some common scenarios to work with Microsoft Graph API. We can use the sample codes for using Microsoft graph API in our apps and the sample queries are also present which can be utilized in our apps for accessing different services of Microsoft graph.

Graph Explorer includes the following elements:

HTTP verb drop-down list
API version drop-down list
Request query address bar
Sample query
Documentation link for the sample query

Next Steps

if you are interested in further learn these technologies then below are some useful resources

Summary:

In this first blog of the blog series, we have just given the introduction to various components of the Microsoft Power platform. We have introduced each component and also shown that how can we get started with each of these components. In the next section of this blog, we have a little introduction to Microsoft Graph API which is a powerful tool for connecting to a tremendous amount of data and which can also add intelligence capabilities to the business solution.

(from https://www.canva.com/)

Products (50)

Special Topics (27)

Video Hub (462)

Most Active Hubs