SharePoint Online : Quick Chart and FLOW implementation

Quick chart is an a graphical representation of the data in SharePoint list. Below is an example of how to represent the data of Assets and Send for approval using FLOW.

As soon as asset crated/allocated to the business user by system administrator total quantity gets reduced from Asset Type list by the allocated number.


Step 1: Create a SharePoint master list called Asset in SharePoint online and create the following columns to represent data or to add data in list.

Asset List:

Step 2: Create AssetType, Department(Business Unit), Supplier list as shown below screenshot. Add a lookup to the master list "Asset" with reference to the below list for a Title column (Refer screenshot of Asset list)

Asset Type:

Departments:

Supplier:

Steps 3: create a modern UI page and add the quick chart webpart and configure as shown below and click okay.

Steps 4: Quick Chart and graphical representation of data shown as below.

FLOW: FLOW is used to perform the activities in SharePoint list. 

Here FLOW is used to reduce or maintain the availability of quantity in Asset Type list as soon as Asset is assigned to business user.

Step 1: Go to list Asset

Step 2: Click on "Create a FLOW" which redirects to the FLOW UI where user can create the activity

Steps 3: Add a action "When a new item created" and configure the details as per the below. Select the Site details and list

Steps 4: Add a action "Get Items" and configure the site address and list. Here we have to select the  list AssetType

Step 5: Add a action "Apply to each" and select "Compose" (Data operation action) and add the following operation in "input"

sub(item()?['Total'],1)

This operation suggest that take the column "Total" and reduce the quantity by 1.

Step 6: Add a action "Condition" and configure as shown below

In condition action, specify that if the Asset Type which is the field from "Current item" is equal to "Title" field return from "Get items activity" are equal then set the Total column as "Output" as shown in figure.

PowerApps

What is PowerApps? The Most suitable service provided by Microsoft for building business app that connect to your data across the Web and Mobile without the custom software development

How to verify the email address in PowerApps?
1. To check the valid email in PowerApps use the Email function
2. Create a Canvas app form and add the TextBox Control
3. Select the Color property from the event drop down and add the following
4. If(IsMatch(txtEmailAddress.Text, Email), Black, Red)
5. Run the Form it shows the following details on correctly entering the email address

6. Else it display error as shown in below