Create Blank PowerApps With Excel As Data Source

In this article, we are going to see “how to create blank powerapps with excel as data source”. Before read the article go through the Introduction to PowerApps and Creating Template with it.

In this article, we are going to see how to create blank PowerApps with Excel as a data source. Before reading the article, go through the Introduction to PowerApps and Creating Template with it.

Step 1

Create a blank app, choose the layout that you want - Phone or Tablet layout.

Create Blank PowerApps With Excel As Data Source

Step 2

It shows the screen to connect with the data. Click -> “Connect to Data”.

Create Blank PowerApps With Excel As Data Source

Step 3

Click -> New connection.

Create Blank PowerApps With Excel As Data Source

Step 4

Choose a connection where you want to save the data. Click -> “one drive for business”.

Create Blank PowerApps With Excel As Data Source

Step 5

Click "Create" (To create a new connection).

Create Blank PowerApps With Excel As Data Source

Step 6

Choose an Excel file or folder (where you save the file).

Create Blank PowerApps With Excel As Data Source

 

Step 7

Choose the table from Excel file that you to want connect with PowerApps.

Create Blank PowerApps With Excel As Data Source

Step 8

Choose table name by clicking the check box.

Create Blank PowerApps With Excel As Data Source

Step 9

Click "Connect".

Create Blank PowerApps With Excel As Data Source

Step 10

Add the data source successfully.

Create Blank PowerApps With Excel As Data Source

Step 11

Click Home -> New Screen -> List.

Create Blank PowerApps With Excel As Data Source

Step 12

Refresh icon – to refresh the records.

Create Blank PowerApps With Excel As Data Source

 

Sorting Icon – sorting based on title

Create Blank PowerApps With Excel As Data Source

 

Add Icon- to add a new record

Create Blank PowerApps With Excel As Data Source

 

Title Bar – title for grid

Create Blank PowerApps With Excel As Data Source

 

To view more details about a particular record

Create Blank PowerApps With Excel As Data Source

Show data title, sub title, image.

Create Blank PowerApps With Excel As Data Source

The above images are shown in the below screen as one.

Create Blank PowerApps With Excel As Data Source

Step 13

Select the grid area to map with the data.

Create Blank PowerApps With Excel As Data Source

Step 14

Click -> Properties -> Choose “Data”.

Create Blank PowerApps With Excel As Data Source

Step 15

Select “Schedule” to map data in the grid.

Create Blank PowerApps With Excel As Data Source

 

Step 16

Choose the Layout to show in the grid. Click -> Down Arrow.

Create Blank PowerApps With Excel As Data Source

 

Step 17

Various types of layout are available in Gallery Layout – Title and subtitle, title subtitle and body, title and image, title subtitle and image. Choose “Title and subtitle”.

Create Blank PowerApps With Excel As Data Source

Step 18

The chosen layout is shown in the drop down. And select title and subtitle value. Click -> Down Arrow.

Create Blank PowerApps With Excel As Data Source

Step 19

Show the Schedule table of columns.

Create Blank PowerApps With Excel As Data Source

 

Step 20

Bind Title – Day and Sub Title – Time. See the table value as below as grid.

Create Blank PowerApps With Excel As Data Source

 

Step 21

Click -> Home -> New Screen -> Form

Create Blank PowerApps With Excel As Data Source

Step 22

Click -> Properties -> Data  ->”No data”

Create Blank PowerApps With Excel As Data Source

 

Step 23

Choose -> Data source -> Schedule

Create Blank PowerApps With Excel As Data Source

 

Step 24

In new form screen, select needed column to add, edit in forms

Create Blank PowerApps With Excel As Data Source

Step 25

Click -> Advanced -> OnSelect textbox remove “false” value

Create Blank PowerApps With Excel As Data Source

 

 Write your formula

Create Blank PowerApps With Excel As Data Source

 

For refreshing icon in grid.

Step 26

Add (+) screen

Add below Formula in Formula bar,

Create Blank PowerApps With Excel As Data Source

 

To add a new record on submit.

Step 27

Change screen (screen 3) close(X) Icon

Create Blank PowerApps With Excel As Data Source

 

Add Formula in Formula Bar - ResetForm(EditForm1);Navigate(Screen2, ScreenTransition.None)

Step 28

Below is the Edit submit button,

Create Blank PowerApps With Excel As Data Source

 

Add Edit submit Formula,

Create Blank PowerApps With Excel As Data Source

 

Step 29

Add delete icon

Insert-> Icons(click down arrow) ->choose -> Trash

Create Blank PowerApps With Excel As Data Source

 

Add Delete formula in formula bar

Remove(Schedule, BrowseGallery1.Selected); Navigate(Screen3, ScreenTransition.None)

Delete Icon added in form,

Create Blank PowerApps With Excel As Data Source

 

Step 30

After running the app, you will see the below screen,

Create Blank PowerApps With Excel As Data Source

 

Step 31

Click > icon to view the detail of the records.

Create Blank PowerApps With Excel As Data Source

 

Click ->Submit the record (Add/Edit).

 Create Blank PowerApps With Excel As Data Source

Below, new records are added for a sample

Create Blank PowerApps With Excel As Data Source

I hope you have found this article helpful.