We will use our PowerApps app to add, update, and remove records to an excel file that is displayed in OneDrive for Business in Office 365.
The PowerApps app will use OneDrive for Business as its data source.
so, login to your Onedrive for Business and create a Excel workbook
Next, make some columns and fill them with information. I’ve put a few columns here.
We will now see how to set up a data source in Power Apps for OneDrive for Business.
Next, log in to Power Apps and navigate to Connections, where you can create new connections.
When you pick OneDrive for Business, the newly created Excel book will be displayed.
Next, click on it, and it will display you a table name, as shown in the screenshot below. Select that table, and then click on the connect button.
Once the connection is established, you will be redirected to a new screen where you may see the record you created in the excel book.
When you select the Excel data source, PowerApps will create the apps for you instantly. This app will be completely functional.
