How to create a PowerApps Canvas app from Excel OneDrive for Business data source

In this Power Apps tutorial, we will discuss how to create a PowerApps canvas app from Excel OneDrive for Business data source.

We will insert, update, and delete records to excel presented in OneDrive for business in Office 365 from our PowerApps app.

The data source for the PowerApps app will be OneDrive for Business.

Microsoft provided more than 200 external data sources in power Apps where we can connect easily and we can do the CRUD operations.

So here I am using OneDrive as data source to do some operation.

Create a PowerApps Canvas app from Excel

Now, we will see how to create a canvas app in Power Apps from excel that is presented in OneDrive.

Step 1: Login to your Onedrive for Business and create a Excel workbook.

create a PowerApps canvas app from Excel

Step 2: Next create some columns and enter some data. Here I have added a few columns like FirstName, LastName, Phone, DateOfBirth, Address, and Pin, etc.

How to create a PowerApps canvas app from Excel

Step 3: Now, we will see how to create the data source for OneDrive for business in Power Apps.

Next login to the Power Apps and go to the connections and create new connections.

Power apps onedrive for bussiness

Step 4: Once you select OneDrive for Business, it will ask you to login, Once you successfully login, it will show you the newly created Excel book.

OneDrive for Business data source powerapps

Step 5: Next click on it and it will show you a table name like below screenshot and select that table and click on the connect button on below.

It is better to give a meaningful name for the table in excel in OneDrive for business.

connect to onedrive for business in powerapps

Step 6: Once the connection got successful, it will automatically redirect to a new screen where you can see your record which you have created in the excel book.

By default, when you will select the excel data source, PowerApps will automatically create the apps for you. This will be a fully functional app.

powerapps onedrive excel

Step 7: Next run it and see the record which you have created in the excel.

We can create an item by clicking on the + (Plus) icon, it will open the create new item screen.

creating an app from excel microsoft powerapps

Step 8: Here I have created a new item and you can see, all fields are automatically created in the PowerApps App.

creating an app from excel powerapps

Step 9: After click on save, the new record has been created successfully and you can see the Power Apps All item screen.

You can also click on the > icon to see the details of the particular item. This will open the View screen in Apps.

powerapps excel data source

Step 10: Now, if you will open the OneDrive for business, you can see the item has been added to the excel sheet or the excel workbook.

When we update the item, the item will be updated in the excel sheet also.

In the same way, if you delete an item from the PowerApps app, the item will be deleted from the excel workbook in OneDrive for business.

powerapps refresh excel data source

PowerApps excel data source is read only

If get an error, powerapps excel data source is read only then you can fix like below, you can click on Protect workbook.

powerapps excel data source is read only

You may like following Power Apps tutorials:

In this tutorial, we learned how to create a PowerApps Canvas app from Excel OneDrive for Business data source also we saw how to fix an error PowerApps excel data source is read only.

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>