Canvas App Creation in different Methods

Power Apps is a suite of apps, services, connectors and data platform which enables users to build feature-rich, custom business apps without writing code

Types of Power Apps:

  • Canvas
  • Model-driven
  • Portal

Here we are going to see canvas app creation with One drive data in different methods

Prepare One drive Data:

Create an Excel with below columns and upload that file in One drive location.

Excel Columns

Power Apps Sign in:

After signing into power apps, we can see the below landing page.

Landing Page

In this, we have Two sections

  • Start from Data
  • Make your own app

Click Canvas app from section 2

This will redirect to Power apps Studio where we can create your own layout.

Below is the power apps studio landing page.

Apps Studio Landing Page

Click Data sources Pane and go to connectors

Datasource

Here we are going to use One drive for business data.

Click One drive for Business and sign and create connectors.

After a successful connection, Power apps will show the available files in one drive.

Here I am going to use the emp.xlsx file.

Xlsx

After selecting file, it will show the table available in .xlsx file.

Table

Click Connect

Table Connected

Navigate to Tree view to create Screens for app

Screen

Here only one screen is created, so we need to create our own layout like Screens, actions, buttons, control scripts, so it’s quite difficult.

To avoid this complication, we will use the second method to create an app, in this method all the browse screens, buttons, control scripts are created automatically.so it will reduce the manual efforts in the apps Creation.

Method 2:

Instead of creating a canvas app from section 2, start from the data option in the  section 1.

Section1

Click One drive for Business to connect data

Section1-Onedrivedata

Connect the required Table

TableMethod1

Click Connect

Loading

while loading,Power apps will create all the required screens,buttons,Scripts in Background.

After the Loading completed, all the Screens are created automatically.

Screens

Below are the elements created inside the Screens automatically

Browse Screen:

Browsescreen1

Detail Screen:

DetailScreen1

Edit Screen:

EditScreen_1

Click Preview to view the Designed App.

PowerappsPreview

Click Plus button to add entry and enter the required Data.

Powerappseditscreenpreview

Add Data to the Fields and save .

Testentry1

Click Save and below is the Final screen and it contains the recently added data.

FinalScreen

Go to the one drive file location and see the entries to check whether the write back is works or not.

writeback

Recently added Data from the Power apps is updated one drive data location.This is how the write back works .

By using Method 2,we can easily create canvas without any complications and Manual works is avoided .