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.
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.
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.
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.
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.
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.
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.
Step 8: Here I have created a new item and you can see, all fields are automatically created in the PowerApps App.
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.
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 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.
You may like following Power Apps tutorials:
- PowerApps form benefits for SharePoint
- How to view PDF files using PDF Viewer in PowerApps
- How to Play Microsoft stream Videos in Power Apps
- PowerApps Combobox from SharePoint List
- Fetch azure groups in PowerApps using PowerApps Azure AD Connectors
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.
Rajkiran is currently working as a SharePoint Consultant in India . Rajkiran having 7+ years of experience in Microsoft Technologies such as SharePoint 2019/2016/2013/2010, MOSS 2007,WSS 3.0, Migration, Asp.Net, C#.Net, Sql Server, Ajax, jQuery etc.He is C#Corner MVP (2 Times).